[teiid-issues] [JBoss JIRA] (TEIID-3854) Impala translator - ORDER BY clause using incorrect columns when not in SELECT list

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3854.
-----------------------------------
    Resolution: Done


Resolved by removing support for unrelated order by so that order by columns will always reference the select clause.

> Impala translator - ORDER BY clause using incorrect columns when not in SELECT list
> -----------------------------------------------------------------------------------
>
>                 Key: TEIID-3854
>                 URL: https://issues.jboss.org/browse/TEIID-3854
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.1, 8.12.2
>         Environment: Ubuntu Trusty on AWS
>            Reporter: Don Krapohl
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 8.13, 8.12.3
>
>
> We have a scenario in which users want to see month and day names but the data should be sorted by month and day NUMBER.  The translated query comes back sorted the wrong column.  Oddly in the ORDER clause the translator uses the month name column alias when we specify the month number, day name when we specify day number.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)