Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1ww9E6-001mTd-06
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 18 Aug 2026 02:06:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1ww9E2-00DJo6-0X
	for pgsql-bugs@arkaria.postgresql.org;
	Tue, 18 Aug 2026 02:06:51 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <zengman@halodbtech.com>)
	id 1ww9E1-00DJny-1N
	for pgsql-bugs@lists.postgresql.org;
	Tue, 18 Aug 2026 02:06:51 +0000
Received: from smtpbgau2.qq.com ([54.206.34.216])
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <zengman@halodbtech.com>)
	id 1ww9Dt-0000000193m-0gQm
	for pgsql-bugs@lists.postgresql.org;
	Tue, 18 Aug 2026 02:06:48 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com;
	s=wqvr2403; t=1787018780;
	bh=nfpyFg4ldXv+786/zc5g3KUZ1rf1xu/81elZZgU6xYc=;
	h=From:To:Subject:Mime-Version:Date:Message-ID;
	b=NCXF1bYvGYOR5RU0KJ7qgAX5wqOHCsA8kQcc1k0opPSQmVaU/OULPgPrki04T7ts8
	 nIOlsw6lboI6k2jH2C9oFEtg8ECg6pkStFZncMJ9U3uIyYSo2vKWOMHljAybOJkxqD
	 x9T5Z/oQhlKWv2Ieiy7J9z/YioeQpXWGzRk5O/QQ=
EX-QQ-RecipientCnt: 4
X-QQ-GoodBg: 2
X-QQ-SSF: 00400000000000F0
X-QQ-FEAT: D4aqtcRDiqS+iirjp6p4NhxMIq0vlVtV32vjsPibZRo=
X-QQ-BUSINESS-ORIGIN: 2
X-QQ-Originating-IP: njjsNQi//Dz6uic15AW8HZUoo1s17z5LxTZ7F4lDcII=
X-Originating-IP: 112.10.242.138
X-QQ-STYLE: 
X-QQ-mid: lv3gz7b-4t1787018776t79d99cfb
From: "=?ISO-8859-1?B?emVuZ21hbg==?=" <zengman@halodbtech.com>
To: "=?ISO-8859-1?B?QW5kcmV5IFJhY2hpdHNraXk=?=" <pl0h0yp1@gmail.com>,
 "=?ISO-8859-1?B?c3l6aG9uZzE2?=" <syzhong16@gmail.com>,
 "=?ISO-8859-1?B?cGdzcWwtYnVncw==?=" <pgsql-bugs@lists.postgresql.org>
Cc: "=?ISO-8859-1?B?QW1pdCBMYW5nb3Rl?=" <amitlangote09@gmail.com>
Subject: Re: BUG #19621: Unexpected results of JSON_VALUE with DEFAULT ON
 EMPTY
Mime-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: base64
Date: Tue, 18 Aug 2026 10:06:15 +0800
X-Priority: 3
Message-ID: <tencent_3BDE4F7404C05A9C7D71602A@qq.com>
X-QQ-MIME: TCMime 1.0 by Tencent
X-Mailer: QQMail 2.x
X-QQ-Mailer: QQMail 2.x
References: <19621-0a480d2dc74e6bd5@postgresql.org>
	<CAB8bMisC9N06fQbJ0ie02Qzv5mO4K8rA=_Gb0UFzMZLCwft4QQ@mail.gmail.com>
In-Reply-To: 
 <CAB8bMisC9N06fQbJ0ie02Qzv5mO4K8rA=_Gb0UFzMZLCwft4QQ@mail.gmail.com>
X-QQ-ReplyHash: 3160604418
X-BIZMAIL-ID: 8230075168989051882
X-Address-Ticket: 
 version=;type=;ticket_id=;id_list=;display_name=;session_id=;
