[teiid-issues] [JBoss JIRA] (TEIID-4160) Impala - result set is not sorted if ORDER BY is defined in query
Juraj Duráni (JIRA)
issues at jboss.org
Thu Apr 21 06:36:00 EDT 2016
Juraj Duráni created TEIID-4160:
-----------------------------------
Summary: 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
Affects Versions: 8.12.x
Reporter: Juraj Duráni
Assignee: Steven Hawkins
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|
|...|
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list