[ASTERIXDB-3358] Indexnl hint with index names not working correctly

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Vijay Sarathy
• Reporter: Vijay Sarathy
• Created: 21/Feb/24 18:08
• Updated: 30/Apr/24 15:23
• Resolved: 30/Apr/24 15:23

Description

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)