Evgeny Stanilovsky created IGNITE-26512:
-------------------------------------------
Summary: ItAggregatesTest#testGroupingFunction failed if
statistics return table size greater than 1
Key: IGNITE-26512
URL: https://issues.apache.org/jira/browse/IGNITE-26512
Project: Ignite
Issue Type: Task
Components: sql ai3
Affects Versions: 3.0
Reporter: Evgeny Stanilovsky
ItAggregatesTest#testGroupingFunction becomes to fail with:
{noformat}
org.apache.ignite.sql.SqlException: IGN-SQL-7 Subquery returned more than 1
value.
TraceId:b757b617
at
org.apache.ignite.internal.sql.engine.exec.exp.agg.Accumulators$SingleVal.add(Accumulators.java:304)
at
org.apache.ignite.internal.sql.engine.exec.exp.agg.AggregateRow.update(AggregateRow.java:81)
at
org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode$Grouping.add(HashAggregateNode.java:260)
at
org.apache.ignite.internal.sql.engine.exec.rel.HashAggregateNode.push(HashAggregateNode.java:123)
at
org.apache.ignite.internal.sql.engine.exec.rel.Inbox.pushUnordered(Inbox.java:337)
{noformat}
steps to reproduce:
Change SqlStatisticManagerImpl#tableSize method so that it return always 10L
(for example)
passed test plan:
{noformat}
Project
fieldNames: [EXPR$0, STR_COL]
projection: [EXPR$0, STR_COL]
est: (rows=1)
ReduceHashAggregate
fieldNames: [STR_COL, EXPR$0]
group: [STR_COL]
aggregation: [SINGLE_VALUE(_ACC0)]
est: (rows=1)
MapHashAggregate
fieldNames: [STR_COL, _ACC0, _GROUP_ID]
group: [STR_COL]
aggregation: [GROUPING(STR_COL)]
est: (rows=1)
Exchange
distribution: single
est: (rows=1)
TableScan
table: PUBLIC.TEST_STR_INT_REAL_DEC
fieldNames: [STR_COL]
est: (rows=1)
{noformat}
failed test plan:
{noformat}
Project
fieldNames: [EXPR$0, STR_COL]
projection: [EXPR$0, STR_COL]
est: (rows=2)
ReduceHashAggregate
fieldNames: [STR_COL, EXPR$0]
group: [STR_COL]
aggregation: [SINGLE_VALUE(_ACC0)]
est: (rows=2)
Exchange
distribution: single
est: (rows=2)
MapHashAggregate
fieldNames: [STR_COL, _ACC0, _GROUP_ID]
group: [STR_COL]
aggregation: [GROUPING(STR_COL)]
est: (rows=2)
TableScan
table: PUBLIC.TEST_STR_INT_REAL_DEC
fieldNames: [STR_COL]
est: (rows=10)
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
