blob: caa76b4926804ab1649c1afd98c9fbf7be40d98d (
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
|
/**
* Test that standard deviation works as a window function.
*/
(function() {
"use strict";
load("jstests/aggregation/extras/window_function_helpers.js");
const coll = db[jsTestName()];
coll.drop();
// Create a collection of tickers and prices.
const nDocsPerTicker = 10;
seedWithTickerData(coll, nDocsPerTicker);
// Run the suite of partition and bounds tests against the $stdDevPop function.
testAccumAgainstGroup(coll, "$stdDevPop");
// Run the suite of partition and bounds tests against the $stdDevSamp function.
testAccumAgainstGroup(coll, "$stdDevSamp");
// Test that $stdDevPop and $stdDevSamp return null for windows which do not contain numeric values.
let results =
coll.aggregate([
{$addFields: {str: "hiya"}},
{
$setWindowFields: {
sortBy: {ts: 1},
output: {
stdDevPop:
{$stdDevPop: "$str", window: {documents: ["unbounded", "current"]}},
stdDevSamp:
{$stdDevSamp: "$str", window: {documents: ["unbounded", "current"]}},
}
}
}
])
.toArray();
for (let index = 0; index < results.length; index++) {
assert.eq(null, results[index].stdDevPop);
assert.eq(null, results[index].stdDevSamp);
}
})();
|
