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