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 1wIdUl-008JKM-17 for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 02:20:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIdUk-009bjf-1L for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 02:20:46 +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-009anA-2b 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-00000004ASJ-2ZZ3 for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:42 +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=XztEc54VGvE95jgRlym2baOV+vy+887mvmA8hlBJ2fk=; b=s6oBv00t9vMtk5i3HjnX+GEXLl RsACNYNiQzldu9gUNDJ2M7FrnE4kCeCsltwHKPq51ceQVemgZjgy/GRTe8KDJfbYswyFaH4Zgp8KZ 4Dtr0zutP86cD5s1QXlZ/jOZQWMw/UlDEJw9Ht+ZdM0+7vtybOR8AJeZpIqNiZ48ekrZrnp5bgPuO f0JVzp5228dIelX3hHexptuNwd27C/Oerxi1X1SF5utDwLVzOXeLHX1EluJ0eWp7b8wccs2Ci7wOl eEEdocMQE1tqs2ZM6oDwavrNE41U9QooOZ1UYbCu38Dwd1usctjZopKuTJFKw4Of1/KVRhip648Em bmZJo55Q==; 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-00Ay2u-2M 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-003XDJ-1S for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 02:17:38 +0000 Content-Type: multipart/mixed; boundary="===============2256800019079168709==" 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 --===============2256800019079168709== 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 a3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZjc2Njg2Y2U3Zjc3ZTU3 NDU2YWQzNjQ0ZjJmNmI0MjgwMTgxZDFmNAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICB8IDE4OCArKysr KysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY29sbGF0ZS5pY3Uu dXRmOC5vdXQgfCAyMTMgKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNz L3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAgICAgIHwgIDY2ICsrKysrKysrCnNyYy90b29scy9w Z2luZGVudC90eXBlZGVmcy5saXN0ICAgICAgICAgICAgICAgfCAgIDEgKwo0IGZpbGVzIGNoYW5n ZWQsIDQ2OCBpbnNlcnRpb25zKCspCgo= --===============2256800019079168709==--