[jira] [Created] (IGNITE-19401) Sql. ArrayIndexOutOfBoundsException for ANY/ALL with subselect

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

Yury Gerzhedovich created IGNITE-19401:
------------------------------------------

             Summary: 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
            Reporter: Yury Gerzhedovich


For SqlLogicTest sql/subquery/any_all/test_correlated_any_all.test the following query fails with ArrayIndexOutOfBoundsException:
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;
{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)