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
53
54
55
56
|
/**
* Test the default behavior of window functions when no documents fall in the window.
*/
(function() {
"use strict";
const coll = db[jsTestName()];
coll.drop();
assert.commandWorked(coll.insert({_id: 0, ticker: "MDB", price: 1000, ts: new Date()}));
// Over a non-existent field.
let results =
coll.aggregate([{
$setWindowFields: {
sortBy: {ts: 1},
output: {
defaultStdDev:
{$stdDevPop: "$noField", window: {documents: ["unbounded", "current"]}},
defaultSum: {$sum: "$noField", window: {documents: ["unbounded", "current"]}},
defaultAvg: {$avg: "$noField", window: {documents: ["unbounded", "current"]}},
defaultMin: {$min: "$noField", window: {documents: ["unbounded", "current"]}},
defaultMax: {$max: "$noField", window: {documents: ["unbounded", "current"]}},
}
}
}])
.toArray();
assert.eq(null, results[0].defaultStdDev);
assert.eq(null, results[0].defaultAvg);
assert.eq(null, results[0].defaultMin);
assert.eq(null, results[0].defaultMax);
// $sum is unique as its default value is 0.
assert.eq(0, results[0].defaultSum);
// Over a window with no documents.
results =
coll.aggregate([{
$setWindowFields: {
sortBy: {ts: 1},
output: {
defaultStdDev: {$stdDevPop: "$price", window: {documents: ["unbounded", -1]}},
defaultSum: {$sum: "$price", window: {documents: ["unbounded", -1]}},
defaultAvg: {$avg: "$price", window: {documents: ["unbounded", -1]}},
defaultMin: {$min: "$price", window: {documents: ["unbounded", -1]}},
defaultMax: {$max: "$price", window: {documents: ["unbounded", -1]}},
}
}
}])
.toArray();
assert.eq(null, results[0].defaultStdDev);
assert.eq(null, results[0].defaultAvg);
assert.eq(null, results[0].defaultMin);
assert.eq(null, results[0].defaultMax);
// $sum is unique as its default value is 0.
assert.eq(0, results[0].defaultSum);
})();
|
