[CALCITE-1346] Invalid nested window aggregate query with alias

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Gautam Parai
• Reporter: Gautam Parai
• Created: 05/Aug/16 21:30
• Updated: 27/Feb/24 22:23
• Resolved: 08/Aug/16 22:28

Description

The following query should fail but does not!

SELECT max(sum(sal)) OVER (partition by deptno) AS maxSal
FROM emp
WHERE deptno > 10;