mirror of https://github.com/mongodb/mongo
122 lines
5.4 KiB
JavaScript
122 lines
5.4 KiB
JavaScript
(function() {
|
|
"use strict";
|
|
load("jstests/aggregation/extras/utils.js"); // For assertErrorCode and assertErrMsgContains.
|
|
load("jstests/libs/sbe_assert_error_override.js"); // Override error-code-checking APIs.
|
|
// TODO BACKPORT-19405, BACKPORT-19406: SBE and classic have different behaviors documented in this
|
|
// test. These are unified by the SERVER tickets of the mentioned backports.
|
|
load("jstests/libs/sbe_util.js"); // For checkSBEEnabled.
|
|
|
|
// In SERVER-63012, translation of $add expression into sbe now defaults the translation of $add
|
|
// with no operands to a zero integer constant.
|
|
const coll = db.add_coll;
|
|
coll.drop();
|
|
|
|
const isSbeEnabled = checkSBEEnabled(db, ["featureFlagSbeFull"]);
|
|
|
|
assert.commandWorked(coll.insert({x: 1}));
|
|
let result = coll.aggregate([{$project: {y: {$add: []}}}]).toArray();
|
|
assert.eq(result[0]["y"], 0);
|
|
|
|
// Confirm that we're not using DoubleDoubleSummation for $add expression with a set of double
|
|
// values.
|
|
let arr = [
|
|
1.4831356930199802e-05, -3.121724665346865, 3041897608700.073, 1001318343149.7166,
|
|
-1714.6229586696593, 1731390114894580.8, 6.256645803154374e-08, -107144114533844.25,
|
|
-0.08839485091750919, -265119153.02185738, -0.02450615965231944, 0.0002684331017079073,
|
|
32079040427.68358, -0.04733295911845742, 0.061381859083076085, -25329.59126796951,
|
|
-0.0009567520620034965, -1553879364344.9932, -2.1101077525869814e-08, -298421079729.5547,
|
|
0.03182394834273594, 22.201944843278916, -33.35667991109125, 11496013.960449915,
|
|
-40652595.33210472, 3.8496066090328163, 2.5074042398147304e-08, -0.02208724071782122,
|
|
-134211.37290639878, 0.17640433666616578, 4.463787499171126, 9.959669945399718,
|
|
129265976.35224283, 1.5865526187526546e-07, -4746011.710555799, -712048598925.0789,
|
|
582214206210.4034, 0.025236204812875362, 530078170.91147506, -14.865307666195053,
|
|
1.6727994895185032e-05, -113386276.03121366, -6.135827207137054, 10644945799901.145,
|
|
-100848907797.1582, 2.2404406961625282e-08, 1.315662618424494e-09, -0.832190208349044,
|
|
-9.779323414999364, -546522170658.2997
|
|
];
|
|
let doc = {_id: 0};
|
|
let i = 0;
|
|
let queryArr = [];
|
|
arr.forEach(num => {
|
|
i++;
|
|
doc[`f_${i}`] = num;
|
|
queryArr.push(`$f_${i}`);
|
|
});
|
|
|
|
assert.eq(true, coll.drop());
|
|
assert.commandWorked(coll.insert(doc));
|
|
|
|
let addResult = coll.aggregate([{$project: {add: {$add: queryArr}}}]).toArray();
|
|
let sumResult = coll.aggregate([{$project: {sum: {$sum: queryArr}}}]).toArray();
|
|
|
|
// SBE uses doubleDoubleSum for $add and $sum, whereas classic uses it for only $sum.
|
|
if (isSbeEnabled) {
|
|
assert.eq(addResult[0]["add"], sumResult[0]["sum"]);
|
|
} else {
|
|
assert.neq(addResult[0]["add"], sumResult[0]["sum"]);
|
|
assert.eq(addResult[0]["add"], arr.reduce((a, b) => a + b));
|
|
}
|
|
|
|
assert.eq(true, coll.drop());
|
|
// Doubles are rounded to int64 when added to Date
|
|
assert.commandWorked(coll.insert({_id: 0, lhs: new Date(1683794065002), rhs: 0.5}));
|
|
assert.commandWorked(coll.insert({_id: 1, lhs: new Date(1683794065002), rhs: 1.4}));
|
|
assert.commandWorked(coll.insert({_id: 2, lhs: new Date(1683794065002), rhs: 1.5}));
|
|
assert.commandWorked(coll.insert({_id: 3, lhs: new Date(1683794065002), rhs: 1.7}));
|
|
// Decimals are rounded to int64, when tie rounded to even, when added to Date
|
|
assert.commandWorked(
|
|
coll.insert({_id: 4, lhs: new Date(1683794065002), rhs: new NumberDecimal("1.4")}));
|
|
assert.commandWorked(
|
|
coll.insert({_id: 5, lhs: new Date(1683794065002), rhs: new NumberDecimal("1.5")}));
|
|
assert.commandWorked(
|
|
coll.insert({_id: 6, lhs: new Date(1683794065002), rhs: new NumberDecimal("1.7")}));
|
|
assert.commandWorked(
|
|
coll.insert({_id: 7, lhs: new Date(1683794065002), rhs: new NumberDecimal("2.5")}));
|
|
|
|
let result1 =
|
|
coll.aggregate([{$project: {sum: {$add: ["$lhs", "$rhs"]}}}, {$sort: {_id: 1}}]).toArray();
|
|
|
|
// SBE uses doubleDoubleSum for $add whereas classic does not.
|
|
if (isSbeEnabled) {
|
|
assert.eq(result1[0].sum, new Date(1683794065002));
|
|
} else {
|
|
assert.eq(result1[0].sum, new Date(1683794065003));
|
|
}
|
|
assert.eq(result1[1].sum, new Date(1683794065003));
|
|
|
|
// SBE uses doubleDoubleSum for $add whereas classic does not.
|
|
if (isSbeEnabled) {
|
|
assert.eq(result1[2].sum, new Date(1683794065003));
|
|
} else {
|
|
assert.eq(result1[2].sum, new Date(1683794065004));
|
|
}
|
|
assert.eq(result1[3].sum, new Date(1683794065004));
|
|
assert.eq(result1[4].sum, new Date(1683794065003));
|
|
assert.eq(result1[5].sum, new Date(1683794065004));
|
|
assert.eq(result1[6].sum, new Date(1683794065004));
|
|
assert.eq(result1[7].sum, new Date(1683794065004));
|
|
|
|
coll.drop();
|
|
|
|
assert.commandWorked(coll.insert([{
|
|
_id: 0,
|
|
veryBigPositiveLong: NumberLong("9223372036854775806"),
|
|
veryBigPositiveDouble: 9223372036854775806,
|
|
veryBigPositiveDecimal: NumberDecimal("9223372036854775806")
|
|
}]));
|
|
|
|
let pipeline = [{$project: {res: {$add: [new Date(10), "$veryBigPositiveLong"]}}}];
|
|
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.Overflow, "date overflow");
|
|
|
|
pipeline = [{$project: {res: {$add: [new Date(10), "$veryBigPositiveDouble"]}}}];
|
|
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.Overflow, "date overflow");
|
|
|
|
pipeline = [{$project: {res: {$add: [new Date(10), "$veryBigPositiveDecimal"]}}}];
|
|
if (isSbeEnabled) {
|
|
assert.commandWorked(
|
|
coll.getDB().runCommand({aggregate: coll.getName(), pipeline: pipeline, cursor: {}}));
|
|
} else {
|
|
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.Overflow, "date overflow");
|
|
}
|
|
}());
|