Info
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).
Top User Comments
xgen-internal-githook commented on Tue, 30 Apr 2024 22:32:29 +0000:
Author:
{'name': 'Jess Balint', 'email': 'jbalint@gmail.com', 'username': 'jbalint'}
Message: SERVER-89480 Classic plan cache key encoding of $_internalBucketGeoWi… (#21429)
GitOrigin-RevId: 2ef95e6e9d15ba506627e05e80cba10e0295e167
Branch: v8.0
https://github.com/mongodb/mongo/commit/f2659cddf3922822ab9155fc8e299855756bcdcd
xgen-internal-githook commented on Wed, 24 Apr 2024 05:03:56 +0000:
Author:
{'name': 'Jess Balint', 'email': 'jbalint@gmail.com', 'username': 'jbalint'}
Message: SERVER-89480 Classic plan cache key encoding of $_internalBucketGeoWi… (#21429)
GitOrigin-RevId: 353827cf6745d80fbc1524107bfa3a3d65583008
Branch: master
https://github.com/mongodb/mongo/commit/99afdb02665b7b2f5a2301545b99a7eb8dcad4de
