[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: |
|
||||||||
| 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: |
| Comment by Steve Tarzia [ 01/Dec/22 ] |
|
This is expecially relevant for predicates like: {$exists: true} AND {$not: ...} |