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

[RH Bugzilla Integration (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

RH Bugzilla Integration updated TEIID-4160:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1329178
        Bugzilla Update: Perform


> 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)