[
https://issues.apache.org/jira/browse/ASTERIXDB-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17842135#comment-17842135
]
ASF subversion and git services commented on ASTERIXDB-3358:
------------------------------------------------------------
Commit 6d124481c4238b59b754eec83811c28596bb6d29 in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=6d124481c4 ]
[ASTERIXDB-3358][COMP] Indexnl hint with index names not working correctly
Change-Id: I603ae267efd137d4e9f3491be2a6bdcb1179eeac
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18177
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Vijay Sarathy <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> 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)
