[teiid-issues] [JBoss JIRA] (TEIID-4160) Impala - result set is not sorted if ORDER BY is defined in query

[Juraj Duráni (JIRA)]

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)