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
|
// Some unsatisfiable constraint tests.
t = db.jstests_queryoptimizer7;
function assertPlanWasRecorded( query ) {
var x = t.find( query ).explain( true );
assert.eq( 'BtreeCursor a_1', x.oldPlan.cursor , tojson(x) );
}
function assertNoPlanWasRecorded( query ) {
assert( !t.find( query ).explain( true ).oldPlan );
}
// A query plan can be recorded and reused in the presence of a single key index
// constraint that would be impossible for a single key index, but is unindexed.
t.drop();
t.ensureIndex( {a:1} );
t.find( {a:1,b:1,c:{$gt:5,$lt:5}} ).itcount();
assertPlanWasRecorded( {a:1,b:1,c:{$gt:5,$lt:5}} );
// A query plan for an indexed unsatisfiable single key index constraint is not recorded.
t.drop();
t.ensureIndex( {a:1} );
t.find( {a:{$gt:5,$lt:5},b:1} ).itcount();
assertNoPlanWasRecorded( {a:{$gt:5,$lt:5},b:1} );
// A query plan for an unsatisfiable multikey index constraint is not recorded.
t.drop();
t.ensureIndex( {a:1} );
t.find( {a:{$in:[]},b:1} ).itcount();
assertNoPlanWasRecorded( {a:{$in:[]},b:1} );
|
