summaryrefslogtreecommitdiff
path: root/jstests/core/sort1.js
blob: 12b97728e903efa9191fd5644e2e59b4a5f3e031 (plain)
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
debug = function( s ){
    //print( s );
}

t = db.sort1;
t.drop();

t.save({x:3,z:33});
t.save({x:5,z:33});
t.save({x:2,z:33});
t.save({x:3,z:33});
t.save({x:1,z:33});

debug( "a" )
for( var pass = 0; pass < 2; pass++ ) {
    assert( t.find().sort({x:1})[0].x == 1 );
    assert( t.find().sort({x:1}).skip(1)[0].x == 2 );
    assert( t.find().sort({x:-1})[0].x == 5 );
    assert( t.find().sort({x:-1})[1].x == 3 );
    assert.eq( t.find().sort({x:-1}).skip(0)[0].x , 5 );
    assert.eq( t.find().sort({x:-1}).skip(1)[0].x , 3 );
    t.ensureIndex({x:1});

}

debug( "b" )
assert(t.validate().valid);

t.drop();
t.save({x:'a'});
t.save({x:'aba'});
t.save({x:'zed'});
t.save({x:'foo'});

debug( "c" )

for( var pass = 0; pass < 2; pass++ ) { 
    debug( tojson( t.find().sort( { "x" : 1 } ).limit(1).next() ) );
    assert.eq( "a" , t.find().sort({'x': 1}).limit(1).next().x , "c.1" );
    assert.eq( "a" , t.find().sort({'x': 1}).next().x , "c.2" );
    assert.eq( "zed" , t.find().sort({'x': -1}).limit(1).next().x , "c.3" );
    assert.eq( "zed" , t.find().sort({'x': -1}).next().x , "c.4" );
    t.ensureIndex({x:1});
}

debug( "d" )

assert(t.validate().valid);