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
|
// Test a query with 200 $or clauses
t = db.jstests_orf;
t.drop();
a = [];
for( var i = 0; i < 200; ++i ) {
a.push( {_id:i} );
}
a.forEach( function( x ) { t.save( x ); } );
explain = t.find( {$or:a} ).explain( true );
// printjson( explain );
assert.eq( 200, explain.n );
// QUERY MIGRATION
// The new query systems collapses this $or into a single collection scan
//
// clauses = explain.clauses;
// for( i = 0; i < clauses.length; ++i ) {
// c = clauses[ i ];
// assert.eq( 'BtreeCursor _id_', c.cursor );
// assert.eq( false, c.isMultiKey );
// assert.eq( 1, c.n, 'n' );
// assert.eq( 1, c.nscannedObjects, 'nscannedObjects' );
// assert.eq( 1, c.nscanned, 'nscanned' );
// assert.eq( false, c.scanAndOrder );
// assert.eq( false, c.indexOnly );
// assert.eq( {_id:[[i,i]]}, c.indexBounds );
// allPlans = c.allPlans;
// assert.eq( 1, allPlans.length );
// plan = allPlans[ 0 ];
// assert.eq( 'BtreeCursor _id_', plan.cursor );
// assert.eq( 1, plan.n, 'n' );
// assert.eq( 1, plan.nscannedObjects, 'nscannedObjects' );
// assert.eq( 1, plan.nscanned, 'nscanned' );
// assert.eq( {_id:[[i,i]]}, plan.indexBounds );
// }
// assert.eq( 200, clauses.length );
assert.eq( 200, t.count( {$or:a} ) );
|