BUG #15260: When saving json object to a json column bigInteger valueis saved wrong - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15260: When saving json object to a json column bigInteger valueis saved wrong
Date
Msg-id 153060922319.13258.1825649892372139910@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15260: When saving json object to a json column bigIntegervalue is saved wrong  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15260
Logged by:          Uri Parush
Email address:      urip@ensilo.com
PostgreSQL version: 9.6.0
Operating system:   windows 10
Description:

Hi, I think I found a bug in PostgreSQL json column type.
I created the next table:
CREATE TABLE public."Dummy"
(
   json json
)

And insert the next data:
INSERT INTO public."Dummy"(
    json)
    VALUES (
'{ "ID": 9059650307334996772}'
);


The data that was saved was incorrect:
{"ID":9059650307334997000}

Looks like PostgreSQL round the number in the insertion.


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: NOTIFY does not work as expected
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #15260: When saving json object to a json column bigIntegervalue is saved wrong