-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: 6.0.21, 8.0.6, 7.0.18, 8.1.0-rc2
-
Component/s: None
-
Query Optimization
-
ALL
-
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Using the repro below, explain shows that each shard sorts on the "m" field, then projects it out. Then on the merger part of the query, we expect the sorted field but don't see it.
Rewriting the query so the $project is before the $sort on the shards part is probably done as an optimization to only send necessary fields to the merge part, but it's incorrect because it removes the sort key.
- related to
-
SERVER-89308 Create query property tester
-
- Closed
-