summaryrefslogtreecommitdiff
path: root/jstests/core/index_check5.js
blob: f6b48448f63a469daa53f0df9d32ce4ed56be8b5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

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

t.save( { "name" : "Player1" , 
          "scores" : [{"level" : 1 , "score" : 100},
                      {"level" : 2 , "score" : 50}], 
          "total" : 150 } );
t.save( { "name" : "Player2" , 
          "total" : 90 , 
          "scores" : [ {"level" : 1 , "score" : 90},
                       {"level" : 2 , "score" : 0} ]
        }  );

assert.eq( 2 , t.find( { "scores.level": 2, "scores.score": {$gt:30} } ).itcount() , "A" );
t.ensureIndex( { "scores.level" : 1 , "scores.score" : 1 } );
assert.eq( 2 , t.find( { "scores.level": 2, "scores.score": {$gt:30} } ).itcount() , "B" );