[ https://issues.apache.org/jira/browse/CALCITE-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mihai Budiu resolved CALCITE-6370. ---------------------------------- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/a7c1e8ac774f0ca602ed598f9dd0aef99ca7ad23 Thank you, [~njordan] for the contribution > 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 > Assignee: Norman Jordan > Priority: Major > Labels: pull-request-available > Fix For: 1.38.0 > > > 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)