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

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
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 03:34:37
Message-ID: CAGRkXqQkSdHnDLTdJigJfj+gmcW5EMz0UiB+AJ9zcCy-7o-Z6w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 Content-Type Size
v1-0001-Fix-PASSING-of-toasted-text-values-in-JSON-query-.patch application/octet-stream 1.2 KB
v1-0002-Add-tests-for-PASSING-of-toasted-text-values.patch application/octet-stream 2.0 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message shihao zhong 2026-09-19 03:19:51 Re: JSON_SERIALIZE for JSONB returns parts of the internal JSONB representation