1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
t = db.index_check5;
t.drop();
t.save({
"name": "Player1",
"scores": [{"level": 1, "score": 100}, {"level": 2, "score": 50}],
"total": 150
});
t.save({
"name": "Player2",
"total": 90,
"scores": [{"level": 1, "score": 90}, {"level": 2, "score": 0}]
});
assert.eq(2, t.find({"scores.level": 2, "scores.score": {$gt: 30}}).itcount(), "A");
t.ensureIndex({"scores.level": 1, "scores.score": 1});
assert.eq(2, t.find({"scores.level": 2, "scores.score": {$gt: 30}}).itcount(), "B");
|