From: Manu <manuelreyesbravo@gmail.com>
To: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org, Amit Langote <amitlangote09@gmail.com>,
 chaitanyyachoudhary@gmail.com
Subject: Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later
 evaluation once one evaluation returns NULL
Date: Thu, 24 Sep 2026 17:49:27 -0300
Message-ID: <179028296766.3788466.15613172266972648668@gmail.com>
In-Reply-To: 
 <CAFC+b6q5GZFvkpQV1tmioEjY=d-N+3LYCnUPo5bV0LbG95+N8A@mail.gmail.com>
References: 
 <CAFC+b6q5GZFvkpQV1tmioEjY=d-N+3LYCnUPo5bV0LbG95+N8A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6382362653838728406=="
Archived-At: 
 <https://www.postgresql.org/message-id/179028296766.3788466.15613172266972648668%40gmail.com>
Precedence: bulk

--===============6382362653838728406==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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

--===============6382362653838728406==
Content-Type: text/plain
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="nocfbot-v2-regression.diffs.txt"
MIME-Version: 1.0

ZGlmZiAtVTMgc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zcWxqc29uX3F1ZXJ5ZnVuY3Mub3V0
IHNyYy90ZXN0L3JlZ3Jlc3MvcmVzdWx0cy9zcWxqc29uX3F1ZXJ5ZnVuY3Mub3V0Ci0tLSBzcmMv
dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NxbGpzb25fcXVlcnlmdW5jcy5vdXQJMjAyNi0wOS0yNCAx
Nzo0NzowOS40NjI2NjMyMDIgLTAzMDAKKysrIHNyYy90ZXN0L3JlZ3Jlc3MvcmVzdWx0cy9zcWxq
c29uX3F1ZXJ5ZnVuY3Mub3V0CTIwMjYtMDktMjQgMTc6NDc6MTQuMjYwMTg0NzI5IC0wMzAwCkBA
IC01NTcsNyArNTU3LDcgQEAKIC0tIFRlc3Qgc3RhdGUgbGVha2FnZSBvZiBudWxsIGZsYWdzIGlu
IEpTT05fVkFMVUUgd2l0aCBSRVRVUk5JTkcganNvbi9qc29uYgogLS0gKENoZWNrcyB0aGF0IGEg
TlVMTCBldmFsdWF0aW9uIGRvZXNuJ3QgcG9pc29uIHN1YnNlcXVlbnQgZXZhbHVhdGlvbnMgaW4g
dGhlIHNhbWUgc3RhdGVtZW50KQogLS0gMS4gU2FtZSBzdGF0ZW1lbnQsIHNlcGFyYXRlIGNvbHVt
bnMgKEpTT05CKQotU0VMRUNUIEpTT05fVkFMVUUoJ251bGwnLCAnJCcgUkVUVVJOSU5HIGpzb25i
KSBBUyBjb2wxLCAKK1NFTEVDVCBKU09OX1ZBTFVFKCdudWxsJywgJyQnIFJFVFVSTklORyBqc29u
YikgQVMgY29sMSwKICAgICAgICBKU09OX1ZBTFVFKCcxMjMnLCAnJCcgUkVUVVJOSU5HIGpzb25i
KSBBUyBjb2wyOwogIGNvbDEgfCBjb2wyIAogLS0tLS0tKy0tLS0tLQpAQCAtNTY1LDcgKzU2NSw3
IEBACiAoMSByb3cpCiAKIC0tIDIuIEFjcm9zcyBtdWx0aXBsZSByb3dzIChKU09OQikKLVNFTEVD
VCBKU09OX1ZBTFVFKHgsICckJyBSRVRVUk5JTkcganNvbmIpIAorU0VMRUNUIEpTT05fVkFMVUUo
eCwgJyQnIFJFVFVSTklORyBqc29uYikKIEZST00gKFZBTFVFUyAoJzEnOjpqc29uYiksICgnbnVs
bCcpLCAoJzInKSkgdih4KTsKICBqc29uX3ZhbHVlIAogLS0tLS0tLS0tLS0tCkBAIC01NzUsNyAr
NTc1LDcgQEAKICgzIHJvd3MpCiAKIC0tIDMuIFNhbWUgc3RhdGVtZW50LCBzZXBhcmF0ZSBjb2x1
bW5zIChKU09OKQotU0VMRUNUIEpTT05fVkFMVUUoJ251bGwnLCAnJCcgUkVUVVJOSU5HIGpzb24p
IEFTIGNvbDEsIAorU0VMRUNUIEpTT05fVkFMVUUoJ251bGwnLCAnJCcgUkVUVVJOSU5HIGpzb24p
IEFTIGNvbDEsCiAgICAgICAgSlNPTl9WQUxVRSgnMTIzJywgJyQnIFJFVFVSTklORyBqc29uKSBB
UyBjb2wyOwogIGNvbDEgfCBjb2wyIAogLS0tLS0tKy0tLS0tLQpAQCAtNTgzLDcgKzU4Myw3IEBA
CiAoMSByb3cpCiAKIC0tIDQuIEFjcm9zcyBtdWx0aXBsZSByb3dzIChKU09OKQotU0VMRUNUIEpT
T05fVkFMVUUoeCwgJyQnIFJFVFVSTklORyBqc29uKSAKK1NFTEVDVCBKU09OX1ZBTFVFKHgsICck
JyBSRVRVUk5JTkcganNvbikKIEZST00gKFZBTFVFUyAoJzEnOjpqc29uKSwgKCdudWxsJyksICgn
MicpKSB2KHgpOwogIGpzb25fdmFsdWUgCiAtLS0tLS0tLS0tLS0K

--===============6382362653838728406==--