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

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.