[
https://issues.apache.org/jira/browse/CALCITE-754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau closed CALCITE-754.
----------------------------------
Resolved in release 1.4.0-incubating (2015-08-23)
> Validator error when resolving OVER clause of JOIN query
> --------------------------------------------------------
>
> Key: CALCITE-754
> URL: https://issues.apache.org/jira/browse/CALCITE-754
> Project: Calcite
> Issue Type: Bug
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.4.0-incubating
>
>
> 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)
