[
https://issues.apache.org/jira/browse/IGNITE-21839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17830234#comment-17830234
]
Maksim Zhuravkov edited comment on IGNITE-21839 at 3/24/24 9:22 AM:
--------------------------------------------------------------------
Closed as invalid since hint syntax contained an error but hint syntax errors
are not reported as errors by sql parser.
was (Author: JIRAUSER298618):
Hint syntax contained an error but hint syntax errors are not reported as
errors by sql parser.
> 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: Minor
> 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)
