Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL

From: Srinath Reddy Sadipiralla <srinath2133(at)gmail(dot)com>
To: chaitanyyachoudhary(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL
Date: 2026-09-19 00:58:37
Message-ID: CAFC+b6p8Oo3_pLXPa=DVXx1XDQJ09b2W3U3WKPtkQYyh0z0z-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Sep 18, 2026 at 8:33 PM Srinath Reddy Sadipiralla <
srinath2133(at)gmail(dot)com> wrote:

>
> If this approach makes sense, I can write up a formal patch along with the
> appropriate regression test.
>

Here's the patch with tests.

--
Thanks :)
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/

Attachment Content-Type Size
v1-0001-Fix-state-leakage-in-JSON_VALUE-returning-json-jsonb.patch application/octet-stream 4.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-09-19 03:05:45 Re: bug: Gather rescan keeps the first scan's tuple bound in workers
Previous Message Michael Paquier 2026-09-19 00:12:46 Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text