Hi, I encounter an unexpected behavior of UNION operator.

It unions columns based on the order of columns of the first table, instead of union by column name.

for example- this statement returns expected results of column A: 100, 200

and column B: 1, 2

SELECT A,B FROM (SELECT 100 AS "A", 1 AS "B" FROM DUMMY)A 

UNION 

SELECT A,B FROM (SELECT 2 AS "B", 200 AS "A" FROM DUMMY)B

but below queries return unexpected behavior, mixing the columns

(e.g. column A: 100, 2 and column B: 1, 200)

SELECT 100 AS "A", 1 AS "B" FROM DUMMY 
UNION 
SELECT 2 AS "B", 200 AS "A" FROM DUMMY; 


SELECT * FROM (SELECT 100 AS "A", 1 AS "B" FROM DUMMY)A 
UNION 
SELECT * FROM (SELECT 2 AS "B", 200 AS "A" FROM DUMMY)B; 

(using HANA version 1.00.102.00.1442292917)