Bug? CSV node changing data

The simple flow below shows what looks like the CSV node changing data values. The col3 result is not equal to the input. The input is 28429390120374275 but the output is 28429390120374276???
Any thoughts on why???

[{"id":"4adb98c6.b11238","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"2a244d6f.6c05da","type":"csv","z":"4adb98c6.b11238","name":"","sep":",","hdrin":"","hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":670,"y":460,"wires":[["13569c1f.edb324"]]},{"id":"1fed970b.fde539","type":"inject","z":"4adb98c6.b11238","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"2,normal,28429390120374275,1647637586609,1647637617744","payloadType":"str","x":380,"y":460,"wires":[["2a244d6f.6c05da","a30bb5ca.dad218"]]},{"id":"a30bb5ca.dad218","type":"debug","z":"4adb98c6.b11238","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":590,"y":360,"wires":[]},{"id":"13569c1f.edb324","type":"debug","z":"4adb98c6.b11238","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":880,"y":360,"wires":[]}]

Here is the debug node outputs.
Screenshot 2022-03-18 172153

If you try that in an inject node feeding a debug node you will find the same thing. The reason is that javascript holds numbers as double precision floating point numbers, and the maximum integer that can be held in that format without the possibility of rounding errors is 9,007,199,254,740,991. Your number has one more digit than that so cannot be held accurately. See Number.MAX_SAFE_INTEGER - JavaScript | MDN for more details

(and if you turn off 'parse numeric value" then it will leave it as a string if you need to keep it and then maybe try to handle as a bigint later)

What does the number represent?

Turning off "parse numeric value" is something I can make work.
Thanks everyone.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.