Impala - result set is not sorted if ORDER BY is defined in query ----------------------------------------------------------------- Key: TEIID-4160 URL: https://issues.jboss.org/browse/TEIID-4160 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.x Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Fix For: 9.0, 8.12.5, 8.7.6.6_2, 8.13.4 Query: {code:sql} SELECT g_1.StringNum AS c_0 FROM Source.SmallA AS g_1 WHERE g_1.IntKey <= 50 UNION ALL SELECT g_0.StringNum AS c_0 FROM Source.SmallB AS g_0 WHERE g_0.IntKey > 50 ORDER BY c_0 {code} Result: as you can see, nulls are not next to each other |StringNum| |-24| |<null>| |-14| |-13| |-12| |-11| |-10| |-9| |-8| |<null>| |-6 |-5| |...| Expected result: this is result of simple query SELECT stringnum FROM source.smalla ORDER BY 1 |StringNum| |-1| |-10| |-11| |-12| |-13| |-14| |-15| |...|