[CALCITE-774] When Group By clause is present, the argument in window function should not refer to any column outside Group By

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 26/Jun/15 00:13
• Updated: 01/Sep/15 03:02
• Resolved: 14/Jul/15 01:28

Description

An invalid query such as:

select max(empno) over () 
from emp
group by deptno

This query is invalid because the argument in max (i.e., empno) points at a column which is not present in Group By clause. However, Calcite does not catch it but generate a plan.

Invalid queries should fail early to reduce potential confusion.