[
https://issues.apache.org/jira/browse/CALCITE-5588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17705033#comment-17705033
]
Jiajun Xie commented on CALCITE-5588:
-------------------------------------
This error can be reproduced in join.iq
{code:java}
> Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 2 out of bounds
> for length 2
> at
> com.google.common.collect.RegularImmutableList.get(RegularImmutableList.java:77)
> at
> org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:1224)
> at jdk.internal.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532)
> at
> org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:283)
> at
> org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:225)
> at
> org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:824)
> {code}
In SqlToRelConverterTest, we will another error
{code:java}
All correlation variables should resolve to the same namespace. Prev
ns=org.apache.calcite.sql.validate.AliasNamespace@689d96f8, new
ns=org.apache.calcite.sql.validate.AliasNamespace@6b24b09e
java.lang.AssertionError: All correlation variables should resolve to the same
namespace. Prev ns=org.apache.calcite.sql.validate.AliasNamespace@689d96f8, new
ns=org.apache.calcite.sql.validate.AliasNamespace@6b24b09e
at
org.apache.calcite.sql2rel.SqlToRelConverter.getCorrelationUse(SqlToRelConverter.java:3042)
at
org.apache.calcite.sql2rel.SqlToRelConverter.createJoin(SqlToRelConverter.java:2952)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.register(SqlToRelConverter.java:5024)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.reRegister(SqlToRelConverter.java:5089)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertOnCondition(SqlToRelConverter.java:3288)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertJoin(SqlToRelConverter.java:3211)
{code}
> ArrayIndexOutOfBoundsException on select
> ----------------------------------------
>
> Key: CALCITE-5588
> URL: https://issues.apache.org/jira/browse/CALCITE-5588
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.33.0
> Reporter: Magnus Mogren
> Priority: Major
>
> Execute this SQL
> {code:java}
> select Header.Name from ( VALUES (1, 'A'), (2, 'B')) as Header(Id, Name) join
> (values (11, 1), (12, 1), (21, 2)) as Version(Id, Parent) on not exists
> (select 1 from (values (11, 1), (12, 1), (21, 2)) as Version2(Id, Parent)
> where Version2.Parent = Header.Id and Version2.Id > Version.Id) {code}
>
> *Expected result*
> A ResultSet containing this
> |*NAME*|
> |A|
> |A|
> |B|
>
> *Actual result*
> {color:#FF0000}ArrayIndexOutOfBoundsException: Index 2 out of bounds for
> length 2{color}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
