[jira] [Resolved] (CALCITE-754) Validator error when resolving OVER clause of JOIN query

["Julian Hyde (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-754.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.4.0-incubating

Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/87acda31.

[~seanhychu], thanks for the patch! In the end, I used your test case (see http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/ebce955d) but developed a better fix.

> 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)