[
https://issues.apache.org/jira/browse/CALCITE-774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-774.
---------------------------------
Resolution: Fixed
Fix Version/s: 1.4.0-incubating
Fixed in
http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/e51f853f.
Thanks for the pull request, Sean!
> When Group By clause is present, the argument in window function should not
> refer to any column outside Group By
> ----------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-774
> URL: https://issues.apache.org/jira/browse/CALCITE-774
> Project: Calcite
> Issue Type: Bug
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Julian Hyde
> Fix For: 1.4.0-incubating
>
>
> An {color:red}invalid{color} query such as:
> {code}
> select max(empno) over ()
> from emp
> group by deptno
> {code}
> This query is invalid because the argument in max (i.e., empno) points at a
> column which is not present in Group By clause. However, Calcite does not
> catch it but generate a plan.
> Invalid queries should fail early to reduce potential confusion.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
