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
50
51
52
|
// SERVER-14691: $avg aggregator should return null when it receives no input.
(function() {
'use strict';
var coll = db.accumulate_avg_sum_null;
// Test the $avg aggregator.
coll.drop();
// Null cases.
assert.writeOK(coll.insert({a: 1, b: 2, c: 'string', d: null}));
// Missing field.
var pipeline = [{$group: {_id: '$a', avg: {$avg: '$missing'}}}];
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: null}]);
// Non-numeric field.
pipeline = [{$group: {_id: '$a', avg: {$avg: '$c'}}}];
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: null}]);
// Field with value of null.
pipeline = [{$group: {_id: '$a', avg: {$avg: '$d'}}}];
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: null}]);
// All three.
coll.insert({a: 1, d: 'string'});
coll.insert({a: 1});
pipeline = [{$group: {_id: '$a', avg: {$avg: '$d'}}}];
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: null}]);
// Non-null cases.
coll.drop();
assert.writeOK(coll.insert({a: 1, b: 2}));
pipeline = [{$group: {_id: '$a', avg: {$avg: '$b'}}}];
// One field.
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: 2}]);
// Two fields.
assert.writeOK(coll.insert({a: 1, b: 4}));
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: 3}]);
// Average of zero should still work.
assert.writeOK(coll.insert({a: 1, b: -6}));
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: 0}]);
// Missing, null, or non-numeric fields should not error or affect the average.
assert.writeOK(coll.insert({a: 1}));
assert.writeOK(coll.insert({a: 1, b: 'string'}));
assert.writeOK(coll.insert({a: 1, b: null}));
assert.eq(coll.aggregate(pipeline).toArray(), [{_id: 1, avg: 0}]);
}());
|