[jira] [Created] (CALCITE-754) Failure to resolve a column in OVER-CLAUSE if that column is produced by a JOIN

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

Sean Hsuan-Yi Chu created CALCITE-754:
-----------------------------------------

             Summary: Failure to resolve a column in OVER-CLAUSE if that column is produced by a JOIN
                 Key: CALCITE-754
                 URL: https://issues.apache.org/jira/browse/CALCITE-754
             Project: Calcite
          Issue Type: Bug
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Julian Hyde


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)