Request a Demo
Home   >   mailing lists

Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text - Mailing list pgsql-bugs

From shihao zhong
Subject Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text
Date
Msg-id CAGRkXqQkSdHnDLTdJigJfj+gmcW5EMz0UiB+AJ9zcCy-7o-Z6w@mail.gmail.com
Whole thread
In response to Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text
List pgsql-bugs
Tree view
Hi,

I can reproduce this on master. It is not limited to EXTERNAL storage.
With the default storage an inline compressed value hits it too, so any
large text column passed with PASSING gives a wrong result.

Chaitanya, I hope you don't mind that I wrote it up. The fix is the one
you suggested.

Thanks,
Shihao


Attachment

pgsql-bugs by date:

Previous
From: shihao zhong
Date:
Subject: Re: JSON_SERIALIZE for JSONB returns parts of the internal JSONB representation
Next
From: Kirill Reshke
Date:
Subject: Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated