[SERVER-70406] Push into column scan filters in the form of {supported} AND {$not: {supported}} on the same path Created: 10/Oct/22  Updated: 29/Oct/23  Resolved: 27/Dec/22

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

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

Issue Links:
Related
related to SERVER-70726 Support pushing down as per-path filt... Closed
Backwards Compatibility: Fully Compatible
Sprint: QE 2022-10-17, QE 2022-10-31, QE 2022-11-14, QE 2022-11-28, QE 2022-12-12, QE 2022-12-26, QE 2023-01-09
Participants:

 Description   

We can only push down expressions that would return "false" on missing paths and we make the decision per term of a logical expression. We should allow the user to take advantage of the CSI in more cases by explicitly limiting the filters with {$exists: true}.



 Comments   
Comment by Githook User [ 27/Dec/22 ]

Author:

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

Message: SERVER-70406 Push into column_scan stage $not filter in some cases
Branch: master
https://github.com/mongodb/mongo/commit/f38ee44ac0b975b2ebb797a309a455a7e2167886

Comment by Steve Tarzia [ 01/Dec/22 ]

This is expecially relevant for predicates like: {$exists: true} AND {$not: ...}

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