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
|
// Test that duplicate query results are not returned.
var t = db.jstests_find_dedup;
function checkDedup(query, idArray) {
resultsArr = t.find(query).toArray();
assert.eq(resultsArr.length, idArray.length, "same number of results");
for (var i = 0; i < idArray.length; i++) {
assert(("_id" in resultsArr[i]), "result doc missing _id");
assert.eq(idArray[i], resultsArr[i]._id, "_id mismatch for doc " + i);
}
}
// Deduping $or
t.drop();
t.ensureIndex({a: 1, b: 1});
t.save({_id: 1, a: 1, b: 1});
t.save({_id: 2, a: 1, b: 1});
t.save({_id: 3, a: 2, b: 2});
t.save({_id: 4, a: 3, b: 3});
t.save({_id: 5, a: 3, b: 3});
checkDedup({$or: [{a:{$gte:0,$lte:2},b:{$gte:0,$lte:2}},
{a:{$gte:1,$lte:3},b:{$gte:1,$lte:3}},
{a:{$gte:1,$lte:4},b:{$gte:1,$lte:4}}]},
[1, 2, 3, 4, 5]);
// Deduping multikey
t.drop();
t.save({_id: 1, a: [1, 2, 3], b: [4, 5, 6]});
t.save({_id: 2, a: [1, 2, 3], b: [4, 5, 6]});
assert.eq( 2, t.count() );
checkDedup({$or: [{a: {$in: [1, 2]}}, {b: {$in: [4, 5]}}]}, [1, 2]);
t.ensureIndex( { a : 1 } );
checkDedup({$or: [{a: {$in: [1, 2]}}, {b: {$in: [4, 5]}}]}, [1, 2]);
|
