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 ) id 1wyLV8-003KE5-0N for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Aug 2026 03:37:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wyLV6-000k1H-2j for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Aug 2026 03:37:32 +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 ) id 1wyLV6-000k17-06 for pgsql-bugs@lists.postgresql.org; Mon, 24 Aug 2026 03:37:32 +0000 Received: from smtpbgbr1.qq.com ([54.207.19.206]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wyLUw-000000027fP-3h6c for pgsql-bugs@lists.postgresql.org; Mon, 24 Aug 2026 03:37:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1787542634; bh=5ueemWoNos+HdPBrU/9pKQGZKTbObHczVYnBL1AXyfY=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=mXWcwv/4gxefuyeZ14N4XshihOZpu2RdW7vU+7UqN8Q6dvZ3yshGmoroAIGkViuhL tjzUJxQ6+bnAZlKLTq5RXq5bkVIn4Yg3juzF9VAjt2k2RPHx7+EuRKFx4CzuWusuxM NATi2/RIomEWPp7ZvyvUPq0YjVKqo8EVX75MJ9uw= EX-QQ-RecipientCnt: 2 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: D4aqtcRDiqS+iirjp6p4NsUYQGfoj9ocZz3QtOrWwbI= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: idpFSafYa6PQy7KKNnwRfq6Yt8IWnHmre1fQSCN5xvU= X-Originating-IP: 112.10.23.189 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1787542633t224d8140 From: "=?gb18030?B?emVuZ21hbg==?=" To: "=?gb18030?B?1PjC+g==?=" , "=?gb18030?B?cGdzcWwtYnVncw==?=" Subject: Re:BUG #19625: SQL/JSON boolean DEFAULT expression silently replaced with 'false' Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_6A8BBC69_4D648420_2FA7E931" Content-Transfer-Encoding: 8Bit Date: Mon, 24 Aug 2026 11:37:13 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x References: <19625-683b498c92087bc8@postgresql.org> In-Reply-To: X-QQ-ReplyHash: 39111967 X-BIZMAIL-ID: 1148475231773057911 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 ; Mon, 24 Aug 2026 11:37:14 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz3b-0 X-QQ-XMAILINFO: NdFV+OPEmRr+MUvw3cxcqRt1/mDQzEG8OBljrPykG9M2Lk6Es3DiEihD rUZ12r5LRmHhxreSjn9BqW5Ij9t2NYGITE9mJVL35oSUaFzlmMYw/Lq+xLXEptAX5VCxiao OJuGxsE2UfgdxeWKQQ0VHw2jqtIP0b4oYQcGlzOKoxJ1PhkLHMuP6vcoPGYCwzX5Kg4atAm uFx0l2gzOpkp/PZNiBHe09LlLQYvfyA9KGUhpNZmtcTz3hAllpUNtIPnzslAvljmkOjwKi4 dRRBnnOJuJjhXhhM10VWf0A6Gz9iK1ta6zRR4RfBTG6mP/w/7lmg+VgvSSHU3cNUvhsj1J1 94mUzqQSjVTFS7ZUFO5WwP5JluXUO/Rm1eK6prqsj7UfGQED9l8QPSrosnIUS0p3Qrc2Ddi gHVjRnraXyGhzXCVu7oaK/TJwuFkPzrxGvoPPjkdN7PPtUtsqhcuEC8SJh/kPAS599+t/gF ehhxz0UQswlNzj8SOcr99BY8eNNIXDO+oGSMT3ySUw1ebtUPNITY5MiVRx1HWWbzvW/VkKB U2K6RraYI14yNKmbL0tAHYUFscJyyKT3sR+OlJE2c0t+UBIylGwZ1hIohzjWoLaIX+oVP10 8K19STOF0dkLgI9FIhWoHDoBIMwyaFaXimSyzRW/hMfX04Xzg8A2y26Ec+rI3MBbOYbrY9n 3sgps/Sg/RtsLrNm7amp+WdDAPLughPobHqHyzW1Rq0Y+jyRrlqEZxKMk0ipflH0yvHpgc7 l87LWT8Glosg3jT3aLztuaqvr3HkVJCR/JsnSqulLrb+y2KlL2PIdSIRZ41houaYusYyVdH Xbk54mGD2yTLXgkneMcyaYHexsN0jQ/CyVoA7n/N4OVnibKSI2Vk3Zp0MdJNeD+/aEkB1bZ OrlqG0T/C0qHMLM4oBU33dHKIMVnITe/5jpF53BBcxd3gEJbISFodk74QK7DUSX3KvBpU9/ dREse02/cYL8K1eSLF/8MMWqn9xINOvdxk8CU0AqOejn06obyWH0kO6FAuw6HVbm4yaoFWS vslQDwdnQLUXMXz3thx6utPc8nC1Y= X-QQ-XMRINFO: NS+P29fieYNwqS3WCnRCOn9D1NpZuCnCRA== X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_6A8BBC69_4D648420_2FA7E931 Content-Type: text/plain; charset="gb18030" Content-Transfer-Encoding: base64 QWRkZWQgcmVncmVzc2lvbiB0ZXN0cyBhbmQgcmViYXNlZC4NCg0KLS0NClJlZ2FyZHMsDQpN YW4gWmVuZw== ------=_NextPart_6A8BBC69_4D648420_2FA7E931 Content-Type: application/octet-stream; charset="gb18030"; name="0002-json-bool-default-fix.patch" Content-Disposition: attachment; filename="0002-json-bool-default-fix.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9leHByLmMgYi9zcmMvYmFj a2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jCmluZGV4IDMwYzg4OWY1MDVmLi4xNzViM2QzZWU2 OSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYworKysgYi9z cmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jCkBAIC00OTU2LDIwICs0OTU2LDE3IEBA IHRyYW5zZm9ybUpzb25CZWhhdmlvcihQYXJzZVN0YXRlICpwc3RhdGUsIEpzb25FeHByICpq c2V4cHIsCiAJCQljb2VyY2VfYXRfcnVudGltZSA9IHRydWU7CiAKIAkJCS8qCi0JCQkgKiBq c29uX3BvcHVsYXRlX3R5cGUoKSBleHBlY3RzIHRvIGJlIHBhc3NlZCBhIGpzb25iIHZhbHVl LCBzbyBnaW4KLQkJCSAqIHVwIGEgQ29uc3QgY29udGFpbmluZyB0aGUgYXBwcm9wcmlhdGUg Ym9vbGVhbiB2YWx1ZSByZXByZXNlbnRlZAotCQkJICogYXMganNvbmIsIGRpc2NhcmRpbmcg dGhlIG9yaWdpbmFsIENvbnN0IGNvbnRhaW5pbmcgYSBwbGFpbgotCQkJICogYm9vbGVhbi4K KwkJCSAqIGpzb25fcG9wdWxhdGVfdHlwZSgpIG9ubHkgdGFrZXMgYSBqc29uYiB2YWx1ZSwg c28gY29udmVydCBhCisJCQkgKiBib29sZWFuIHRvIGpzb25iIGJ5IGNhbGxpbmcgdG9fanNv bmIoKSBvbiBpdC4gIFRoYXQgd2F5IGFueQorCQkJICogYm9vbGVhbi12YWx1ZWQgZXhwcmVz c2lvbiAtLSB3aGV0aGVyIGEgY2FubmVkIFRSVUUvRkFMU0UKKwkJCSAqIGNvbnN0YW50IG9y IGEgdXNlci1zdXBwbGllZCBERUZBVUxUIGV4cHJlc3Npb24gLS0gaXMgY29udmVydGVkCisJ CQkgKiBhY2NvcmRpbmcgdG8gdGhlIHZhbHVlIGl0IGFjdHVhbGx5IGV2YWx1YXRlcyB0by4K IAkJCSAqLwogCQkJaWYgKGV4cHJUeXBlKGV4cHIpID09IEJPT0xPSUQpCi0JCQl7Ci0JCQkJ Y2hhcgkgICAqdmFsID0gYnR5cGUgPT0gSlNPTl9CRUhBVklPUl9UUlVFID8gInRydWUiIDog ImZhbHNlIjsKLQotCQkJCWV4cHIgPSAoTm9kZSAqKSBtYWtlQ29uc3QoSlNPTkJPSUQsIC0x LCBJbnZhbGlkT2lkLCAtMSwKLQkJCQkJCQkJCQkgIERpcmVjdEZ1bmN0aW9uQ2FsbDEoanNv bmJfaW4sCi0JCQkJCQkJCQkJCQkJCQkgIENTdHJpbmdHZXREYXR1bSh2YWwpKSwKLQkJCQkJ CQkJCQkgIGZhbHNlLCBmYWxzZSk7Ci0JCQl9CisJCQkJZXhwciA9IChOb2RlICopIG1ha2VG dW5jRXhwcihGX1RPX0pTT05CLCBKU09OQk9JRCwKKwkJCQkJCQkJCQkJIGxpc3RfbWFrZTEo ZXhwciksCisJCQkJCQkJCQkJCSBJbnZhbGlkT2lkLCBJbnZhbGlkT2lkLAorCQkJCQkJCQkJ CQkgQ09FUkNFX0VYUExJQ0lUX0NBTEwpOwogCQl9CiAJCWVsc2UKIAkJewpkaWZmIC0tZ2l0 IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zcWxqc29uX3F1ZXJ5ZnVuY3Mub3V0IGIv c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zcWxqc29uX3F1ZXJ5ZnVuY3Mub3V0CmluZGV4 IGZmNjRkY2UwYzU5Li41MGQ5ZDIzMDQyMCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9zcWxqc29uX3F1ZXJ5ZnVuY3Mub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvc3FsanNvbl9xdWVyeWZ1bmNzLm91dApAQCAtNTU0LDYgKzU1NCwyNSBA QCBzZWxlY3QganNvbl92YWx1ZSgneyJhIjogMS4yMzR9JywgJyQuYScgcmV0dXJuaW5nIGlu dCBlcnJvciBvbiBlcnJvcik7CiBFUlJPUjogIGludmFsaWQgaW5wdXQgc3ludGF4IGZvciB0 eXBlIGludGVnZXI6ICIxLjIzNCIKIHNlbGVjdCBqc29uX3ZhbHVlKCd7ImEiOiAiMS4yMzQi fScsICckLmEnIHJldHVybmluZyBpbnQgZXJyb3Igb24gZXJyb3IpOwogRVJST1I6ICBpbnZh bGlkIGlucHV0IHN5bnRheCBmb3IgdHlwZSBpbnRlZ2VyOiAiMS4yMzQiCistLSBUZXN0IEpT T05fVkFMVUUgREVGQVVMVCBPTiBFUlJPUiBib29sZWFuIGV4cHJlc3Npb25zCitTRUxFQ1Qg SlNPTl9WQUxVRSgneyJhIjoiYWJjIn0nLCAnc3RyaWN0ICQuYicgREVGQVVMVCBmYWxzZSBP TiBFUlJPUik7CisganNvbl92YWx1ZSAKKy0tLS0tLS0tLS0tLQorIGZhbHNlCisoMSByb3cp CisKK1NFTEVDVCBKU09OX1ZBTFVFKCd7ImEiOiJhYmMifScsICdzdHJpY3QgJC5iJyBERUZB VUxUIHRydWUgT04gRVJST1IpOworIGpzb25fdmFsdWUgCistLS0tLS0tLS0tLS0KKyB0cnVl CisoMSByb3cpCisKK1NFTEVDVCBKU09OX1ZBTFVFKCd7ImEiOiJhYmMifScsICdzdHJpY3Qg JC5iJyBERUZBVUxUICgxPTEpIE9OIEVSUk9SKTsKKyBqc29uX3ZhbHVlIAorLS0tLS0tLS0t LS0tCisgdHJ1ZQorKDEgcm93KQorCiAtLSBKU09OX1FVRVJZCiBTRUxFQ1QgSlNPTl9WQUxV RShOVUxMOjpqc29uYiwgJyQnKTsKICBqc29uX3ZhbHVlIApkaWZmIC0tZ2l0IGEvc3JjL3Rl c3QvcmVncmVzcy9zcWwvc3FsanNvbl9xdWVyeWZ1bmNzLnNxbCBiL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3NxbGpzb25fcXVlcnlmdW5jcy5zcWwKaW5kZXggYTY5ZWYyNTNmNjYuLmQ5YjZm MmJjY2EyIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9zcWxqc29uX3F1ZXJ5 ZnVuY3Muc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NxbGpzb25fcXVlcnlmdW5j cy5zcWwKQEAgLTE0OSw2ICsxNDksMTEgQEAgU0VMRUNUIEpTT05fVkFMVUUoanNvbmIgJ251 bGwnLCAnJHRzJyBQQVNTSU5HIHRpbWVzdGFtcHR6ICcyMDE4LTAyLTIxIDEyOjM0OjU2ICsK IHNlbGVjdCBqc29uX3ZhbHVlKCd7ImEiOiAxLjIzNH0nLCAnJC5hJyByZXR1cm5pbmcgaW50 IGVycm9yIG9uIGVycm9yKTsKIHNlbGVjdCBqc29uX3ZhbHVlKCd7ImEiOiAiMS4yMzQifScs ICckLmEnIHJldHVybmluZyBpbnQgZXJyb3Igb24gZXJyb3IpOwogCistLSBUZXN0IEpTT05f VkFMVUUgREVGQVVMVCBPTiBFUlJPUiBib29sZWFuIGV4cHJlc3Npb25zCitTRUxFQ1QgSlNP Tl9WQUxVRSgneyJhIjoiYWJjIn0nLCAnc3RyaWN0ICQuYicgREVGQVVMVCBmYWxzZSBPTiBF UlJPUik7CitTRUxFQ1QgSlNPTl9WQUxVRSgneyJhIjoiYWJjIn0nLCAnc3RyaWN0ICQuYicg REVGQVVMVCB0cnVlIE9OIEVSUk9SKTsKK1NFTEVDVCBKU09OX1ZBTFVFKCd7ImEiOiJhYmMi fScsICdzdHJpY3QgJC5iJyBERUZBVUxUICgxPTEpIE9OIEVSUk9SKTsKKwogLS0gSlNPTl9R VUVSWQogCiBTRUxFQ1QgSlNPTl9WQUxVRShOVUxMOjpqc29uYiwgJyQnKTsK ------=_NextPart_6A8BBC69_4D648420_2FA7E931--