Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: chaitanyyachoudhary(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text
Date: 2026-09-19 10:29:16
Message-ID: aq5j_NKhWTLcbzrT@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2026-09-19 11:15:48 BUG #19702: decode() accepts Base64 payload after terminal padding
Previous Message Dean Rasheed 2026-09-19 08:43:07 Re: wrong results: merge when not matched by source