[CALCITE-634] Allow ORDER BY aggregate function in SELECT DISTINCT, provided that it occurs in SELECT clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 19/Mar/15 23:33
• Updated: 16/Apr/15 08:35
• Resolved: 24/Mar/15 00:41

Description

For example, the query

select distinct count(empno) from emp
group by empno
order by 1

gave:

org.apache.calcite.sql.validate.SqlValidatorException <init>
SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Expression 'COUNT(`EMP`.`EMPNO`)' is not in the select clause