File: queryoptimizer7.js

package info (click to toggle)
mongodb 1%3A2.4.10-5
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 82,464 kB
  • sloc: cpp: 740,225; ansic: 152,098; sh: 13,820; python: 11,864; makefile: 1,012; perl: 922; pascal: 617; java: 452; lisp: 222; asm: 174
file content (31 lines) | stat: -rw-r--r-- 1,044 bytes parent folder | download | duplicates (3)
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} );