[
https://issues.apache.org/jira/browse/IGNITE-19401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-19401:
--------------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> Sql. ArrayIndexOutOfBoundsException for ANY/ALL with subselect
> --------------------------------------------------------------
>
> Key: IGNITE-19401
> URL: https://issues.apache.org/jira/browse/IGNITE-19401
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Yury Gerzhedovich
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite2-required, calcite3-required, ignite-3
>
> For SqlLogicTest sql/subquery/any_all/test_correlated_any_all.test the
> following query fails with ArrayIndexOutOfBoundsException:
> {code:java}
> SELECT i=ALL(SELECT i FROM integers WHERE i<>i1.i) FROM integers i1 ORDER BY
> i;
> SELECT i FROM integers i1 WHERE i<>ANY(SELECT i FROM integers WHERE i=i1.i)
> ORDER BY i;
> SELECT i=ALL(SELECT i FROM integers WHERE i=i1.i) FROM integers i1 ORDER BY i;
> SELECT i<>ANY(SELECT i FROM integers WHERE i=i1.i) FROM integers i1 ORDER BY
> i;
> SELECT i=ALL(SELECT i FROM integers WHERE i<>i1.i) FROM integers i1 ORDER BY
> i;
> SELECT i=ALL(SELECT i FROM integers WHERE i=i1.i OR i IS NULL) FROM integers
> i1 ORDER BY i;
> {code}
>
> {noformat}
> Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds
> for length 0
> at
> org.apache.ignite.internal.sql.engine.exec.exp.agg.Accumulators$DistinctAccumulator.add(Accumulators.java:885)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.add(AccumulatorsFactory.java:302)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode$Grouping.addOnMapper(HashAggregateNode.java:294)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode$Grouping.add(HashAggregateNode.java:261)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode.push(HashAggregateNode.java:127)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.Inbox.pushUnordered(Inbox.java:302)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.Inbox.push(Inbox.java:190)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.Inbox.onBatchReceived(Inbox.java:168)
> at
> org.apache.ignite.internal.sql.engine.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:148){noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
