[
https://issues.apache.org/jira/browse/IGNITE-28510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov updated IGNITE-28510:
--------------------------------------
Summary: Sql. Table hints are not applied (was: Sql. Table hints are not
applied.)
> Sql. Table hints are not applied
> --------------------------------
>
> Key: IGNITE-28510
> URL: https://issues.apache.org/jira/browse/IGNITE-28510
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Reporter: Andrey Mashenkov
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3
>
> Assume, we have a table with two indexed column.
> Next queries should use index from the provided hint.
> ```
> SELECT /*+ FORCE_INDEX('t_idx_col1'}) */ * FROM t WHERE col1 = 1 AND col2 = 2;
> SELECT * FROM t /*+ FORCE_INDEX('t_idx_col1'}) */ WHERE col1 = 1 AND col2 =
> 2;
> ```
> Unfortunately, hint is ignored for the second query.
> Actually, AST contains the hint for the table node.
> But it is missed during conversion to LogicalTableScan.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
