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
|
// Test a query with 200 $or clauses
t = db.jstests_orf;
t.drop();
var a = [];
var expectBounds = [];
for( var i = 0; i < 200; ++i ) {
a.push( {_id:i} );
expectBounds.push([i, i]);
}
a.forEach( function( x ) { t.save( x ); } );
// This $or query is answered as an index scan over
// a series of _id index point intervals.
explain = t.find( {$or:a} ).hint( {_id: 1} ).explain( true );
printjson( explain );
assert.eq( 'BtreeCursor _id_', explain.cursor, 'cursor' );
assert.eq( expectBounds, explain.indexBounds['_id'], 'indexBounds' );
assert.eq( 200, explain.n, 'n' );
assert.eq( 200, explain.nscanned, 'nscanned' );
assert.eq( 200, explain.nscannedObjects, 'nscannedObjects' );
assert.eq( false, explain.isMultiKey, 'isMultiKey' );
assert.eq( false, explain.scanAndOrder, 'scanAndOrder' );
assert.eq( false, explain.indexOnly, 'indexOnly' );
assert.eq( 200, t.count( {$or:a} ) );
|