summaryrefslogtreecommitdiff
path: root/jstests/core/find6.js
blob: c4efd3b88d3b6a903fa6ac3c4d4c763822966b94 (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

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

t.save( { a : 1 } )
t.save( { a : 1 , b : 1 } )

assert.eq( 2 , t.find().count() , "A" );
assert.eq( 1 , t.find( { b : null } ).count() , "B" );
assert.eq( 1 , t.find( "function() { return this.b == null; }" ).itcount() , "C" );
assert.eq( 1 , t.find( "function() { return this.b == null; }" ).count() , "D" );

/* test some stuff with dot array notation */
q = db.find6a;
q.drop();
q.insert( { "a" : [ { "0" : 1 } ] } );
q.insert( { "a" : [ { "0" : 2 } ] } );
q.insert( { "a" : [ 1 ] } );
q.insert( { "a" : [ 9, 1 ] } );

function f() { 

    assert.eq( 2, q.find( { 'a.0' : 1 } ).count(), "da1");
    assert.eq( 2, q.find( { 'a.0' : 1 } ).count(), "da2");
    
    assert.eq( 1, q.find( { 'a.0' : { $gt : 8 } } ).count(), "da3");
    assert.eq( 0, q.find( { 'a.0' : { $lt : 0 } } ).count(), "da4");

}

for( var pass = 0; pass <= 1 ; pass++ ) { 
    f();
    q.ensureIndex({a:1});
}

t = db.multidim;
t.drop();
t.insert({"a" : [ [ ], 1, [ 3, 4 ] ] });
assert.eq(1, t.find({"a.2":[3,4]}).count(), "md1");
assert.eq(1, t.find({"a.2.1":4}).count(), "md2");
assert.eq(0, t.find({"a.2.1":3}).count(), "md3");