[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 closed TEIID-3854.
---------------------------------


> 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.12.3, 8.13
>
>
> 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)