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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
// Cannot implicitly shard accessed collections because the explain output from a mongod when run
// against a sharded collection is wrapped in a "shards" object with keys for each shard.
// @tags: [assumes_unsharded_collection, does_not_support_stepdowns]
// Read ops tests for partial indexes.
// Include helpers for analyzing explain output.
load("jstests/libs/analyze_plan.js");
(function() {
"use strict";
var explain;
var coll = db.index_partial_read_ops;
coll.drop();
assert.commandWorked(coll.ensureIndex({x: 1}, {partialFilterExpression: {a: {$lte: 1.5}}}));
assert.commandWorked(coll.insert({x: 5, a: 2})); // Not in index.
assert.commandWorked(coll.insert({x: 6, a: 1})); // In index.
//
// Verify basic functionality with find().
//
// find() operations that should use index.
explain = coll.explain('executionStats').find({x: 6, a: 1}).finish();
assert.eq(1, explain.executionStats.nReturned);
assert(isIxscan(db, explain.queryPlanner.winningPlan));
explain = coll.explain('executionStats').find({x: {$gt: 1}, a: 1}).finish();
assert.eq(1, explain.executionStats.nReturned);
assert(isIxscan(db, explain.queryPlanner.winningPlan));
explain = coll.explain('executionStats').find({x: 6, a: {$lte: 1}}).finish();
assert.eq(1, explain.executionStats.nReturned);
assert(isIxscan(db, explain.queryPlanner.winningPlan));
// find() operations that should not use index.
explain = coll.explain('executionStats').find({x: 6, a: {$lt: 1.6}}).finish();
assert.eq(1, explain.executionStats.nReturned);
assert(isCollscan(db, explain.queryPlanner.winningPlan));
explain = coll.explain('executionStats').find({x: 6}).finish();
assert.eq(1, explain.executionStats.nReturned);
assert(isCollscan(db, explain.queryPlanner.winningPlan));
//
// Verify basic functionality with the count command.
//
// Count operation that should use index.
explain = coll.explain('executionStats').count({x: {$gt: 1}, a: 1});
assert(isIxscan(db, explain.queryPlanner.winningPlan));
// Count operation that should not use index.
explain = coll.explain('executionStats').count({x: {$gt: 1}, a: 2});
assert(isCollscan(db, explain.queryPlanner.winningPlan));
//
// Verify basic functionality with the aggregate command.
//
// Aggregate operation that should use index.
explain = coll.aggregate([{$match: {x: {$gt: 1}, a: 1}}], {explain: true});
assert(isIxscan(db, explain.queryPlanner.winningPlan));
// Aggregate operation that should not use index.
explain = coll.aggregate([{$match: {x: {$gt: 1}, a: 2}}], {explain: true});
assert(isCollscan(db, explain.queryPlanner.winningPlan));
//
// Verify basic functionality with the findAndModify command.
//
// findAndModify operation that should use index.
explain = coll.explain('executionStats')
.findAndModify({query: {x: {$gt: 1}, a: 1}, update: {$inc: {x: 1}}});
assert.eq(1, explain.executionStats.nReturned);
assert(isIxscan(db, explain.queryPlanner.winningPlan));
// findAndModify operation that should not use index.
explain = coll.explain('executionStats')
.findAndModify({query: {x: {$gt: 1}, a: 2}, update: {$inc: {x: 1}}});
assert.eq(1, explain.executionStats.nReturned);
assert(isCollscan(db, explain.queryPlanner.winningPlan));
})();
|