[ASTERIXDB-3071] st_intersect() and friends don't trigger spatial join when appropriate

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.7
• Component/s: COMP - Compiler, IDX - Indexes, RT - Runtime
• Assignee: Unassigned
• Reporter: Ian Maxon
• Created: 01/Sep/22 17:51
• Updated: 01/Sep/22 17:51

Description

Currently, the GeoJSON family of functions don't trigger Spatial Join plans when appropriate, like is currently supported for spatial_intersects(). When one of these functions appears as a predicate in a join, and an appropriate index is available, the proper rewrites for turning the query into a spatial join should be triggered.