[SERVER-60197] Support $group pushdown to SBE when $match stage with $or exists in a pipeline Created: 24/Sep/21 Updated: 29/Oct/23 Resolved: 25/Jan/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 5.3.0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Yoon Soo Kim | Assignee: | Yoon Soo Kim |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Sprint: | QE 2022-01-10, QE 2022-02-07, QE 2022-01-24 | ||||||||
| Participants: | |||||||||
| Description |
|
Repro:
In Need to figure out how to enable $group pushdown to SBE even when subplanning is involved. |
| Comments |
| Comment by Githook User [ 25/Jan/22 ] | |||||||||||||||||||||||||||||||||
|
Author: {'name': 'Yoonsoo Kim', 'email': 'yoonsoo.kim@mongodb.com', 'username': 'yun-soo'}Message: | |||||||||||||||||||||||||||||||||
| Comment by Githook User [ 25/Jan/22 ] | |||||||||||||||||||||||||||||||||
|
Author: {'name': 'Yoonsoo Kim', 'email': 'yoonsoo.kim@mongodb.com', 'username': 'yun-soo'}Message: | |||||||||||||||||||||||||||||||||
| Comment by Yoon Soo Kim [ 19/Jan/22 ] | |||||||||||||||||||||||||||||||||
|
A strange plan is generated though we don't get tripwire assertion.
It does not look like that $group is actually pushed down but only $match. | |||||||||||||||||||||||||||||||||
| Comment by Yoon Soo Kim [ 19/Jan/22 ] | |||||||||||||||||||||||||||||||||
|
Experimented the test case, ignoring sub-planning and got incorrect results.
It does not seem to be a trivial issue. | |||||||||||||||||||||||||||||||||
| Comment by Eric Cox (Inactive) [ 05/Jan/22 ] | |||||||||||||||||||||||||||||||||
|
yoonsoo.kim Should this work now given what we observed with $unionWith? |