summaryrefslogtreecommitdiff
path: root/jstests/core/indexr.js
blob: d242ad87316664ac57e93a630f501aa6f3ebd06f (plain)
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
// Check multikey index cases with parallel nested fields SERVER-958.

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.ensureIndex({'a.b': 1, 'a.c': 1});
t.ensureIndex({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());