You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2026/04/10 10:32:00 UTC
[jira] [Updated] (IGNITE-28510) Sql. Table hints are not applied.
[ https://issues.apache.org/jira/browse/IGNITE-28510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Mashenkov updated IGNITE-28510:
--------------------------------------
Description:
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.
> 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
> 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)