Claude Brisson created CALCITE-6369:
---------------------------------------
Summary: Expanding "start" gives ArrayIndexOutOfBoundsException
with redundant columns and USING
Key: CALCITE-6369
URL: https://issues.apache.org/jira/browse/CALCITE-6369
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Claude Brisson
The query
{code}
select r_regionkey, * from region r0 join region r1 using (r_regionkey)
{code}
produces
{code}
java.lang.ArrayIndexOutOfBoundsException: Index 14 out of bounds for length 14
at org.apache.calcite.runtime.PairLists$ArrayImmutablePairList.get
(PairLists.java:573)
at org.apache.calcite.runtime.PairLists$ArrayImmutablePairList.get
(PairLists.java:550)
at org.apache.calcite.sql.validate.SqlValidatorImpl$Permute.permute
(SqlValidatorImpl.java:7443)
at org.apache.calcite.sql.validate.SqlValidatorImpl.expandStar
(SqlValidatorImpl.java:697)
at org.apache.calcite.sql.validate.SqlValidatorImpl.expandSelectItem
(SqlValidatorImpl.java:453)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList
(SqlValidatorImpl.java:4658)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect
(SqlValidatorImpl.java:3840)
at org.apache.calcite.sql.validate.SelectNamespace.validateImpl
(SelectNamespace.java:61)
at org.apache.calcite.sql.validate.AbstractNamespace.validate
(AbstractNamespace.java:88)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace
(SqlValidatorImpl.java:1154)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery
(SqlValidatorImpl.java:1125)
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
