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 Michael Paquier
Subject Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text
Date
Msg-id aq5j_NKhWTLcbzrT@paquier.xyz
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  (shihao zhong <zhong950419@gmail.com>)
List pgsql-bugs
Tree view 
On Fri, Sep 18, 2026 at 11:34:37PM -0400, shihao zhong wrote:
> 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.

Yep, that sounds pretty much right, but it also feels like the tests
could be extended a bit.  Will adjust a few things and fix down to
v17.

Thanks for the report.
--
Michael
Attachment

pgsql-bugs by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: wrong results: merge when not matched by source
Next
From: PG Bug reporting form
Date:
Subject: BUG #19702: decode() accepts Base64 payload after terminal padding