summaryrefslogtreecommitdiff
path: root/jstests/core/index_bounds_object.js
diff options
context:
space:
mode:
Diffstat (limited to 'jstests/core/index_bounds_object.js')
-rw-r--r--jstests/core/index_bounds_object.js112
1 files changed, 55 insertions, 57 deletions
diff --git a/jstests/core/index_bounds_object.js b/jstests/core/index_bounds_object.js
index 22a7f433efd..b1bdb2e9591 100644
--- a/jstests/core/index_bounds_object.js
+++ b/jstests/core/index_bounds_object.js
@@ -1,61 +1,59 @@
// Index bounds generation tests for Object values.
// @tags: [requires_non_retryable_writes, assumes_unsharded_collection]
(function() {
- "use strict";
-
- load("jstests/libs/analyze_plan.js"); // For assertCoveredQueryAndCount.
-
- const coll = db.index_bounds_object;
- coll.drop();
-
- assert.commandWorked(coll.createIndex({a: 1}));
- assert.writeOK(coll.insert({a: {b: 1}}));
-
- // Test that queries involving comparison operators with objects are covered.
- const proj = {a: 1, _id: 0};
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gt: {b: 0}}}, project: proj, count: 1});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gt: {b: 2}}}, project: proj, count: 0});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gte: {b: 1}}}, project: proj, count: 1});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gte: {b: 1, c: 2}}}, project: proj, count: 0});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$lt: {b: 2}}}, project: proj, count: 1});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$lte: {b: 1}}}, project: proj, count: 1});
-
- // Test that queries involving comparisons with an empty object are covered.
- assert.writeOK(coll.insert({a: {}}));
- assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {}}}, project: proj, count: 1});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$gte: {}}}, project: proj, count: 2});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$lt: {}}}, project: proj, count: 0});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$lte: {}}}, project: proj, count: 1});
-
- // Test that queries involving comparisons with a range of objects are covered.
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gt: {}, $lt: {b: 2}}}, project: proj, count: 1});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$gte: {}, $lt: {b: 2}}}, project: proj, count: 2});
- assertCoveredQueryAndCount(
- {collection: coll, query: {a: {$lt: {}, $gte: {}}}, project: proj, count: 0});
-
- // Test that documents that lie outside of the generated index bounds are not returned. Cannot
- // test empty array upper bounds since that would force the index to be multi-key.
- coll.remove({});
- assert.writeOK(coll.insert({a: "string"}));
- assert.writeOK(coll.insert({a: true}));
- assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {}}}, project: proj, count: 0});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$gte: {}}}, project: proj, count: 0});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$lt: {}}}, project: proj, count: 0});
- assertCoveredQueryAndCount({collection: coll, query: {a: {$lte: {}}}, project: proj, count: 0});
-
- // Adding a document containing an array makes the index multi-key which can never be used for a
- // covered query.
- assert.writeOK(coll.insert({a: []}));
- assert(!isIndexOnly(db, coll.find({a: {$gt: {}}}, proj).explain().queryPlanner.winningPlan));
- assert(!isIndexOnly(db, coll.find({a: {$gte: {}}}, proj).explain().queryPlanner.winningPlan));
- assert(!isIndexOnly(db, coll.find({a: {$lt: {}}}, proj).explain().queryPlanner.winningPlan));
- assert(!isIndexOnly(db, coll.find({a: {$lte: {}}}, proj).explain().queryPlanner.winningPlan));
+"use strict";
+
+load("jstests/libs/analyze_plan.js"); // For assertCoveredQueryAndCount.
+
+const coll = db.index_bounds_object;
+coll.drop();
+
+assert.commandWorked(coll.createIndex({a: 1}));
+assert.writeOK(coll.insert({a: {b: 1}}));
+
+// Test that queries involving comparison operators with objects are covered.
+const proj = {
+ a: 1,
+ _id: 0
+};
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {b: 0}}}, project: proj, count: 1});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {b: 2}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gte: {b: 1}}}, project: proj, count: 1});
+assertCoveredQueryAndCount(
+ {collection: coll, query: {a: {$gte: {b: 1, c: 2}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lt: {b: 2}}}, project: proj, count: 1});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lte: {b: 1}}}, project: proj, count: 1});
+
+// Test that queries involving comparisons with an empty object are covered.
+assert.writeOK(coll.insert({a: {}}));
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {}}}, project: proj, count: 1});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gte: {}}}, project: proj, count: 2});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lt: {}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lte: {}}}, project: proj, count: 1});
+
+// Test that queries involving comparisons with a range of objects are covered.
+assertCoveredQueryAndCount(
+ {collection: coll, query: {a: {$gt: {}, $lt: {b: 2}}}, project: proj, count: 1});
+assertCoveredQueryAndCount(
+ {collection: coll, query: {a: {$gte: {}, $lt: {b: 2}}}, project: proj, count: 2});
+assertCoveredQueryAndCount(
+ {collection: coll, query: {a: {$lt: {}, $gte: {}}}, project: proj, count: 0});
+
+// Test that documents that lie outside of the generated index bounds are not returned. Cannot
+// test empty array upper bounds since that would force the index to be multi-key.
+coll.remove({});
+assert.writeOK(coll.insert({a: "string"}));
+assert.writeOK(coll.insert({a: true}));
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gt: {}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$gte: {}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lt: {}}}, project: proj, count: 0});
+assertCoveredQueryAndCount({collection: coll, query: {a: {$lte: {}}}, project: proj, count: 0});
+
+// Adding a document containing an array makes the index multi-key which can never be used for a
+// covered query.
+assert.writeOK(coll.insert({a: []}));
+assert(!isIndexOnly(db, coll.find({a: {$gt: {}}}, proj).explain().queryPlanner.winningPlan));
+assert(!isIndexOnly(db, coll.find({a: {$gte: {}}}, proj).explain().queryPlanner.winningPlan));
+assert(!isIndexOnly(db, coll.find({a: {$lt: {}}}, proj).explain().queryPlanner.winningPlan));
+assert(!isIndexOnly(db, coll.find({a: {$lte: {}}}, proj).explain().queryPlanner.winningPlan));
})();