[CALCITE-6473] HAVING clauses may not contain window functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 16/Jul/24 12:55
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

according to the standard:

ISO/IEC 9075-2:2011(E)
7.10 <having clause>
Syntax Rules # 5

The <search condition> shall not contain a <window function> without an intervening <query expression>.

Issue Links

• links to: GitHub Pull Request #3859