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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
/**
* Test that for SBE plans a plan cache entry includes a serialized SBE plan tree, and does not for
* classic plans.
*
* @tags: [
* # If all chunks are moved off of a shard, it can cause the plan cache to miss commands.
* assumes_balancer_off,
* does_not_support_stepdowns,
* # This test attempts to perform queries with plan cache filters set up. The former operation
* # may be routed to a secondary in the replica set, whereas the latter must be routed to the
* # primary.
* assumes_read_concern_unchanged,
* assumes_read_preference_unchanged,
* assumes_unsharded_collection,
* # The SBE plan cache was introduced in 6.0.
* requires_fcv_60,
* ]
*/
(function() {
"use strict";
load("jstests/libs/sbe_util.js"); // For checkSBEEnabled.
const coll = db.plan_cache_sbe;
coll.drop();
const isSbeEnabled = checkSBEEnabled(db, ["featureFlagSbeFull"], true /* checkAllNodes */);
assert.commandWorked(coll.insert({a: 1, b: 1}));
// Check that a new entry is added to the plan cache even for single plans.
if (isSbeEnabled) {
assert.eq(1, coll.find({a: 1}).itcount());
// Validate sbe plan cache stats entry.
const allStats = coll.aggregate([{$planCacheStats: {}}]).toArray();
assert.eq(allStats.length, 1, allStats);
const stats = allStats[0];
assert(stats.hasOwnProperty("isPinned"), stats);
assert(stats.isPinned, stats);
assert(stats.hasOwnProperty("cachedPlan"), stats);
assert(stats.cachedPlan.hasOwnProperty("slots"), stats);
assert(stats.cachedPlan.hasOwnProperty("stages"), stats);
coll.getPlanCache().clear();
}
// We need two indexes so that the multi-planner is executed.
assert.commandWorked(coll.createIndex({a: 1}));
assert.commandWorked(coll.createIndex({a: 1, b: 1}));
assert.eq(1, coll.find({a: 1}).itcount());
// Validate plan cache stats entry.
const allStats = coll.aggregate([{$planCacheStats: {}}]).toArray();
assert.eq(allStats.length, 1, allStats);
const stats = allStats[0];
assert(stats.hasOwnProperty("cachedPlan"), stats);
if (isSbeEnabled) {
assert(stats.cachedPlan.hasOwnProperty("slots"), stats);
assert(stats.cachedPlan.hasOwnProperty("stages"), stats);
} else {
assert(!stats.cachedPlan.hasOwnProperty("queryPlan"), stats);
assert(!stats.cachedPlan.hasOwnProperty("slotBasedPlan"), stats);
}
})();
|