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

[Don Krapohl (JIRA)]

Don Krapohl created TEIID-3854:
----------------------------------

             Summary: 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.2, 8.12.1
         Environment: Ubuntu Trusty on AWS
            Reporter: Don Krapohl
            Assignee: Steven Hawkins


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)