summaryrefslogtreecommitdiff
path: root/jstests/queryoptimizer9.js
blob: c439e494d2b08450a9c65a67aba9687d3fcdf736 (plain)
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
// When an index becomes multikey the query plan cache is cleared.  SERVER-5301

t = db.jstests_queryoptimizer9;
t.drop();

function recordQueryPlan() {
    t.find( { a:1, b:1 } ).explain();
}

function hasCachedPlan() {
    return !!t.find( { a:1, b:1 } ).explain( true ).oldPlan;
}

t.ensureIndex( { a:1 } );
t.save( { a:1 } );

recordQueryPlan();
assert( hasCachedPlan() );

// While the index is not multikey the cached query plan is not cleared.
t.save( { a:2 } );
assert( hasCachedPlan() );

// When the index becomes multikey the cached query plan is cleared.
t.save( { a:[ 3, 4 ] } );
assert( !hasCachedPlan() );

// When the index remains multikey the cached query plan is not cleared.
recordQueryPlan();
t.save( { a:[ 5, 6 ] } );
assert( hasCachedPlan() );