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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: OTH - Other
• Labels: triaged
• Flags: Patch
• Assignee: Unassigned
• Reporter: Suryaa Charan
• Created: 03/Jul/24 19:36
• Updated: 16/Jul/24 22:59

Description

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:

1. Queries to replicate the issue.(QueriesToReplicateIssues.txt)
2. Log trace showcasing the error.(LogTrace.txt)