summaryrefslogtreecommitdiff
path: root/jstests/exists.js
blob: 3f1e904e52fc78ef5dc399633ec8f1fd3686e463 (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
49
t = db.jstests_exists;
t.drop();

t.save( {} );
t.save( {a:1} );
t.save( {a:{b:1}} );
t.save( {a:{b:{c:1}}} );
t.save( {a:{b:{c:{d:null}}}} );

function dotest( n ){
    
    assert.eq( 5, t.count() , n );
    assert.eq( 1, t.count( {a:null} ) , n );
    assert.eq( 2, t.count( {'a.b':null} ) , n );
    assert.eq( 3, t.count( {'a.b.c':null} ) , n );
    assert.eq( 5, t.count( {'a.b.c.d':null} ) , n );
    
    assert.eq( 5, t.count() , n );
    assert.eq( 4, t.count( {a:{$ne:null}} ) , n );
    assert.eq( 3, t.count( {'a.b':{$ne:null}} ) , n );
    assert.eq( 2, t.count( {'a.b.c':{$ne:null}} ) , n );
    assert.eq( 0, t.count( {'a.b.c.d':{$ne:null}} ) , n );
    
    assert.eq( 4, t.count( {a: {$exists:true}} ) , n );
    assert.eq( 3, t.count( {'a.b': {$exists:true}} ) , n );
    assert.eq( 2, t.count( {'a.b.c': {$exists:true}} ) , n );
    assert.eq( 1, t.count( {'a.b.c.d': {$exists:true}} ) , n );

    assert.eq( 1, t.count( {a: {$exists:false}} ) , n );
    assert.eq( 2, t.count( {'a.b': {$exists:false}} ) , n );
    assert.eq( 3, t.count( {'a.b.c': {$exists:false}} ) , n );
    assert.eq( 4, t.count( {'a.b.c.d': {$exists:false}} ) , n );
}

dotest( "before index" )
t.ensureIndex( { "a" : 1 } )
t.ensureIndex( { "a.b" : 1 } )
t.ensureIndex( { "a.b.c" : 1 } )
t.ensureIndex( { "a.b.c.d" : 1 } )
dotest( "after index" )
assert.eq( 1, t.find( {a: {$exists:false}} ).hint( {a:1} ).itcount() );
    
t.drop();

t.save( {r:[{s:1}]} );
assert( t.findOne( {'r.s':{$exists:true}} ) );
assert( !t.findOne( {'r.s':{$exists:false}} ) );
assert( !t.findOne( {'r.t':{$exists:true}} ) );
assert( t.findOne( {'r.t':{$exists:false}} ) );