summaryrefslogtreecommitdiff
path: root/jstests/aggregation/bugs/server14691.js
blob: 2703f2dead9e8aca3afe72842b0915bde197be82 (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
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}]);
}());