[IGNITE-18569] Sql. Some queries exceptionally executed if some rules are disabled.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 18/Jan/23 09:44
• Updated: 03/Feb/23 09:52
• Resolved: 03/Feb/23 09:50

Description

Found that if only one aggregate rule HashAggregateConverterRule.COLOCATED become available (in practice it can win by summary weights), we obtain exception, like :

concrete this test can be found in /sqlite/aggregates/agg1.test.
There are also numerous faled tests if only one aggregate rule become enabled.

Error at: (agg1.test_slow:113). sql: SELECT DISTINCT + 30 AS col0 FROM tab0, tab1 AS cor0

Caused by: java.lang.IllegalStateException
	at org.apache.ignite.internal.sql.engine.trait.DistributionFunction$SingletonDistribution.destination(DistributionFunction.java:205)
	at org.apache.ignite.internal.sql.engine.trait.DistributionTrait.destination(DistributionTrait.java:109)
	at org.apache.ignite.internal.sql.engine.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:161)

            //HashAggregateConverterRule.COLOCATED,
            HashAggregateConverterRule.MAP_REDUCE,
            //SortAggregateConverterRule.COLOCATED,
            //SortAggregateConverterRule.MAP_REDUCE,

Issue Links

• links to: GitHub Pull Request #1603
• links to: GitHub Pull Request #1603