X-QQ-SENDSIZE: 520
Received: from qq.com (unknown [127.0.0.1])
	by smtp.qq.com (ESMTP) with SMTP
	id ; Tue, 18 Aug 2026 10:06:16 +0800 (CST)
Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz4b-0
X-QQ-XMAILINFO: MMwjR1C73eIsC36B8s5M2h5uR9rvDySh3M2Qp2bGoaNndCGT0ha2vWlU
	lI2IXVZULDvq1Y9Ty8fn+dUGfsX96TI/SFrsDu17NXun0EfMI043WVZ3FxYoTgpbdBpNXue
	gF6HPaAKm6lFHYkhjRp9rkJWf2lALrafkD/+7pyk7u0F4Q4ug9DRbRrdUP3z/hHdUph+mOJ
	KUVyZTLW+Iab5lSE//xmzKbIFmkX2Ef0KQdlV1hzfhRN6kRZ/q8SEXRBUAD0LfE1P6kqpzq
	RbO9Zz7bVnvcnLaAq5yqoANVBJk10hXOVMrr7Dtpec0SQK8HWzucQgPZ4wZAESLb+Il1vT6
	EisdNX4VPz5QB624ZubB0RVXFpufD75S3/WBlQ5R5uS29IzZpdlAZ0yyjXEVUZpaFr20iaZ
	uKKl63EZv630n/ScSP78xiF2ASThiZ5vvgT/x9QNqQDZz9UbuhwU/bAgxpg/5QC7wDCxVn/
	WtDYfuzZmaLP4hmSA8Mf5aYlD8hUNAJtzGWBAr0GOCipYuGGURFayNZl1IzCpgejzRROpIM
	CqUqMIAVjxx362dZc20sJQfngypcZ3tH2Gj2rzc4D334E+PZaaSGhZAGQyjCgnsyaKnFGxa
	RjUhQUoUz4YXzaNSW3auVzFZn8QBZGSl+RIp+icwDqK+TeupIKVT0dhEaj+C0+p97PVg7LX
	Vm6Cub9TxDqqXMrjEX2I4bGGOY3cj0FpxlF0hwwBzpbVGBzh8a8LLcu5fk9IuMYFEXEN58w
	lIZIXT7AlKrR6AuR/xFW8lpQEBaSPVnQ2LaFy2mHbt0tTn82febeVXSuEwYwQHKlGYEwn+a
	RKIMs5nWj9JGwCOWmgBEQt3WNXgaRuoSP5BTeGqrjjqtLqMm2n767DlJxYLQ3kfC7PZs7qF
	lNuJEfuK31oLRc9waPWM/cHKA/3xTUPjE3W07uCM/ZOk6ENBYRMh0D+CicYm6nymnIbN1Sc
	/j2VSny9rmSSBWvCVQh3jkL1Wq42DYE8G9DR3+xUFnKIyrO+5G4DZFck2OyfeuLp4F2ryU4
	kWQkgmR9i0XVvBIsQbNujUKfICPmO0Dph7i771mR8UpQPwFMFvDTwzYOTI6M7RPXEQ5+khZ
	IITCORZvGOE
X-QQ-XMRINFO: OWPUhxQsoeAVwkVaQIEGSKwwgKCxK/fD5g==
X-QQ-RECHKSPAM: 0
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/tencent_3BDE4F7404C05A9C7D71602A%40qq.com>
Precedence: bulk

SGkgZXZlcnlvbmUsDQoNCkkgaGF2ZSBhbm90aGVyIHF1ZXN0aW9uIHJlbGF0ZWQgdG8gSlNP
TiBmdW5jdGlvbnMuIEFsdGhvdWdoIGl0IGlzIGEgZGlmZmVyZW50IGlzc3VlLCBJIHdvbmRl
ciB3aGV0aGVyIGl0IHdvdWxkIG1ha2Ugc2Vuc2UgdG8gaGFuZGxlIGJvdGggY2FzZXMgaW4g
dGhlIHNhbWUgcGF0Y2guDQoNCkkgdGVzdGVkIHRoZSBjdXJyZW50IHBhdGNoLCBidXQgaXQg
ZG9lcyBub3Qgc2VlbSB0byBhZGRyZXNzIHRoZSBwcm9ibGVtIEkgcmVwb3J0ZWQgaGVyZToN
Cg0KYGBgDQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkLzE5NjI1LTY4
M2I0OThjOTIwODdiYzglNDBwb3N0Z3Jlc3FsLm9yZw0KYGBgDQoNCi0tDQpSZWdhcmRzLA0K
TWFuIFplbmc=