[jira] [Closed] (CALCITE-774) When Group By clause is present, the argument in window function should not refer to any column outside Group By

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau closed CALCITE-774.
----------------------------------

Resolved in release 1.4.0-incubating (2015-08-23)

> 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)