summaryrefslogtreecommitdiff
path: root/jstests/core/query/nin/nin2.js
blob: d134f5ad4a49691257b659ea27f827697c1be406 (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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
// @tags: [requires_non_retryable_writes]

// 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);