summaryrefslogtreecommitdiff
path: root/jstests/exists9.js
blob: 66378d1b424d8c559f9b79169e4d8351bda751de (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
// SERVER-393 Test exists with various empty array and empty object cases.

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

// Check existence of missing nested field.
t.save( {a:{}} );
assert.eq( 1, t.count( {'a.b':{$exists:false}} ) );
assert.eq( 0, t.count( {'a.b':{$exists:true}} ) );

// With index.
t.ensureIndex( {'a.b':1} );
assert.eq( 1, t.find( {'a.b':{$exists:false}} ).hint( {'a.b':1} ).itcount() );
assert.eq( 0, t.find( {'a.b':{$exists:true}} ).hint( {'a.b':1} ).itcount() );

t.drop();

// Check that an empty array 'exists'.
t.save( {} );
t.save( {a:[]} );
assert.eq( 1, t.count( {a:{$exists:true}} ) );
assert.eq( 1, t.count( {a:{$exists:false}} ) );

// With index.
t.ensureIndex( {a:1} );
assert.eq( 1, t.find( {a:{$exists:true}} ).hint( {a:1} ).itcount() );
assert.eq( 1, t.find( {a:{$exists:false}} ).hint( {a:1} ).itcount() );
assert.eq( 1, t.find( {a:{$exists:false}} ).hint( {a:1} ).explain().nscanned );

t.drop();

// Check that an indexed field within an empty array does not exist.
t.save( {a:{'0':1}} );
t.save( {a:[]} );
assert.eq( 1, t.count( {'a.0':{$exists:true}} ) );
assert.eq( 1, t.count( {'a.0':{$exists:false}} ) );

// With index.
t.ensureIndex( {'a.0':1} );
assert.eq( 1, t.find( {'a.0':{$exists:true}} ).hint( {'a.0':1} ).itcount() );
assert.eq( 1, t.find( {'a.0':{$exists:false}} ).hint( {'a.0':1} ).itcount() );