[jira] [Created] (CALCITE-6370) AS operator problems with USING clause

["Claude Brisson (Jira)" <ji...@apache.org>]

Claude Brisson created CALCITE-6370:
---------------------------------------

             Summary: AS operator problems with USING clause
                 Key: CALCITE-6370
                 URL: https://issues.apache.org/jira/browse/CALCITE-6370
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.36.0
            Reporter: Claude Brisson


In some cases, with the {{USING}} clause, the used column generates ambiguity exceptions with the {{AS}} operator.

 

OK : {{select r_regionkey from region r0 join region r1 using (r_regionkey)}}

OK : {{select r_regionkey * 2 as rk2 from region r0 join region r1 using (r_regionkey)}}

KO : {{select r_regionkey as rk from region r0 join region r1 using (r_regionkey)}}

 

The last query generates the following error:

 
{code:java}
 org.apache.calcite.sql.validate.SqlValidatorException: Column 'r_regionkey' is ambiguous
    at jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance (DirectConstructorHandleAccessor.java:62)
    at java.lang.reflect.Constructor.newInstanceWithCaller (Constructor.java:502)
    at java.lang.reflect.Constructor.newInstance (Constructor.java:486)
    at org.apache.calcite.runtime.Resources$ExInstWithCause.ex (Resources.java:507)
    at org.apache.calcite.runtime.Resources$ExInst.ex (Resources.java:601)
    at org.apache.calcite.sql.SqlUtil.newContextException (SqlUtil.java:948)
    at org.apache.calcite.sql.SqlUtil.newContextException (SqlUtil.java:933)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError (SqlValidatorImpl.java:5517)
    at org.apache.calcite.sql.validate.DelegatingScope.fullyQualify (DelegatingScope.java:296)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.findTableColumnPair (SqlValidatorImpl.java:3989)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.isRolledUpColumn (SqlValidatorImpl.java:4032)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.checkRollUp (SqlValidatorImpl.java:3945)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.checkRollUp (SqlValidatorImpl.java:3940)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.checkRollUp (SqlValidatorImpl.java:3959)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.checkRollUpInSelectList (SqlValidatorImpl.java:3861)
    at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect (SqlValidatorImpl.java:3849)
{code}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)