[
https://issues.apache.org/jira/browse/CALCITE-1340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15406036#comment-15406036
]
Zelaine Fong commented on CALCITE-1340:
---------------------------------------
Your Q2 and Q3 look like the same queries. Typo?
Perhaps you meant for Q3 to be the second problem you noted in your comment on
8/1 in CALCITE-1327?
> Window aggregates invalid error/error messages in some cases
> ------------------------------------------------------------
>
> Key: CALCITE-1340
> URL: https://issues.apache.org/jira/browse/CALCITE-1340
> Project: Calcite
> Issue Type: Bug
> Reporter: Gautam Kumar Parai
> Assignee: Gautam Kumar Parai
>
> Queries which fail (or fail with inconsistent errors)
> Q1:
> {code}select count( * ) over () from emp group by deptno
> AssertionError: star should have been expanded.
> {code}
> Q2:
> {code}
> SELECT sum(empno), max(empno) OVER (order by deptno)
> FROM emp
> GROUP BY empno
> gives error: Expression 'DEPTNO' is not being grouped
> SELECT sum(empno), max(empno) OVER w
> FROM emp
> GROUP BY empno
> WINDOW w as (order by deptno)
> gives no error:
> {code}
> Q3:
> {code}
> SELECT sum(empno), max(empno) OVER (order by deptno)
> FROM emp
> GROUP BY empno
> gives error: Expression 'DEPTNO' is not being grouped
> SELECT sum(empno), max(empno) OVER w
> FROM emp
> GROUP BY empno
> WINDOW w as (order by deptno)
> gives no error:
> {code}
> Q4:
> {code}
> select cume_dist() over w , rank()
> from emp
> window w as (partition by deptno order by deptno)
> Assertion Error: Expression 'DEPTNO' is not being grouped
> instead of
> Assertion Error: OVER clause is necessary for window functions
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
