-
Type:
Bug
-
Status: Closed
-
Priority:
Major - P3
-
Resolution: Fixed
-
Affects Version/s: None
-
Component/s: None
-
Labels:
-
Backwards Compatibility:Fully Compatible
-
Operating System:ALL
-
Backport Requested:v4.2, v4.0, v3.6
-
Sprint:Query 2020-01-27
-
Linked BF Score:0
It looks like the necessary ingredients to repro are:
- a collation
- multiple point ranges
- the point ranges are indexed in descending order
- more than one index can satisfy the query
- the query asks for a sort within each point range
var coll = db.foo; |
coll.drop();
|
db.createCollection(coll.getName(), {collation: {locale: 'fr'}}); |
coll.createIndex({x: -1});
|
coll.createIndex({x: -1, y: 1});
|
|
coll.find({x: {$in: [2, 5]}}).sort({y: 1}).toArray(); |