[SERVER-59508] Support $or, $in and multi-level expressions in partial indexes Created: 23/Aug/21  Updated: 29/Oct/23  Resolved: 02/Oct/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: James Wahlin
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
is documented by DOCS-14869 [Server] Investigate changes in SERVE... Closed
Duplicate
is duplicated by SERVER-18884 Allow $in to be specified in partial ... Closed
Problem/Incident
causes SERVER-71068 Partial indexes should not check FCV ... Closed
Related
is related to SERVER-59163 Enable partial indexes on time-series... Closed
is related to SERVER-18884 Allow $in to be specified in partial ... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2021-09-20, QO 2021-10-04, QO 2021-10-18
Participants:

 Description   

Add support for the following to partial indexes:
1) $in
2) $or
3) Expansion of max partialFilterExpression tree depth from 2 to 4, allowing non-top-level $and / $or



 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 James Wahlin [ 02/Oct/21 ]

This feature has been released under the timeseriesMetricIndexesFeatureFlagEnabled feature flag which is not currently enabled. Our current target is to release as part of 5.2.

Comment by Githook User [ 01/Oct/21 ]

Author:

{'name': 'James Wahlin', 'email': 'james@mongodb.com', 'username': 'jameswahlin'}

Message: SERVER-59508 Support $or in partialFilterExpression; remove top level $and restriction
Branch: master
https://github.com/mongodb/mongo/commit/da8cbb9ff41b90fbe340547deb11fe93c2b46c5a

Comment by James Wahlin [ 09/Sep/21 ]

Linking SERVER-18884 as adding support for $or would potentially require including support for $in.

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