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

Hi Manu,

On Thu, Sep 24, 2026 at 1:42 AM Manu <manuelreyesbravo(at)gmail(dot)com> wrote:

> Hi Srinath,
>
> I tested your v1 on master, REL_18_STABLE and REL_17_STABLE, together
> with Andrey's v2 for #19621 [1], which touches the same function. Both
> apply cleanly on all three branches, build without warnings, and the
> main regression suite passes. On all three,
> JSON_VALUE(x, '$' RETURNING jsonb) over '1', 'null', '2' now returns
> 1, NULL, 2 (it was 1, NULL, NULL).
>
> The fix looks right to me: that branch fills val_string but never
> cleared the resnull left by an earlier row.
>
> A small thing: git apply warns about trailing whitespace on four lines
> of the new test in sqljson_queryfuncs.sql.
>
> [1]
>
> https://postgr.es/m/CAB8bMitawD=ERVLwYuDXvMT_OJqf+qAKx=3GEH6V_WHT7jnq7A@mail.gmail.com
>

Thanks for the review; I also looked into the pointed thread
and shared my feedback there, and I fixed the whitespace errors
in this v2 patch.

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