mirror of https://github.com/mongodb/mongo
75 lines
1.5 KiB
JavaScript
75 lines
1.5 KiB
JavaScript
// @tags: [
|
|
// requires_non_retryable_writes,
|
|
// requires_getmore,
|
|
// ]
|
|
|
|
// Check multikey index cases with parallel nested fields SERVER-958.
|
|
|
|
let t = db.jstests_indexr;
|
|
t.drop();
|
|
|
|
// Check without indexes.
|
|
t.save({
|
|
a: [
|
|
{b: 3, c: 6},
|
|
{b: 1, c: 1},
|
|
],
|
|
});
|
|
assert.eq(1, t.count({"a.b": {$gt: 2}, "a.c": {$lt: 4}}));
|
|
assert.eq(1, t.count({a: {b: 3, c: 6}, "a.c": {$lt: 4}}));
|
|
|
|
// Check with single key indexes.
|
|
t.remove({});
|
|
t.createIndex({"a.b": 1, "a.c": 1});
|
|
t.createIndex({a: 1, "a.c": 1});
|
|
assert.eq(0, t.count({"a.b": {$gt: 2}, "a.c": {$lt: 4}}));
|
|
assert.eq(0, t.count({a: {b: 3, c: 6}, "a.c": {$lt: 4}}));
|
|
|
|
t.save({a: {b: 3, c: 3}});
|
|
assert.eq(1, t.count({"a.b": {$gt: 2}, "a.c": {$lt: 4}}));
|
|
assert.eq(1, t.count({a: {b: 3, c: 3}, "a.c": {$lt: 4}}));
|
|
|
|
// Check with multikey indexes.
|
|
t.remove({});
|
|
t.save({
|
|
a: [
|
|
{b: 3, c: 6},
|
|
{b: 1, c: 1},
|
|
],
|
|
});
|
|
|
|
assert.eq(1, t.count({"a.b": {$gt: 2}, "a.c": {$lt: 4}}));
|
|
assert.eq(1, t.count({a: {b: 3, c: 6}, "a.c": {$lt: 4}}));
|
|
|
|
// Check reverse direction.
|
|
assert.eq(
|
|
1,
|
|
t
|
|
.find({"a.b": {$gt: 2}, "a.c": {$lt: 4}})
|
|
.sort({"a.b": -1})
|
|
.itcount(),
|
|
);
|
|
assert.eq(
|
|
1,
|
|
t
|
|
.find({a: {b: 3, c: 6}, "a.c": {$lt: 4}})
|
|
.sort({a: -1})
|
|
.itcount(),
|
|
);
|
|
|
|
// Check second field is constrained if first is not.
|
|
assert.eq(
|
|
1,
|
|
t
|
|
.find({"a.c": {$lt: 4}})
|
|
.hint({"a.b": 1, "a.c": 1})
|
|
.itcount(),
|
|
);
|
|
assert.eq(
|
|
1,
|
|
t
|
|
.find({"a.c": {$lt: 4}})
|
|
.hint({a: 1, "a.c": 1})
|
|
.itcount(),
|
|
);
|