Allow usage of select expressions in order by, even with group by/distinct. --------------------------------------------------------------------------- Key: TEIID-1250 URL: https://jira.jboss.org/browse/TEIID-1250 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.2 We currently do not allow order by keys to reference anything other select aliases if a simple query uses distinct or group by. We could allow for the projected expressions to resolve as well. For example: select x as y from t group by x order by x instead of order by y Mondrian generates queries of this form, although I'm not sure if that's something that could be customized through Mondrian. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira