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)
