Suryaa Charan created ASTERIXDB-3452:
----------------------------------------
Summary: Spatial Join Fails with Indexed Datasets Unless
Index-Only Plan is Disabled
Key: ASTERIXDB-3452
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3452
Project: Apache AsterixDB
Issue Type: Bug
Components: OTH - Other
Reporter: Suryaa Charan
Attachments: LogTrace.txt, QueriesToReplicateIssue.txt
The spatial join operation fails when +*both*+ datasets involved in the join
have indices. The operation succeeds if one of the datasets does not have an
index or if the index-only plan is disabled using the command: SET
compiler.indexonly "false";
*Expected Behavior:* The spatial join should work seamlessly with indexed
datasets without the need to disable the index-only plan.
*Actual Behavior:* The spatial join fails when both datasets have indices,
indicating an issue with the index-only plan mechanism.
*Workaround:* Disabling the index-only plan with the command {{SET
}}compiler.indexonly{{ "false";}} allows the spatial join to succeed.
*Attachments:*
# [^QueriesToReplicateIssue.txt]Queries to replicate the
issue.([^QueriesToReplicateIssue.txt])
# Log trace showcasing the error.([^LogTrace.txt])
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
