[SERVER-62754] Consider using "isMember" to implement disjunction of Eqs Created: 19/Jan/22  Updated: 29/Oct/23  Resolved: 12/Jan/23

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

Type: Improvement Priority: Major - P3
Reporter: Hana Pearlman Assignee: Will Buerger
Resolution: Fixed Votes: 0
Labels: cascades-starter
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-01-09, QO 2023-01-23
Participants:

 Description   

When implementing SargableNode s, we can consider creating an expression which uses PathCompare [EqMember], rather than a composition of many PathCompare s.

A good place for implementation could be within the lowerPartialSchemaRequirement function.

This ticket is inspired by the approach here, which created a FilterNode with a call to isMember during translation of a $in.



 Comments   
Comment by Githook User [ 12/Jan/23 ]

Author:

{'name': 'Will Buerger', 'email': 'will.buerger@mongodb.com', 'username': 'wbuerger46'}

Message: SERVER-62754: Implement disjunction of Eq/EqMember with consolidated EqMember
Branch: master
https://github.com/mongodb/mongo/commit/bcb06e83ad5a2f678c1b9d76bcaa96ce34e8b7bc

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