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)