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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
|
// Check that $nin is the opposite of $in SERVER-3264
t = db.jstests_nin2;
t.drop();
// Check various operator types.
function checkOperators( array, inMatches ) {
inCount = inMatches ? 1 : 0;
notInCount = 1 - inCount;
assert.eq( inCount, t.count( {foo:{$in:array}} ) );
assert.eq( notInCount, t.count( {foo:{$not:{$in:array}}} ) );
assert.eq( notInCount, t.count( {foo:{$nin:array}} ) );
assert.eq( inCount, t.count( {foo:{$not:{$nin:array}}} ) );
}
t.save({});
assert.eq( 1, t.count( {foo:null} ) );
assert.eq( 0, t.count( {foo:{$ne:null}} ) );
assert.eq( 0, t.count( {foo:1} ) );
// Check matching null against missing field.
checkOperators( [null], true );
checkOperators( [null,1], true );
checkOperators( [1,null], true );
t.remove();
t.save({foo:null});
assert.eq( 1, t.count( {foo:null} ) );
assert.eq( 0, t.count( {foo:{$ne:null}} ) );
assert.eq( 0, t.count( {foo:1} ) );
// Check matching empty set.
checkOperators( [], false );
// Check matching null against missing null field.
checkOperators( [null], true );
checkOperators( [null,1], true );
checkOperators( [1,null], true );
t.remove();
t.save({foo:1});
assert.eq( 0, t.count( {foo:null} ) );
assert.eq( 1, t.count( {foo:{$ne:null}} ) );
assert.eq( 1, t.count( {foo:1} ) );
// Check matching null against 1.
checkOperators( [null], false );
checkOperators( [null,1], true );
checkOperators( [1,null], true );
t.remove();
t.save( {foo:[0,1]} );
// Check exact match of embedded array.
checkOperators( [[0,1]], true );
t.remove();
t.save( {foo:[]} );
// Check exact match of embedded empty array.
checkOperators( [[]], true );
t.remove();
t.save( {foo:'foo'} );
// Check regex match.
checkOperators( [/o/], true );
|