[jira] [Assigned] (CALCITE-2904) Column not found in table when query contain duplicate table alias

["Danny Chan (JIRA)" <ji...@apache.org>]

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

Danny Chan reassigned CALCITE-2904:
-----------------------------------

    Assignee: Danny Chan

>  Column not found in table when query contain duplicate table alias
> -------------------------------------------------------------------
>
>                 Key: CALCITE-2904
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2904
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Haisheng Yuan
>            Assignee: Danny Chan
>            Priority: Major
>
> Repro:
> In SqlToRelConverterTest.java, add this test.
> {code:java}
> @Test public void testDuplicateTableAlias() {
>     final String sql = "select * from (values 4) as t(c) "
>         + "left join lateral "
>         + "(select c,c*a from "
>         + "    (values 2) as t(a)"
>         + ") as r(d,c) "
>         + "using(c)";
>     sql(sql).ok();
>   }
> {code}
> Error message:
> {code:java}
> org.apache.calcite.runtime.CalciteContextException: At line 1, column 60: Column 'C' not found in table 'T'
> {code}
> The tables with same aliases are at different level. Postgres can parse this query without any issue. Not sure if this is expected behavior or not in calcite.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)