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 1wIdRn-008JHU-2I for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 02:17:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIdRm-009amj-1p for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 02:17:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wIdRm-009amb-0W for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:42 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wIdRj-00000004ASK-2G4Z for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=5CoAX/+ClLKi13yzYH3DapqNn3JJTeITJfBhobWCR7E=; b=VWrc9N4q7HPnyYtmil66S9I8CM 2XU5gOnhEsAjHEabXvuODyO8rtzUEGIyji2O/zNuitdgAqHpsHchjJ5w5PgsAY512kgeSY/Es/TOj xuMPXF9Fp1RcTY79+wSlhAjMJVYqyMEU/JfU7OAAwgJY4Fbl/OqalPj0KbQ9UGsG6KvhoUQDSk25v cGEvi/xm9TZzqV6tqbZuvJAY1OR3MQsuJSRD9Z3zvjQqrzCLLVPvYb5hCRafBv/XoqiDwen0OMRnt g7PE5OHs6SbFDcnJlfvNfL0D9ibliY/zcVKyxyxXzITN6LxOo/eNkC99qIDgMLZIhjXPFmx7RH5zY lnXN/VgA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wIdRh-00Ay2v-2R for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:38 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIdRh-003XDL-1X for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:38 +0000 Content-Type: multipart/mixed; boundary="===============0894842208663584715==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix HAVING-to-WHERE pushdown with nondeterministic collations X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 01 May 2026 02:17:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0894842208663584715== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IEhBVklORy10by1XSEVSRSBwdXNoZG93biB3aXRoIG5vbmRldGVybWluaXN0aWMgY29sbGF0 aW9ucwoKV2hlbiBHUk9VUCBCWSB1c2VzIGEgbm9uZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb24sIHRo ZSBwbGFubmVyJ3MKb3B0aW1pemF0aW9uIG9mIG1vdmluZyBIQVZJTkcgY2xhdXNlcyB0byBXSEVS RSBjYW4gcHJvZHVjZSBpbmNvcnJlY3QKcXVlcnkgcmVzdWx0cy4gIFRoZSBIQVZJTkcgY2xhdXNl IG1heSBhcHBseSBhIHN0cmljdGVyIGNvbGxhdGlvbiB0aGF0CmRpc3Rpbmd1aXNoZXMgdmFsdWVz IHRoZSBHUk9VUCBCWSBjb25zaWRlcnMgZXF1YWwuICBQdXNoaW5nIHN1Y2ggYQpjbGF1c2UgdG8g V0hFUkUgY2F1c2VzIGl0IHRvIGZpbHRlciBpbmRpdmlkdWFsIHJvd3MgYmVmb3JlIGdyb3VwaW5n LApwb3RlbnRpYWxseSBlbGltaW5hdGluZyBncm91cCBtZW1iZXJzIGFuZCBjaGFuZ2luZyBhZ2dy ZWdhdGUgcmVzdWx0cy4KCkZpeCB0aGlzIGJ5IGRldGVjdGluZyBjb2xsYXRpb24gY29uZmxpY3Rz IGJlZm9yZSBmbGF0dGVuX2dyb3VwX2V4cHJzLAp3aGlsZSB0aGUgSEFWSU5HIGNsYXVzZSBzdGls bCBjb250YWlucyBHUk9VUCBWYXJzIChWYXJzIHJlZmVyZW5jaW5nClJURV9HUk9VUCkuICBBdCB0 aGF0IHBvaW50LCBlYWNoIEdST1VQIFZhciBkaXJlY3RseSBjYXJyaWVzIHRoZSBHUk9VUApCWSBj b2xsYXRpb24gYXMgaXRzIHZhcmNvbGxpZCwgbWFraW5nIGl0IHN0cmFpZ2h0Zm9yd2FyZCB0byBj b21wYXJlCmFnYWluc3QgdGhlIG9wZXJhdG9yJ3MgaW5wdXRjb2xsaWQuICBBIG1pc21hdGNoIHdo ZXJlIHRoZSBHUk9VUCBCWQpjb2xsYXRpb24gaXMgbm9uZGV0ZXJtaW5pc3RpYyBtZWFucyB0aGUg Y2xhdXNlIGlzIHVuc2FmZSB0byBwdXNoIGRvd24uClJvd0NvbXBhcmVFeHByIGlzIHRyZWF0ZWQg c3BlY2lhbGx5LCBzaW5jZSBpdCBjYXJyaWVzIHBlci1jb2x1bW4KaW5wdXRjb2xsaWRzW10gcmF0 aGVyIHRoYW4gYSBzaW5nbGUgaW5wdXRjb2xsaWQuCgpUaGUgY29uZmxpY3RpbmcgY2xhdXNlIGlu ZGljZXMgYXJlIHJlY29yZGVkIGluIGEgQml0bWFwc2V0IGFuZApjb25zdWx0ZWQgZHVyaW5nIHRo ZSBleGlzdGluZyBIQVZJTkctdG8tV0hFUkUgbG9vcCwgc28gdGhhdCBvbmx5CmFmZmVjdGVkIGNs YXVzZXMgYXJlIGtlcHQgaW4gSEFWSU5HOyBvdGhlciBzYWZlIGNsYXVzZXMgaW4gdGhlIHNhbWUK cXVlcnkgYXJlIHN0aWxsIHB1c2hlZC4KCkJhY2stcGF0Y2ggdG8gdjE4IG9ubHkuICBUaGUgZml4 IHJlbGllcyBvbiB0aGUgUlRFX0dST1VQIG1lY2hhbmlzbQppbnRyb2R1Y2VkIGluIHYxOCAoY29t bWl0IDI0N2RlYTg5ZiksIHdoaWNoIGlzIHdoYXQgbGV0cyB1cyBpZGVudGlmeQpncm91cGluZyBl eHByZXNzaW9ucyBhbmQgdGhlaXIgcmVzb2x2ZWQgY29sbGF0aW9ucyB2aWEgR1JPVVAgVmFycyBv bgpwcmUtZmxhdHRlbiBoYXZpbmdRdWFsLiAgUHJlLXYxOCBicmFuY2hlcyBsYWNrIHRoYXQgbWFj aGluZXJ5LCBzbyBhCmJhY2stcGF0Y2ggdGhlcmUgd291bGQgbmVlZCBhIGRpZmZlcmVudCBhcHBy b2FjaC4gIEdpdmVuIHRoZSBhYnNlbmNlCm9mIGZpZWxkIHJlcG9ydHMgb2YgdGhpcyBidWcgb24g YmFjayBicmFuY2hlcywgdGhlIHJpc2sgb2YgY2FycnlpbmcgYQpkaWZmZXJlbnQgZml4IG9uIHN0 YWJsZSBicmFuY2hlcyBpcyBub3QganVzdGlmaWVkLgoKQXV0aG9yOiBSaWNoYXJkIEd1byA8Z3Vv ZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IHdlbmh1aSBxaXUgPHFpdXdlbmh1aWZ4 QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0OERuMndX NlhNOTRHWnNveU1pSDQyPUtnTW8rV2NvYlBLdVd2R1luV2FQT1FAbWFpbC5nbWFpbC5jb20KQmFj a3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tClJFTF8xOF9TVEFCTEUKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2U4ZmQ1ZTU3 OTIyM2Y2NjkyNDVhOGY3OTYxYzcxYjk0YWZlYzIzMDcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgICAgICAgICAgfCAx ODggKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbGxh dGUuaWN1LnV0Zjgub3V0IHwgMjEzICsrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3Qv cmVncmVzcy9zcWwvY29sbGF0ZS5pY3UudXRmOC5zcWwgICAgICB8ICA2NiArKysrKysrKwpzcmMv dG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgIHwgICAxICsKNCBmaWxl cyBjaGFuZ2VkLCA0NjggaW5zZXJ0aW9ucygrKQoK --===============0894842208663584715==--