[SERVER-70726] Support pushing down as per-path filters AND of supported expressions on the same path Created: 20/Oct/22  Updated: 29/Oct/23  Resolved: 08/Nov/22

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

Type: Task Priority: Major - P3
Reporter: Irina Yatsenko (Inactive) Assignee: Irina Yatsenko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-84873 Investigate performance of artificial... Closed
Issue split
split from SERVER-68743 Reenable pushing down into column sca... Closed
Related
is related to SERVER-70406 Push into column scan filters in the ... Closed
Backwards Compatibility: Fully Compatible
Sprint: QE 2022-11-14
Participants:

 Description   

We should be able to push down a conjunction where at least one term is supported by CSI (that is, the filter would evaluate to false on missing) but to begin with we could push down conjunctions when all of the terms could be pushed down individually.

 

Note: SERVER-70406 would be subsumed by this ticket if implement lowering AND when at least one of the terms is supported (though even then there is an opportunity to optimize $exist away completely)



 Comments   
Comment by Githook User [ 08/Nov/22 ]

Author:

{'name': 'Irina Yatsenko', 'email': 'irina.yatsenko@mongodb.com', 'username': 'IrinaYatsenko'}

Message: SERVER-70726 Push down AND of supported predicates on the same field in column_scan
Branch: master
https://github.com/mongodb/mongo/commit/d4e268fb9474b3759d86f47c26395e73edf8c6e1

Generated at Thu Feb 08 06:16:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.