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
|
/**
* Test that $ne: [] queries are cached correctly. See SERVER-39764.
*/
(function() {
load("jstests/libs/analyze_plan.js"); // For getPlanCacheKeyFromShape.
load("jstests/libs/sbe_util.js"); // For checkSBEEnabled.
const coll = db.ne_array_indexability;
coll.drop();
coll.createIndex({"obj": 1});
coll.createIndex({"obj": 1, "abc": 1});
assert.commandWorked(coll.insert({obj: "hi there"}));
function runTest(queryToCache, queryToRunAfterCaching) {
assert.eq(coll.find(queryToCache).itcount(), 1);
assert.eq(coll.find(queryToCache).itcount(), 1);
const keyHash = getPlanCacheKeyFromShape({query: queryToCache, collection: coll, db});
const match = {planCacheKey: keyHash};
const cacheEntries = coll.aggregate([{$planCacheStats: {}}, {$match: match}]).toArray();
assert.eq(cacheEntries.length, 1);
assert.eq(cacheEntries[0].isActive, true);
assert.eq(coll.find(queryToRunAfterCaching).itcount(), 1);
const explain = assert.commandWorked(coll.find(queryToRunAfterCaching).explain());
// For the classic plan cache, the query with the $ne: array should have the same queryHash, but
// a different planCacheKey. The SBE plan cache, on the other hand, does not auto-parameterize
// $in or $eq involving a constant of type array, and therefore will consider the two queries to
// have different shapes.
if (checkSBEEnabled(db, ["featureFlagSbeFull"])) {
assert.neq(explain.queryPlanner.queryHash, cacheEntries[0].queryHash);
} else {
assert.eq(explain.queryPlanner.queryHash, cacheEntries[0].queryHash);
}
// For both the classic and SBE plan caches, the two queries must have different plan cache
// keys.
assert.neq(explain.queryPlanner.planCacheKey, cacheEntries[0].planCacheKey);
}
runTest({'obj': {$ne: 'def'}}, {'obj': {$ne: [[1]]}});
// Clear the cache.
assert.commandWorked(coll.runCommand('planCacheClear'));
runTest({'obj': {$nin: ['abc', 'def']}}, {'obj': {$nin: [[1], 'abc']}});
})();
|
