[SERVER-46233] Aggregation $sort stages that get pushed down may miss opportunities to be optimized Created: 18/Feb/20 Updated: 29/Oct/23 Resolved: 24/Mar/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 4.4.0-rc0, 4.7.0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Justin Seyster | Assignee: | Justin Seyster |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | qexec-team | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Operating System: | ALL | ||||||||||||
| Backport Requested: |
v4.4
|
||||||||||||
| Sprint: | Query 2020-02-24, Query 2020-03-09, Query 2020-03-23, Query 2020-04-06 | ||||||||||||
| Participants: | |||||||||||||
| Linked BF Score: | 15 | ||||||||||||
| Description |
|
In some cases, ordering a $match in front of a $sort can require a second call to pipelineOptimize: the first call simplifies the $match, enabling the second call to recognize that the $match can be moved. After |
| Comments |
| Comment by Githook User [ 06/Apr/20 ] |
|
Author: {'name': 'Justin Seyster', 'email': 'justin.seyster@mongodb.com', 'username': 'jseyster'}Message: The second call to optimizePipeline() can sometimes catch We want to catch these opportunities before we push down any stages (cherry picked from commit 30bd61a92cd4c8d6dd5588b59b9bdf4a0cd3c7d8) |
| Comment by Githook User [ 24/Mar/20 ] |
|
Author: {'name': 'Justin Seyster', 'username': 'jseyster', 'email': 'justin.seyster@mongodb.com'}Message: The second call to optimizePipeline() can sometimes catch We want to catch these opportunities before we push down any stages |