summaryrefslogtreecommitdiff
path: root/jstests/core/regex5.js
blob: 69537e149e530fa0b2548eee1468993b95acf0f6 (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

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

// Add filler data to make sure that indexed solutions are
// chosen over collection scans.
for (var i = 0; i < 10; i++) {
    t.save({filler: "filler"});
}

t.save({x: ["abc", "xyz1"]});
t.save({x: ["ac", "xyz2"]});

a = /.*b.*c/;
x = /.*y.*/;

doit = function() {
    assert.eq(1, t.find({x: a}).count(), "A");
    assert.eq(2, t.find({x: x}).count(), "B");
    assert.eq(2, t.find({x: {$in: [x]}}).count(), "C");            // SERVER-322
    assert.eq(1, t.find({x: {$in: [a, "xyz1"]}}).count(), "D");    // SERVER-322
    assert.eq(2, t.find({x: {$in: [a, "xyz2"]}}).count(), "E");    // SERVER-322
    assert.eq(1, t.find({x: {$all: [a, x]}}).count(), "F");        // SERVER-505
    assert.eq(1, t.find({x: {$all: [a, "abc"]}}).count(), "G");    // SERVER-505
    assert.eq(0, t.find({x: {$all: [a, "ac"]}}).count(), "H");     // SERVER-505
    assert.eq(10, t.find({x: {$nin: [x]}}).count(), "I");          // SERVER-322
    assert.eq(11, t.find({x: {$nin: [a, "xyz1"]}}).count(), "J");  // SERVER-322
    assert.eq(10, t.find({x: {$nin: [a, "xyz2"]}}).count(), "K");  // SERVER-322
    assert.eq(2, t.find({x: {$not: {$nin: [x]}}}).count(), "L");   // SERVER-322
    assert.eq(11, t.find({x: {$nin: [/^a.c/]}}).count(), "M");     // SERVER-322
};

doit();
t.ensureIndex({x: 1});
print("now indexed");
doit();

// SERVER-505
assert.eq(0, t.find({x: {$all: ["a", /^a/]}}).itcount());
assert.eq(2, t.find({x: {$all: [/^a/]}}).itcount());