jstests/index_arr2.js


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

NUM = 20;
M = 5;

t = db.jstests_arr2;

function test( withIndex ){
    t.drop();
    
    // insert a bunch of items to force queries to use the index.
    newObject = {
        _id : 1,
        a : [
            { b : { c : 1 }  }
        ]
    }
    
    now = (new Date()).getTime() / 1000;
    for (created = now - NUM; created <= now; created++ ) {
        newObject['created'] = created;
        t.insert(newObject);
        newObject['_id'] ++;
    }
    
    // change the last M items.
    query = {
        'created' : { '$gte' : now - M }
    }
    
    Z = t.find( query ).count();
    
    if ( withIndex ){
        //t.ensureIndex( { 'a.b.c' : 1, 'created' : -1 } )
        //t.ensureIndex( { created : -1 } )
        t.ensureIndex( { 'a.b.c' : 1 } , { name : "x" } )
    }
    
    t.update(query, { '$set' : { "a.0.b.c" : 0 } } , false , true )
    assert.eq( Z , db.getLastErrorObj().n , "num updated withIndex:" + withIndex );
    
    // now see how many were actually updated.
    query['a.b.c'] = 0;
    
    count = t.count(query);

    assert.eq( Z , count , "count after withIndex:" + withIndex );
}

test( false )
test( true );