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
|
// Test sorting with skipping and multiple candidate query plans.
(function() {
"use strict";
const coll = db.jstests_sortc;
coll.drop();
assert.commandWorked(coll.insert({a: 1}));
assert.commandWorked(coll.insert({a: 2}));
function checkA(a, sort, skip, query) {
query = query || {};
assert.eq(a, coll.find(query).sort(sort).skip(skip)[0].a);
}
function checkSortAndSkip() {
checkA(1, {a: 1}, 0);
checkA(2, {a: 1}, 1);
checkA(1, {a: 1}, 0, {a: {$gt: 0}, b: null});
checkA(2, {a: 1}, 1, {a: {$gt: 0}, b: null});
checkA(2, {a: -1}, 0);
checkA(1, {a: -1}, 1);
checkA(2, {a: -1}, 0, {a: {$gt: 0}, b: null});
checkA(1, {a: -1}, 1, {a: {$gt: 0}, b: null});
}
checkSortAndSkip();
assert.commandWorked(coll.createIndex({a: 1}));
checkSortAndSkip();
}());
|