pgwire icon indicating copy to clipboard operation
pgwire copied to clipboard

unsafe int8 json

Open exe-dealer opened this issue 3 years ago • 1 comments

select to_json(int8(9007199254740991 + 1))

JSON.parse parses all numbers as 53bit integers . When number is too big then JSON.parse silently loose precision what is not safe. Need to fix JSON.parse behavior (which will degrade perfomance) or document this pitfall

exe-dealer avatar Aug 30 '21 18:08 exe-dealer