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
|
// Test inequality bounds with multi-field sorting
function checkResults(expected, cursor) {
assert.eq(expected.length, cursor.count());
for (i = 0; i < expected.length; ++i) {
assert.eq(expected[i].a, cursor[i].a);
assert.eq(expected[i].b, cursor[i].b);
}
}
function testConstrainedFindMultiFieldSorting(db) {
r = db.ed_db_cursor4_cfmfs;
r.drop();
entries = [{a: 0, b: 0}, {a: 0, b: 1}, {a: 1, b: 1}, {a: 1, b: 1}, {a: 2, b: 0}];
for (i = 0; i < entries.length; ++i)
r.save(entries[i]);
r.ensureIndex({a: 1, b: 1});
reverseEntries = entries.slice();
reverseEntries.reverse();
checkResults(entries.slice(2, 4), r.find({a: 1, b: 1}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(entries.slice(2, 4), r.find({a: 1, b: 1}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(entries.slice(2, 5), r.find({a: {$gt: 0}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(0, 3),
r.find({a: {$gt: 0}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(entries.slice(0, 4), r.find({a: {$lt: 2}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(1, 5),
r.find({a: {$lt: 2}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(entries.slice(4, 5),
r.find({a: {$gt: 0}, b: {$lt: 1}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(entries.slice(2, 4),
r.find({a: {$gt: 0}, b: {$gt: 0}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(0, 1),
r.find({a: {$gt: 0}, b: {$lt: 1}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(1, 3),
r.find({a: {$gt: 0}, b: {$gt: 0}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(entries.slice(0, 1),
r.find({a: {$lt: 2}, b: {$lt: 1}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(entries.slice(1, 4),
r.find({a: {$lt: 2}, b: {$gt: 0}}).sort({a: 1, b: 1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(4, 5),
r.find({a: {$lt: 2}, b: {$lt: 1}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
checkResults(reverseEntries.slice(1, 4),
r.find({a: {$lt: 2}, b: {$gt: 0}}).sort({a: -1, b: -1}).hint({a: 1, b: 1}));
}
testConstrainedFindMultiFieldSorting(db);
|
