[CALCITE-1327] Nested aggregate windowed query fails

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

Description

Regression from CALCITE-750 Allow nested window aggregates.
Calcite allows illegal queries instead of raising an appropriate error. When executing the following query calcite does not raise the following error.

select avg(sum(b)) over (partition by b) from t1;
ERROR:  Expression 'b' is not being grouped

Issue Links

• is related to: CALCITE-750 Allow windowed aggregate on top of regular aggregate
• is related to: CALCITE-1340 Window aggregates invalid error/error messages in some cases