Lantao Jin created CALCITE-4729: ----------------------------------- Summary: Column in CTE should be ambiguous Key: CALCITE-4729 URL: https://issues.apache.org/jira/browse/CALCITE-4729 Project: Calcite Issue Type: Bug Components: core Reporter: Lantao Jin
{code} create table test (a int); with t as ( select * from test t1 join test t2 on t1.a=t2.a ) select t.a from t; {code} The above query fails with 't.a' is ambiguous in Spark/Presto/Postgres. But it succeeds in Calcite. Currently, many and many companies use Calcite as a query federation layer upon multiple query engines such as Spark and Presto. But this behavior confused users. -- This message was sent by Atlassian Jira (v8.3.4#803005)