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.98.2) (envelope-from ) id 1xRWFG-000000012wB-0onz for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 14:57:47 +0000 Received: from localhost ([127.0.0.1]:44824 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xRWFE-00000001cAu-0z0G for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 14:57:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:46954) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRW8I-000000015yF-0BFT for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 14:50:34 +0000 Received: from smtpbgsg2.qq.com ([54.254.200.128]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRW88-00000000Zoa-0vZU for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 14:50:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1794495014; bh=clhhxRQ1CWq36QCFOHSdRSTPzJKc0YPYJxjO5OE2YDY=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=CNH+x1mNwVXg3CvWQ2UOP15of3fsvMkkQ/dSFXAAL4rz2fienFefg9n6oC8P05lBG 6yAbd6VPbokJqdD5m9HizsvpJjclY5sfCK4jodpOK5GerhEVVSBOW15M8zA4elDK05 evgMsLhsHUeI0NpQfSbUnS41xFbG3vazFF2BCpus= EX-QQ-RecipientCnt: 3 X-QQ-GoodBg: 2 X-QQ-SSF: B0400000000000F0 X-QQ-FEAT: 2gkBqIy9/P+9LEpoiqged25j4bBAfGwVH1VmsChwZeo= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: uK0/l2M0s2MjCcng76ea9r9QYVL2pnmVJcFPPC+85Bs= X-Originating-IP: 112.10.42.253 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1794495010t127c6cd8 From: "=?ISO-8859-1?B?emVuZ21hbg==?=" To: "=?ISO-8859-1?B?QW1pdCBMYW5nb3Rl?=" , "=?ISO-8859-1?B?UVEgTWFpbA==?=" <781408517@qq.com> Cc: "=?ISO-8859-1?B?cGdzcWwtYnVncw==?=" Subject: Re: BUG #19625: SQL/JSON boolean DEFAULT expression silently replaced with 'false' Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 Date: Thu, 12 Nov 2026 22:50:10 +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: 3436642208 X-BIZMAIL-ID: 11305206570560181301 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 ; Thu, 12 Nov 2026 22:50:11 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz4b-0 X-QQ-XMAILINFO: Mf2p425zol0GCIT47O9DNn64dlYAgirrRnkxUfxf05NGJH+NZGxD1bFk Mn9JTssPF1j1oikut2bZWP2hqxpBHs+H+5d2Cli15we2uOe6cf+EyBEl8wUf0cfSLkehLJf sqQ1Y7G+0T0NShrgJHhnnh1sydgaZ0BW4eJQDCGFdS8qMobs0twyte1N1Y99cpnwOFkwCVd SYINv7EklkVGKKvtkcyQWpjB8X/W1Mex8SQap9cA9RIklmTT2FL7K+UrR3CUqwMqt/yd/dc RpDCB3vq3kd4Q31ibcW8ZucsZ6IM6e+l4Scu6s4PDrKVKpr1d5ZAuX665Mk95lu8WRWU7Rq alYbgdOEu9/RZUj+zjyv96ZJP18v38NwQh8mvRTcrZsQ/i04+ORh2GuMLNLQtjJzRGUNmqc qxTT+s8POwNCbbl67jZLEZKOL6Pjppz0yKdQQkd9LkEwwR5ELJ5GH0gu0t0h4YrA0O5GO6R ajN4swKrjGZw8tWI1UXiUlfEJHSn1bZcF/Ss3u3+FhVl38gXLaffF8U4mFNTLL+XrDGXUGO x2QkVGzJ37rrhJ0qSa6yRw89yYgEnqrel+rgunagj8JRCCCgiiOaxCzBQIJpLqMFtH2FlTF 9HTUXps3RT96XFvdOqCKl2SpOQwaf2v++YvRvCrJl0uta4PfXbYI9QWcKBcClzQ8a/ad7Is HXSFmXuquQG5UREy2doOojV/t1zqb1g0SSKzsx6jZbzbXtPf0+ypsOMOJWuRQOH0YL5gcdM et07qhznsy50gklK0jev/pIjbqh0vkIIx+hAIrQvc+c4Lc1HeUlehH+wpczCB8ImntHufsP 6EcW0KRGvCFhWEu6w1f8g3arNevKbqdq7aA9bPacJYsQ4UAVajlDBEAeIArZcwSk9Jdy536 5rm8VWUKmc9ZFWzELXolft7TE1zhfU0dkCpJeUFoNpjnEz8KFnbcKXjO46FDNCFuCdqtKVR EJcjKOxVQjpczv8yCwaPZ4FyEMFl9QXP4ChGtlykrzaD4yqTiz4G/IhukBJseeKC03qma0n wVpeWmGYNaP9JvOUu7IG+hPYvUMGFxIc+OlaOtWDbjq1JQOuxlTE5wONRnrzXnEOhVvwUbt A== X-QQ-XMRINFO: OD9hHCdaPRBwH5bRRRw8tsiH4UAatJqXfg== X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBUaGFua3MgZm9yIHRoZSByZXBvcnQgYW5kIHRoZSBwYXRjaC4NCj4gDQo+IEF0dGFjaGVk IGlzIHYyLCB3aGljaCBJIGludGVuZCB0byBjb21taXQgYW5kIGJhY2stcGF0Y2ggdG8gdjE3 LiBUaGUNCj4gbWFpbiBjaGFuZ2VzIGZyb20gdGhlIHBhdGNoIHBvc3RlZCBvbiBBdWcgMjQg YXJlOg0KPiANCj4gKiBJIGtlcHQgdGhlIGV4aXN0aW5nIGpzb25iIENvbnN0IGZvciBKU09O X0JFSEFWSU9SX1RSVUUgYW5kDQo+IEpTT05fQkVIQVZJT1JfRkFMU0UsIHNvIG9ubHkgYSBi b29sZWFuLXZhbHVlZCBERUZBVUxUIGV4cHJlc3Npb24gZ2V0cw0KPiB3cmFwcGVkIGluIGEg dG9fanNvbmIoKSBGdW5jRXhwci4gIFRoYXQgd2F5IHRoZSBub2RlIHRyZWUgZm9yIFRSVUUg Lw0KPiBGQUxTRSBPTiBFUlJPUiBpcyB1bmNoYW5nZWQgaW4gdGhlIGJhY2sgYnJhbmNoZXMu DQo+IA0KPiAqIE1vcmUgdGVzdHMsIGluY2x1ZGluZyB0aGUgY2FzZXMgYXNrZWQgZm9yIGlu IHRoZSByZXZpZXcgcG9zdGVkIG9uDQo+IE9jdCAxMiAoTlVMTDo6Ym9vbGVhbiwgSlNPTl9R VUVSWSB3aXRoIE9OIEVNUFRZLCBhbmQgYSBub24tY29uc3RhbnQNCj4gZGVmYXVsdCkuDQo+ IA0KPiAqIEFkZGVkIGNvbW1pdCBtZXNzYWdlIG5vdGluZyB0aGF0IHZpZXdzIGFuZCBydWxl cyBjcmVhdGVkIGJlZm9yZSB0aGUNCj4gZml4IHN0aWxsIGNvbnRhaW4gdGhlIHdyb25nICdm YWxzZSc6Ompzb25iDQo+IA0KPiBCdWcgIzE5ODIyIHJlcG9ydHMgdGhlIHNhbWUgcHJvYmxl bSBhbmQgdGhlIGNhc2VzIHNob3duIHRoZXJlIGFyZQ0KPiBmaXhlZCBieSB0aGlzIHBhdGNo IGFzIHdlbGwsIHNvIHRoZSBjb21taXQgbWVzc2FnZSBtZW50aW9ucyB0aGF0IGJ1ZyAjDQo+ IHRvby4NCg0KSGkgQW1pdCwNCg0KVGhhbmtzIGZvciByZXZpZXdpbmcgbXkgb3JpZ2luYWwg cGF0Y2ggYW5kIGhlbHBpbmcgaW1wcm92ZSB0aGUgZml4LiBUaGlzIGxvb2tzIG11Y2ggYmV0 dGVyIHRoYW4gbXkgcHJldmlvdXMgdmVyc2lvbiENCkhvd2V2ZXIsIHdoaWxlIHRlc3Rpbmcg aXQsIEkgbm90aWNlZCBhIGNvdXBsZSBvZiBpc3N1ZXMgaW4gdGhlIGZvbGxvd2luZyBzY2Vu YXJpb3M6DQoNCmBgYHNxbA0KQ1JFQVRFIFRBQkxFIGppZHgoaiBqc29uYik7DQpDUkVBVEUg SU5ERVggT04gamlkeA0KICAoKEpTT05fVkFMVUUoaiwgJyQueCcgREVGQVVMVCB0cnVlIE9O IEVNUFRZKSkpOw0KDQpDUkVBVEUgVEFCTEUgamdlbigNCiAgaiBqc29uYiwNCiAgeCB0ZXh0 IEdFTkVSQVRFRCBBTFdBWVMgQVMNCiAgICAoSlNPTl9WQUxVRShqLCAnJC54JyBERUZBVUxU IHRydWUgT04gRU1QVFkpKSBTVE9SRUQNCik7DQpgYGANCg0KYGBgc3FsDQpwb3N0Z3Jlcz0j IENSRUFURSBUQUJMRSBqaWR4KGoganNvbmIpOw0KQ1JFQVRFIFRBQkxFDQpwb3N0Z3Jlcz0j IENSRUFURSBJTkRFWCBPTiBqaWR4DQogICgoSlNPTl9WQUxVRShqLCAnJC54JyBERUZBVUxU IHRydWUgT04gRU1QVFkpKSk7DQoyMDI2LTExLTEyIDIyOjI2OjI3LjEyOSBDU1QgWzIwNjEz NTJdIEVSUk9SOiAgZnVuY3Rpb25zIGluIGluZGV4IGV4cHJlc3Npb24gbXVzdCBiZSBtYXJr ZWQgSU1NVVRBQkxFIGF0IGNoYXJhY3RlciAyNQ0KMjAyNi0xMS0xMiAyMjoyNjoyNy4xMjkg Q1NUIFsyMDYxMzUyXSBTVEFURU1FTlQ6ICBDUkVBVEUgSU5ERVggT04gamlkeA0KICAgICAg ICAgICgoSlNPTl9WQUxVRShqLCAnJC54JyBERUZBVUxUIHRydWUgT04gRU1QVFkpKSk7DQpF UlJPUjogIGZ1bmN0aW9ucyBpbiBpbmRleCBleHByZXNzaW9uIG11c3QgYmUgbWFya2VkIElN TVVUQUJMRQ0KTElORSAyOiAgICgoSlNPTl9WQUxVRShqLCAnJC54JyBERUZBVUxUIHRydWUg T04gRU1QVFkpKSk7DQogICAgICAgICAgIF4NCnBvc3RncmVzPSMgDQpwb3N0Z3Jlcz0jIA0K cG9zdGdyZXM9IyBDUkVBVEUgVEFCTEUgamdlbigNCiAgaiBqc29uYiwNCiAgeCB0ZXh0IEdF TkVSQVRFRCBBTFdBWVMgQVMNCiAgICAoSlNPTl9WQUxVRShqLCAnJC54JyBERUZBVUxUIHRy dWUgT04gRU1QVFkpKSBTVE9SRUQNCik7DQoyMDI2LTExLTEyIDIyOjI2OjMzLjE2OSBDU1Qg WzIwNjEzNTJdIEVSUk9SOiAgZ2VuZXJhdGlvbiBleHByZXNzaW9uIGlzIG5vdCBpbW11dGFi bGUNCjIwMjYtMTEtMTIgMjI6MjY6MzMuMTY5IENTVCBbMjA2MTM1Ml0gU1RBVEVNRU5UOiAg Q1JFQVRFIFRBQkxFIGpnZW4oDQogICAgICAgICAgaiBqc29uYiwNCiAgICAgICAgICB4IHRl eHQgR0VORVJBVEVEIEFMV0FZUyBBUw0KICAgICAgICAgICAgKEpTT05fVkFMVUUoaiwgJyQu eCcgREVGQVVMVCB0cnVlIE9OIEVNUFRZKSkgU1RPUkVEDQogICAgICAgICk7DQpFUlJPUjog IGdlbmVyYXRpb24gZXhwcmVzc2lvbiBpcyBub3QgaW1tdXRhYmxlDQpgYGANCg0KSSBoYXZl bid0IGNvbWUgdXAgd2l0aCBhIGdvb2Qgd2F5IHRvIGFkZHJlc3MgdGhlc2UgY2FzZXMgeWV0 LiBEbyB5b3UgaGF2ZSBhbnkgdGhvdWdodHMgb24gdGhpcz8NClRoYW5rcyBhZ2FpbiENCg0K LS0NClJlZ2FyZHMsDQpNYW4gWmVuZw==