Gautam Kumar Parai created CALCITE-1340:
-------------------------------------------
Summary: 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)
