[jira] [Created] (ASTERIXDB-3452) Spatial Join Fails with Indexed Datasets Unless Index-Only Plan is Disabled

["Suryaa Charan (Jira)" <ji...@apache.org>]

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)