[
https://issues.apache.org/jira/browse/IGNITE-21839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-21839:
--------------------------------------
Description:
Plan hints do not participate in a plan key which makes them more or less
useless.
{code:java}
@Test
public void test() {
sql("CREATE TABLE kv (ID INTEGER, cat VARCHAR, val BIGINT, PRIMARY KEY
(id) )");
String disabledRules1 = "/* + DISABLE_RULE("
// + "'MapReduceHashAggregateConverterRule',"
+ "'MapReduceSortAggregateConverterRule', "
+ "'ColocatedHashAggregateConverterRule',"
+ "'ColocatedSortAggregateConverterRule') "
+ "*/";
String disabledRules2 = "/* + DISABLE_RULE("
+ "'MapReduceHashAggregateConverterRule',"
// + "'MapReduceSortAggregateConverterRule', "
+ "'ColocatedHashAggregateConverterRule',"
+ "'ColocatedSortAggregateConverterRule') "
+ "*/";
System.err.println(sql("EXPLAIN PLAN FOR SELECT " + disabledRules1 + "
SUM(val) FROM kv GROUP BY cat"));
System.err.println(sql("EXPLAIN PLAN FOR SELECT " + disabledRules2 + "
SUM(val) FROM kv GROUP BY cat"));
}
{code}
- Explain for both queries is going to produce the same plan.
- Running this queries also leads to creation of a single plan.
was:
Plan hints do not participate in a plan key which makes them useless.
> Sql. Plan hints do not contribute to plan cache key.
> ----------------------------------------------------
>
> Key: IGNITE-21839
> URL: https://issues.apache.org/jira/browse/IGNITE-21839
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> Plan hints do not participate in a plan key which makes them more or less
> useless.
> {code:java}
> @Test
> public void test() {
> sql("CREATE TABLE kv (ID INTEGER, cat VARCHAR, val BIGINT, PRIMARY
> KEY (id) )");
> String disabledRules1 = "/* + DISABLE_RULE("
> // + "'MapReduceHashAggregateConverterRule',"
> + "'MapReduceSortAggregateConverterRule', "
> + "'ColocatedHashAggregateConverterRule',"
> + "'ColocatedSortAggregateConverterRule') "
> + "*/";
> String disabledRules2 = "/* + DISABLE_RULE("
> + "'MapReduceHashAggregateConverterRule',"
> // + "'MapReduceSortAggregateConverterRule', "
> + "'ColocatedHashAggregateConverterRule',"
> + "'ColocatedSortAggregateConverterRule') "
> + "*/";
>
> System.err.println(sql("EXPLAIN PLAN FOR SELECT " + disabledRules1 +
> " SUM(val) FROM kv GROUP BY cat"));
> System.err.println(sql("EXPLAIN PLAN FOR SELECT " + disabledRules2 +
> " SUM(val) FROM kv GROUP BY cat"));
> }
> {code}
> - Explain for both queries is going to produce the same plan.
> - Running this queries also leads to creation of a single plan.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
