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
|
// Test sorting with skipping and multiple candidate query plans.
t = db.jstests_sortc;
t.drop();
t.save( {a:1} );
t.save( {a:2} );
function checkA( a, sort, skip, query ) {
query = query || {};
assert.eq( a, t.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} );
checkA( 1, {$natural:1}, 0 );
checkA( 2, {$natural:1}, 1 );
checkA( 2, {$natural:-1}, 0 );
checkA( 1, {$natural:-1}, 1 );
}
checkSortAndSkip();
t.ensureIndex( {a:1} );
checkSortAndSkip();
|