[
https://issues.apache.org/jira/browse/IGNITE-26512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov reassigned IGNITE-26512:
-----------------------------------------
Assignee: Maksim Zhuravkov
> 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
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> 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)
