[CALCITE-754] Validator error when resolving OVER clause of JOIN query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 08/Jun/15 17:03
• Updated: 01/Sep/15 03:02
• Resolved: 13/Jun/15 01:12

Description

A query such as :
select sum(t1.deptno) over(partition by t1.deptno)
from emp t1, emp t2

would raise exception:
org.apache.calcite.sql.validate.SqlValidatorException: Column 'EMPNO' is ambiguous.

Calcite cannot point the column in OVER-CLAUSE to the JOINed table.