[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:
--
Fix Version/s: 3.2
> 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
> Fix For: 3.2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
[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:
--
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)
[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)
