[
https://issues.apache.org/jira/browse/CALCITE-634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14370427#comment-14370427
]
Sean Hsuan-Yi Chu commented on CALCITE-634:
-------------------------------------------
In the original query, ordinal reference is in order by actually.
The exception is thrown here: AggChecker.java (line 117).
And it seems Calcite does not allow aggregation function to be in ORDER BY
clause if there is SELECT DISTINCT.
However, as, in this query, this aggregation function is simply an entity in
the select clause,
calcite might be less restrictive?
> Failure to order by if DISTINCT clause is present
> -------------------------------------------------
>
> Key: CALCITE-634
> URL: https://issues.apache.org/jira/browse/CALCITE-634
> Project: Calcite
> Issue Type: Bug
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Julian Hyde
>
> For example, the query
> {code:sql}
> select distinct count(empno) from emp
> group by empno
> order by 1
> {code}
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
