1
// SERVER-6239 reenable $add and $subtract with dates with better semantics
2
// Note: error conditions tested also in server6240.js
4
load('jstests/aggregation/extras/utils.js');
13
db.s6239.save({date:new Date(millis), num: num});
15
function test(expression, expected) {
16
var res = db.s6239.aggregate({$project: {out: expression}});
17
assert.commandWorked(res, tojson(expression));
18
assert.eq(res.result[0].out, expected, tojson(expression));
20
function fail(expression, code) {
21
assertErrorCode(db.s6239, {$project: {out: expression}}, code);
24
test({$subtract: ['$date', '$date']}, NumberLong(0));
25
test({$subtract: ['$date', '$num']}, new Date(millis - num));
26
fail({$subtract: ['$num', '$date']}, 16556);
28
fail({$add: ['$date', '$date']}, 16612);
29
test({$add: ['$date', '$num']}, new Date(millis + num));
30
test({$add: ['$num', '$date']}, new Date(millis + num));
32
// addition supports any number of arguments
33
test({$add: ['$date']}, new Date(millis));
34
test({$add: ['$num', '$date', '$num']}, new Date(millis + num + num));