Ali Alsuliman created ASTERIXDB-3083:
----------------------------------------
Summary: Indexnl gives different result than hash-join
Key: ASTERIXDB-3083
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3083
Project: Apache AsterixDB
Issue Type: Bug
Components: IDX - Indexes
Affects Versions: 0.9.3
Reporter: Ali Alsuliman
Assignee: Ali Alsuliman
Fix For: 0.9.7
Currently, in order to use index-nested-loop-join algorithm via "indexnl" hint,
it is required that the outer collection be cast to the type that is compatible
with the index on the inner collection. This leads to a query that is
semantically different from the hash-join algorithm and that (rightly) produces
a different result. However, from a user perspective, using a hash-join or
nested-loop join should give the same result. Here is an example:
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
