CREATE TABLE document_wrapper ( id integer NOT NULL, document jsonb NOT NULL, CONSTRAINT document_pkey PRIMARY KEY (id) ) WITH ( OIDS = FALSE ) TABLESPACE pg_default;
2) insert valueinsert into document_wrapper(id, document) values(-8, '{"id":101861191707868275}');
insert into document_wrapper(id, document) values(-8, '{"id":101861191707868275}');
3) select valueSELECT document FROM document_wrapper where id = -8;
SELECT document FROM document_wrapper where id = -8;
4) Observe incorrect result (note 0 at the end):{ "id": 101861191707868270 }?
{ "id": 101861191707868270 }?
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных