1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
/**
* @tags: [
* sbe_incompatible,
* ]
*/
(function() {
'use strict';
var coll = db.sort1;
coll.drop();
coll.save({x: 3, z: 33});
coll.save({x: 5, z: 33});
coll.save({x: 2, z: 33});
coll.save({x: 3, z: 33});
coll.save({x: 1, z: 33});
for (var pass = 0; pass < 2; pass++) {
assert(coll.find().sort({x: 1})[0].x == 1);
assert(coll.find().sort({x: 1}).skip(1)[0].x == 2);
assert(coll.find().sort({x: -1})[0].x == 5);
assert(coll.find().sort({x: -1})[1].x == 3);
assert.eq(coll.find().sort({x: -1}).skip(0)[0].x, 5);
assert.eq(coll.find().sort({x: -1}).skip(1)[0].x, 3);
coll.createIndex({x: 1});
}
assert(coll.validate().valid);
coll.drop();
coll.save({x: 'a'});
coll.save({x: 'aba'});
coll.save({x: 'zed'});
coll.save({x: 'foo'});
for (var pass = 0; pass < 2; pass++) {
assert.eq("a", coll.find().sort({'x': 1}).limit(1).next().x, "c.1");
assert.eq("a", coll.find().sort({'x': 1}).next().x, "c.2");
assert.eq("zed", coll.find().sort({'x': -1}).limit(1).next().x, "c.3");
assert.eq("zed", coll.find().sort({'x': -1}).next().x, "c.4");
coll.createIndex({x: 1});
}
assert(coll.validate().valid);
// Ensure that sorts with a collation and no index return the correct ordering. Here we use the
// 'numericOrdering' option which orders number-like strings by their numerical values.
if (db.getMongo().useReadCommands()) {
coll.drop();
assert.commandWorked(coll.insert({_id: 0, str: '1000'}));
assert.commandWorked(coll.insert({_id: 1, str: '5'}));
assert.commandWorked(coll.insert({_id: 2, str: '200'}));
var cursor = coll.find().sort({str: -1}).collation({locale: 'en_US', numericOrdering: true});
assert.eq(cursor.next(), {_id: 0, str: '1000'});
assert.eq(cursor.next(), {_id: 2, str: '200'});
assert.eq(cursor.next(), {_id: 1, str: '5'});
assert(!cursor.hasNext());
}
// Ensure that sorting of arrays correctly respects a collation with numeric ordering.
if (db.getMongo().useReadCommands()) {
coll.drop();
assert.commandWorked(coll.insert({_id: 0, strs: ['1000', '500']}));
assert.commandWorked(coll.insert({_id: 1, strs: ['2000', '60']}));
cursor = coll.find({strs: {$lt: '1000'}}).sort({strs: 1}).collation({
locale: 'en_US',
numericOrdering: true
});
assert.eq(cursor.next(), {_id: 1, strs: ['2000', '60']});
assert.eq(cursor.next(), {_id: 0, strs: ['1000', '500']});
assert(!cursor.hasNext());
}
})();
|
