[
https://issues.apache.org/jira/browse/ASTERIXDB-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3358:
---------------------------------
Labels: triaged (was: )
> Indexnl hint with index names not working correctly
> ---------------------------------------------------
>
> Key: ASTERIXDB-3358
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3358
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Minor
> Labels: triaged
>
> For the following queries, no warning is issued when an invalid index is
> specified with the indexnl hint. The correct behavior is that a warning
> should be issued, the hint should be ignored, and all possible join methods
> should be explored.
> Create the following indexes.
> Create index R_idx_a on R(a:int);
> Create index R_idx_b on R(b:int);
> The following queries (with an invalid index in the indexnl hint) do not
> issue a warning about the invalid index and the hint is honored.
> select * from R, S where R.a /*+ indexnl (idx_c) */ = tobigint(S.a)
> select * from R, S where R.a /*+ indexnl (idx_a, idx_c) */ = tobigint(S.a)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
