mirror of https://github.com/mongodb/mongo
91 lines
4.3 KiB
JavaScript
91 lines
4.3 KiB
JavaScript
import "jstests/libs/query/sbe_assert_error_override.js";
|
|
|
|
import {assertErrCodeAndErrMsgContains} from "jstests/aggregation/extras/utils.js";
|
|
|
|
// 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();
|
|
|
|
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-5, -3.121724665346865, 3041897608700.073, 1001318343149.7166, -1714.6229586696593,
|
|
1731390114894580.8, 6.256645803154374e-8, -107144114533844.25, -0.08839485091750919, -265119153.02185738,
|
|
-0.02450615965231944, 0.0002684331017079073, 32079040427.68358, -0.04733295911845742, 0.061381859083076085,
|
|
-25329.59126796951, -0.0009567520620034965, -1553879364344.9932, -2.1101077525869814e-8, -298421079729.5547,
|
|
0.03182394834273594, 22.201944843278916, -33.35667991109125, 11496013.960449915, -40652595.33210472,
|
|
3.8496066090328163, 2.5074042398147304e-8, -0.02208724071782122, -134211.37290639878, 0.17640433666616578,
|
|
4.463787499171126, 9.959669945399718, 129265976.35224283, 1.5865526187526546e-7, -4746011.710555799,
|
|
-712048598925.0789, 582214206210.4034, 0.025236204812875362, 530078170.91147506, -14.865307666195053,
|
|
1.6727994895185032e-5, -113386276.03121366, -6.135827207137054, 10644945799901.145, -100848907797.1582,
|
|
2.2404406961625282e-8, 1.315662618424494e-9, -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();
|
|
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();
|
|
assert.eq(result1[0].sum, new Date(1683794065003));
|
|
assert.eq(result1[1].sum, new Date(1683794065003));
|
|
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"]}}}];
|
|
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.Overflow, "date overflow");
|