| 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 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirill Reshke | 2026-09-19 04:31:07 | Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated |
| Previous Message | shihao zhong | 2026-09-19 03:19:51 | Re: JSON_SERIALIZE for JSONB returns parts of the internal JSONB representation |