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

From: Manu <manuelreyesbravo(at)gmail(dot)com>
To: Srinath Reddy Sadipiralla <srinath2133(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Amit Langote <amitlangote09(at)gmail(dot)com>, chaitanyyachoudhary(at)gmail(dot)com
Subject: Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL
Date: 2026-09-24 20:49:27
Message-ID: 179028296766.3788466.15613172266972648668@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Srinath,

> I fixed the whitespace errors in this v2 patch.

Thanks. v2 removes the trailing spaces from the four queries in
sqljson_queryfuncs.sql, but not from the same four lines in
expected/sqljson_queryfuncs.out, which echoes them, so on master
(89829354de1) the test now fails on whitespace alone. The
regression.diffs is attached; the query results themselves are right.

With the trailing spaces removed from those four lines of the .out as
well, the test passes. Sorry for the extra round, it was my nit.

Regards,
Manu

Attachment Content-Type Size
nocfbot-v2-regression.diffs.txt text/plain 1.4 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Zsolt Parragi 2026-09-24 20:41:07 Re: autovacuum: automatically propagate updated parameters