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

["Haisheng Yuan (JIRA)" <ji...@apache.org>]

Haisheng Yuan created CALCITE-2904:
--------------------------------------

             Summary:  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


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)