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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
// test that or duplicates are dropped in certain special cases
t = db.jstests_orc;
t.drop();
// The goal here will be to ensure the full range of valid values is scanned for each or clause, in
// order to ensure that
// duplicates are eliminated properly in the cases below when field range elimination is not
// employed. The deduplication
// of interest will occur on field a. The range specifications for fields b and c are such that (in
// the current
// implementation) field range elimination will not occur between the or clauses, meaning that the
// full range of valid values
// will be scanned for each clause and deduplication will be forced.
// NOTE This test uses some tricks to avoid or range elimination, but in future implementations
// these tricks may not apply.
// Perhaps it would be worthwhile to create a mode where range elimination is disabled so it will be
// possible to write a more
// robust test.
t.ensureIndex({a: -1, b: 1, c: 1});
// sanity test
t.save({a: null, b: 4, c: 4});
assert.eq(1, t.count({
$or: [
{a: null, b: {$gte: 0, $lte: 5}, c: {$gte: 0, $lte: 5}},
{a: null, b: {$gte: 3, $lte: 8}, c: {$gte: 3, $lte: 8}}
]
}));
// from here on is SERVER-2245
t.remove({});
t.save({b: 4, c: 4});
assert.eq(1, t.count({
$or: [
{a: null, b: {$gte: 0, $lte: 5}, c: {$gte: 0, $lte: 5}},
{a: null, b: {$gte: 3, $lte: 8}, c: {$gte: 3, $lte: 8}}
]
}));
// t.remove({});
// t.save( {a:[],b:4,c:4} );
// printjson( t.find(
// {$or:[{a:[],b:{$gte:0,$lte:5},c:{$gte:0,$lte:5}},{a:[],b:{$gte:3,$lte:8},c:{$gte:3,$lte:8}}]}
// ).explain() );
// assert.eq( 1, t.count(
// {$or:[{a:[],b:{$gte:0,$lte:5},c:{$gte:0,$lte:5}},{a:[],b:{$gte:3,$lte:8},c:{$gte:3,$lte:8}}]} )
// );
|
