-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Query Optimization
-
Fully Compatible
-
ALL
-
v8.0
-
QO 2024-04-29
We include geometry details for GeoMatchExpression ($within, etc) and GeoNearMatchExpression ($geoNear) needed to distinguish predicates in plan cache entries. This needs to be done similarly for $_internalBucketGeoWithin.
This is problematic when caching single candidate plans (failure in timeseries_geonear_measurements.js). The plan cache key is the same for two queries, one of which is a "flat" 2d query (cannot use a geospatial index) and the other spherical (can use an index).
- is related to
-
SERVER-89795 Plan cache key conflict for regex with and without prefix match
- Backlog
- related to
-
SERVER-13341 Cache single solution query plans
- In Code Review