-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.9.0
-
Component/s: None
-
Labels:None
Queries which fail (or fail with inconsistent errors)
Q1:
select count( * ) over () from emp group by deptno AssertionError: star should have been expanded.
Q2:
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:
Q3:
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
- relates to
-
CALCITE-1327 Nested aggregate windowed query fails
-
- Closed
-