Loading...

XML

Word

Printable

JSON

Details

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 5.1.0-rc0
Affects Version/s: 4.4.4
Component/s: None
Labels:
- neweng

Backwards Compatibility:
Fully Compatible
Sprint:
Query Optimization 2021-05-17, Query Optimization 2021-05-31, Query Optimization 2021-06-14, Query Optimization 2021-06-28

Description

$sort should be pushed automatically before $unwind if sort is happening on a different field.
E.g.

db.foo.aggregation([{$unwind: "fieldA"},{$sort: { fieldB: 1}}])

Attachments

Issue Links

is related to

SERVER-26442 Push $sort before $project and $addFields

Open

related to

SERVER-55417 Conditionally reorder $sort and $lookup depending on whether the query planner allows for an index-provided sort

Backlog

Activity

People

Assignee:: Militsa Sotirova

Reporter:: Renato Riccio

Participants:: David Percy, Githook User, Militsa Sotirova, Renato Riccio, Vivian Ge

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: Feb 26 2021 05:25:23 PM UTC

Updated:: Oct 29 2023 09:56:58 PM UTC

Resolved:: Jun 14 2021 02:31:12 PM UTC