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
|
/**
* Test that $ne: [] queries are cached correctly. See SERVER-39764.
*/
(function() {
load("jstests/libs/sbe_util.js"); // For checkSBEEnabled.
const coll = db.ne_array_indexability;
coll.drop();
if (checkSBEEnabled(db, ["featureFlagSbePlanCache"])) {
jsTest.log("Skipping test because SBE and SBE plan cache are both enabled.");
return;
}
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 cacheEntries =
coll.aggregate([
{$planCacheStats: {}},
{
$match: {
isActive: true,
createdFromQuery: {query: queryToCache, sort: {}, projection: {}}
}
}
])
.toArray();
assert.eq(cacheEntries.length, 1);
assert.eq(coll.find(queryToRunAfterCaching).itcount(), 1);
const explain = assert.commandWorked(coll.find(queryToRunAfterCaching).explain());
// The query with the $ne: array should have the same queryHash, but a different
// planCacheKey.
assert.eq(explain.queryPlanner.queryHash, cacheEntries[0].queryHash);
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']}});
})();
|
