[SERVER-71078] Support $elemMatch in per-filter pushdown Created: 03/Nov/22  Updated: 12/Jan/23

Status: Open
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: pm2646-m5
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Participants:

 Description   

For elemMatch array, this should be fairly straightforward to do.

 

For elemMatch object where only one subfield is read, this should also be fairly straightforward.

 

For elemMatch object where multiple subfields are read, we cannot push the filter down entirely, but we can do a sort of "inexact" filter on each column and then do subsequent filtering once we have values for both columns.


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