[jira] [Commented] (CALCITE-5253) NATURAL join and USING should fail if join columns are not unique - expression validation partially broken

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17683785#comment-17683785 ] 

Evgeny Stanilovsky commented on CALCITE-5253:
---------------------------------------------

[~asolimando] seems issue with Status: closed (as this one) is not gathered by release notes filter [1] isn`t it ?

[1] https://github.com/apache/calcite/blob/calcite-1.33.0-rc0/site/_docs/history.md

> NATURAL join and USING should fail if join columns are not unique - expression validation partially broken
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-5253
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5253
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.31.0
>            Reporter: Evgeny Stanilovsky
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.33.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> Such issue is not possible for now: 
> {code:java}
> CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);
> CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);
> CREATE TABLE t3(c INTEGER, d INTEGER, e INTEGER);
> SELECT t1.c, t2.d, t1.b, t1.a, t3.e FROM t1 natural join t2 natural join t3;
> {code}
> cause:
> {noformat}
> SqlValidatorException: Column name 'C' in NATURAL join or USING clause is not unique on one side of join
> {noformat}
> This validation is correct for example for case :
>  
> {noformat}
> select e.ename, d.name from dept as d natural join (select ename, sal as deptno, deptno from emp) as e
> {noformat}
> but fails as described above.
> Was broken by:
> [1] https://issues.apache.org/jira/browse/CALCITE-5171



--
This message was sent by Atlassian Jira
(v8.20.10#820010)