[IGNITE-23557] Calcite. Assertion in COUNT(DISTINCT) accumulator.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.17
• Labels: calcite ignite-2 ise
• Release Note: SQL Calcite: Fixed failure in COUNT(DISTINCT) operation.
• Ignite Flags: Release Notes Required
• Assignee: Vladimir Steshin
• Reporter: Vladimir Steshin
• Created: 28/Oct/24 19:04
• Updated: 08/Nov/24 06:14
• Resolved: 08/Nov/24 06:14

Description

Reproducer:

CREATE TABLE integers(i INTEGER)
INSERT INTO integers VALUES (1), (2), (3), (NULL)
SELECT i=ALL(SELECT i FROM integers WHERE i<>i1.i) FROM integers i1 ORDER BY i;

Result:

Caused by: java.lang.AssertionError: idx=0; arglist=[]
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.Accumulators$AbstractAccumulator.get(Accumulators.java:272)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.Accumulators$DistinctAccumulator.add(Accumulators.java:1352)
	at org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.add(AccumulatorsFactory.java:326)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.addOnMapper(HashAggregateNode.java:306)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.add(HashAggregateNode.java:277)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.push(HashAggregateNode.java:130)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.FilterNode.filter(FilterNode.java:127)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.FilterNode.push(FilterNode.java:82)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.TableSpoolNode.doPush(TableSpoolNode.java:111)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.TableSpoolNode.push(TableSpoolNode.java:146)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:304)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
	at org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.doPush(Inbox.java:184)

Calcite can create `AggregateCall` with empty `getArgList()`.

Adoption of #IGNITE-19401

Issue Links

• relates to: IGNITE-19401 Sql. ArrayIndexOutOfBoundsException for ANY/ALL with subselect
• links to: GitHub Pull Request #11630