[SERVER-57765] Allow partial filter expression to use $_internalBucketGeoWithin Created: 16/Jun/21  Updated: 29/Oct/23  Resolved: 31/Aug/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.1.0-rc0

Type: New Feature Priority: Major - P3
Reporter: David Percy Assignee: Maddie Zechar
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-57762 Create an internal, bucketed $geoWith... Closed
depends on SERVER-57763 Allow partial filter expression to us... Closed
is depended on by SERVER-58059 Support partial indexes on time-serie... Closed
Problem/Incident
Backwards Compatibility: Fully Compatible
Sprint: QO 2021-09-06
Participants:
Linked BF Score: 0

 Description   

$_internalBucketGeoWithin (SERVER-57762) selects buckets that might contain events within a given region. That is:

  • It is guaranteed to return every bucket that does contain an event in the given region.
  • It may return other buckets, depending on the query plan.

$geoWithin queries on events use $_internalBucketGeoWithin to narrow down the set of buckets (before unpacking and doing a more precise filter on events). As of SERVER-57763, partial indexes can use $geoWithin in partialFilterExpression. To make these features work together, we need to allow $_internalBucketGeoWithin in the partialFilterExpression.

I think the rule for query containment is the same as a plain $geoWithin. If the index has regionA, and the query has regionB, then the index can be used only if regionB is contained in regionA.



 Comments   
Comment by Vivian Ge (Inactive) [ 06/Oct/21 ]

Updating the fixversion since branching activities occurred yesterday. This ticket will be in rc0 when it’s been triggered. For more active release information, please keep an eye on #server-release. Thank you!

Comment by Githook User [ 28/Aug/21 ]

Author:

{'name': 'Benety Goh', 'email': 'benety@mongodb.com', 'username': 'benety'}

Message: SERVER-57765 fix windows compile
Branch: master
https://github.com/mongodb/mongo/commit/e1efe794dda47eb65be3133cb567d8784a7c489b

Comment by Githook User [ 27/Aug/21 ]

Author:

{'name': 'Maddie Zechar', 'email': 'mez2113@columbia.edu', 'username': 'madelinezec'}

Message: SERVER-57765:Allow partial filter expression to use $_internalBucketGeoWithin
Branch: master
https://github.com/mongodb/mongo/commit/4bdbe69acfb3f501a7191743832ff94077358147

Generated at Thu Feb 08 05:42:44 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.