[
https://issues.apache.org/jira/browse/IGNITE-22259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky resolved IGNITE-22259.
-----------------------------------------
Resolution: Duplicate
fixed under IGNITE-19401
> Sql. ArrayIndexOutOfBoundsException on COUNT(DISTINCT) aggregate.
> -----------------------------------------------------------------
>
> Key: IGNITE-22259
> URL: https://issues.apache.org/jira/browse/IGNITE-22259
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
>
> to reproduce :
> {code:java}
> @Test
> @WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
> public void test0() {
> sql("CREATE TABLE tbl_ProductSales (ColID int, Product_Category
> varchar(64), Product_Name varchar(64), TotalSales int);");
> sql("CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT,
> col5 INT, col6 INT, col7 INT, col8 INT);");
> sql("INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo
> Game',200),(2,'Game','PKO
> Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);");
> sql("INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8),
> (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888),
> (1111,2222,3333,4444,5555,6666,7777,8888);");
> List<List<Object>> res = sql(
> "SELECT (SELECT MIN(ColID) FROM tbl_ProductSales INNER JOIN
> another_T t2 ON t1.col7 <> ANY(SELECT MAX(t1.col1 + t3.col4) FROM another_T
> t3)) FROM another_T t1;");
> res.get(0);
> }
> {code}
> throws :
> {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:774)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.add(AccumulatorsFactory.java:313)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.agg.AggregateRow.update(AggregateRow.java:61)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode$Grouping.add(HashAggregateNode.java:260)
> {noformat}
> this statement is a part of test_grouped_correlated_subquery.test_ignore
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
