79 lines
1.9 KiB
JavaScript
79 lines
1.9 KiB
JavaScript
// Check recording and playback of good query plans with different index types SERVER-958.
|
|
|
|
t = db.jstests_indexp;
|
|
t.drop();
|
|
|
|
function expectRecordedPlan( query, idx ) {
|
|
explain = t.find( query ).explain( true );
|
|
assert( explain.oldPlan );
|
|
assert.eq( "BtreeCursor " + idx, explain.oldPlan.cursor );
|
|
}
|
|
|
|
function expectNoRecordedPlan( query ) {
|
|
assert.isnull( t.find( query ).explain( true ).oldPlan );
|
|
}
|
|
|
|
// Basic test
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:1,x:1} ).itcount();
|
|
expectRecordedPlan( {a:1,x:1}, "a_1" );
|
|
|
|
// Index type changes
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:1,x:1} ).itcount();
|
|
t.save( {a:[1,2]} );
|
|
expectNoRecordedPlan( {a:1,x:1} );
|
|
|
|
// Multi key QueryPattern reuses index
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.ensureIndex( {x:1} );
|
|
t.save( {a:[1,2],x:1} );
|
|
for( i = 0; i < 5; ++i ) {
|
|
t.save( {a:-1,x:i} );
|
|
}
|
|
t.find( {a:{$gt:0},x:{$gt:0}} ).itcount();
|
|
expectRecordedPlan( {a:{$gt:0,$lt:5},x:{$gt:0}}, "a_1" );
|
|
|
|
// Single key QueryPattern is dropped.
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:{$gt:0,$lt:5},x:1} ).itcount();
|
|
t.save( {a:[1,2]} );
|
|
expectNoRecordedPlan( {a:{$gt:0,$lt:5},x:1} );
|
|
|
|
// Invalid query with only valid fields used
|
|
// SERVER-2864
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:1,b:{$gt:5,$lt:0},x:1} ).itcount();
|
|
expectRecordedPlan( {a:1,b:{$gt:5,$lt:0},x:1}, "a_1" );
|
|
|
|
// SERVER-2864
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.ensureIndex( {c:1} );
|
|
t.save( {a:1,c:1} );
|
|
t.save( {c:1} );
|
|
t.find( {a:1,b:{$gt:5,$lt:0},c:1} ).itcount();
|
|
expectRecordedPlan( {a:1,b:{$gt:5,$lt:0},c:1}, "a_1" );
|
|
|
|
// SERVER-2864
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:{$gt:5,$lt:0},x:1} ).itcount();
|
|
expectNoRecordedPlan( {a:{$gt:0,$lt:5},x:1}, "a_1" );
|
|
|
|
// Dummy query plan not stored
|
|
t.drop();
|
|
t.ensureIndex( {a:1} );
|
|
t.save( {a:1} );
|
|
t.find( {a:{$gt:5,$lt:0},x:1} ).itcount();
|
|
expectNoRecordedPlan( {a:{$gt:5,$lt:0},x:1} );
|