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
|
// SERVER-6239 reenable $add and $subtract with dates with better semantics
// Note: error conditions tested also in server6240.js
load('jstests/aggregation/extras/utils.js');
var millis = 12345;
var num = 54312;
// Clear db
db.s6239.drop();
// Populate db
db.s6239.save({date:new Date(millis), num: num});
function test(expression, expected) {
var res = db.s6239.aggregate({$project: {out: expression}});
assert.eq(res.toArray()[0].out, expected, tojson(expression));
}
function fail(expression, code) {
assertErrorCode(db.s6239, {$project: {out: expression}}, code);
}
test({$subtract: ['$date', '$date']}, NumberLong(0));
test({$subtract: ['$date', '$num']}, new Date(millis - num));
fail({$subtract: ['$num', '$date']}, 16556);
fail({$add: ['$date', '$date']}, 16612);
test({$add: ['$date', '$num']}, new Date(millis + num));
test({$add: ['$num', '$date']}, new Date(millis + num));
// addition supports any number of arguments
test({$add: ['$date']}, new Date(millis));
test({$add: ['$num', '$date', '$num']}, new Date(millis + num + num));
|
