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

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde commented on CALCITE-2904:
--------------------------------------

This sub-query is invalid:
select c,c*a from  (values 2) as t(a)
and therefore the whole query is invalid. I'm not sure why Postgres thinks it is valid.

>  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
>            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)