[CALCITE-1340] Window aggregates invalid error/error messages in some cases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Julian Hyde
• Reporter: Gautam Parai
• Created: 02/Aug/16 18:07
• Updated: 27/Feb/24 22:23
• Resolved: 04/Aug/16 23:23

Description

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

Issue Links

• relates to: CALCITE-1327 Nested aggregate windowed query fails