[ https://issues.apache.org/jira/browse/CALCITE-2904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16794128#comment-16794128 ]
Haisheng Yuan commented on CALCITE-2904: ---------------------------------------- Me either. But I tried to run the following query on Postgres, Mysql, Oracle, Sql Server, SQLLite, all of them successfully execute the query: {code:java} create table r(r1 int, r2 int); create table s(s1 int, s2 int); select * from r where r1 in (select s1 from s r where r2=s2); {code} > 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)