Обсуждение: BUG #15260: When saving json object to a json column bigInteger valueis saved wrong

Поиск
Список
Период
Сортировка

BUG #15260: When saving json object to a json column bigInteger valueis saved wrong

От
PG Bug reporting form
Дата:
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.

Re: BUG #15260: When saving json object to a json column bigIntegervalue is saved wrong

От
Magnus Hagander
Дата:

On Tue, Jul 3, 2018 at 11:13 AM, PG Bug reporting form <noreply@postgresql.org> wrote:
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.

Doesn't work that way for me -- mine returns the original number. In particular, the json datatype doesn't do any parsing at all, so it "cannot happen". jsonb does parsing, but that one also doesn't round it off.

Are you doing this from psql or some other frontend tool? My guess is the frontend tool is somehow messing with the data for you. If you didn't already do it in psql, please confirm if you can reproduce it from there.

--

RE: BUG #15260: When saving json object to a json column bigIntegervalue is saved wrong

От
Uri Parush
Дата:

I’m using pgAdmin.

I will check it without it now

 

From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Tuesday, July 3, 2018 12:18 PM
To: urip@ensilo.com; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15260: When saving json object to a json column bigInteger value is saved wrong

 

 

On Tue, Jul 3, 2018 at 11:13 AM, PG Bug reporting form <noreply@postgresql.org> wrote:

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.

 

Doesn't work that way for me -- mine returns the original number. In particular, the json datatype doesn't do any parsing at all, so it "cannot happen". jsonb does parsing, but that one also doesn't round it off.


Are you doing this from psql or some other frontend tool? My guess is the frontend tool is somehow messing with the data for you. If you didn't already do it in psql, please confirm if you can reproduce it from there.

 

--

Re: BUG #15260: When saving json object to a json column bigInteger value is saved wrong

От
Flo Rance
Дата:
I can reproduce this bug, at least with pgadmin4 2.1 (View Data -> All rows).

You should take a look there to see if it has been already reported: https://redmine.postgresql.org/projects/pgadmin4/issues

Regards,
Flo

On Tue, Jul 3, 2018 at 11:21 AM, Uri Parush <urip@ensilo.com> wrote:

I’m using pgAdmin.

I will check it without it now

 

From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Tuesday, July 3, 2018 12:18 PM
To: urip@ensilo.com; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15260: When saving json object to a json column bigInteger value is saved wrong

 

 

On Tue, Jul 3, 2018 at 11:13 AM, PG Bug reporting form <noreply@postgresql.org> wrote:

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.

 

Doesn't work that way for me -- mine returns the original number. In particular, the json datatype doesn't do any parsing at all, so it "cannot happen". jsonb does parsing, but that one also doesn't round it off.


Are you doing this from psql or some other frontend tool? My guess is the frontend tool is somehow messing with the data for you. If you didn't already do it in psql, please confirm if you can reproduce it from there.

 

--


Вложения