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 1wLAVy-001a34-17 for pgsql-committers@arkaria.postgresql.org; Fri, 08 May 2026 02:00:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wLAVv-007ByK-1R for pgsql-committers@arkaria.postgresql.org; Fri, 08 May 2026 02:00:27 +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 1wLAVv-007ByB-0G for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wLAVr-00000000jTw-2ee3 for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:26 +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=L2SbcSqFa27Au1XwScImdT7jsUHx/84+Y5BdihMkrP0=; b=lewrZB08IaZzKU+4nuztCN480o MZj/66J/cFyQuOoo+QtvM2XksuKBd5GvS97rLPwR6EzvcdFfZPBF98F94jRTJxDcTrCvSkBtXV2gz FWh5eGuTg/AbKE6+H66J9fW4OjdR3469ehYHPT+j/eeRg+rAdbSbP47M36RXaz4wp6EHLMXI4FAlG adi/XK44iyjK03lMLOAjOzOsrY6d1u4IRCvpqiS5c4c/IQ3xL4mcC8xYZdoWkWis5E8fh+Meul/iM GSNxvsepiQYddOigniVqF7yoS492y1tYpy5p292Lu4PZkqZcFg/5ZmvjLBw2FBK1jWuFjnK8DJMmR yNagjSww==; 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 1wLAVq-0027eh-1q for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:23 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wLAVq-000n9f-1m for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:22 +0000 Content-Type: multipart/mixed; boundary="===============1827591076219625096==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix HAVING-to-WHERE pushdown for simple-CASE form X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 08 May 2026 02:00:22 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1827591076219625096== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IEhBVklORy10by1XSEVSRSBwdXNoZG93biBmb3Igc2ltcGxlLUNBU0UgZm9ybQoKQ29tbWl0 IGY3NjY4NmNlNyBhZGRlZCBhIHdhbGtlciB0aGF0IGRldGVjdHMgd2hlbiBhIEhBVklORyBjbGF1 c2UgdXNlcwphIGNvbGxhdGlvbiB0aGF0IGNvbmZsaWN0cyB3aXRoIHRoZSBHUk9VUCBCWSdzIG5v bmRldGVybWluaXN0aWMKY29sbGF0aW9uLCBrZWVwaW5nIHN1Y2ggY2xhdXNlcyBpbiBIQVZJTkcu ICBUaGUgd2Fsa2VyIHVzZXMKZXhwcklucHV0Q29sbGF0aW9uKCkgdG8gaWRlbnRpZnkgZWFjaCBh bmNlc3RvcidzIGNvbXBhcmlzb24gY29sbGF0aW9uLApidXQgbWlzc2VkIHRoZSBzaW1wbGUtQ0FT RSBjYXNlOiBwYXJzZSBhbmFseXNpcyBidWlsZHMgZWFjaCBXSEVOIGFzCk9wRXhwcihDYXNlVGVz dEV4cHIgb3AgdmFsKSwgd2hlcmUgQ2FzZVRlc3RFeHByIGlzIGEgcGxhY2Vob2xkZXIgZm9yCnRo ZSBhcmcsIHdoaWxlIHRoZSBhY3R1YWwgYXJnIGV4cHJlc3Npb24gc2l0cyBhdCBjZXhwci0+YXJn LCBvdXRzaWRlCnRoZSBPcEV4cHIgdGhhdCBjYXJyaWVzIHRoZSBjb21wYXJpc29uJ3MgaW5wdXRj b2xsaWQuICBBIEdST1VQIFZhciBhdApjZXhwci0+YXJnIHdhcyB0aGVyZWZvcmUgdmlzaXRlZCB3 aXRoIHRoZSBXSEVOJ3MgaW5wdXRjb2xsaWQgYWJzZW50CmZyb20gdGhlIGFuY2VzdG9yIHN0YWNr LCB0aGUgY29uZmxpY3Qgd2VudCB1bmRldGVjdGVkLCBhbmQgdGhlIGNsYXVzZQp3YXMgd3Jvbmds eSBwdXNoZWQgdG8gV0hFUkUuCgpGaXggYnkgaGFuZGxpbmcgc2ltcGxlIENBU0UgZXhwbGljaXRs eTogYmVmb3JlIHdhbGtpbmcgY2V4cHItPmFyZywKcHVzaCBldmVyeSBXSEVOJ3MgaW5wdXRjb2xs aWQgb250byB0aGUgYW5jZXN0b3Igc3RhY2sgc28gYSBHUk9VUCBWYXIKYXQgdGhlIGFyZyBpcyBj aGVja2VkIGFnYWluc3QgdGhlIHNhbWUgY29sbGF0aW9ucyB0aGUgV0hFTiBjb21wYXJpc29ucwp3 b3VsZCBhcHBseS4gIFRoZW4gd2FsayB0aGUgV0hFTiBib2RpZXMgYW5kIGRlZnJlc3VsdCB1bmRl ciB0aGUKdW5jaGFuZ2VkIHN0YWNrLCB3aGVyZSB0aGVpciBvd24gY29sbGF0aW9uIGNvbnRleHRz IGFyZSBwaWNrZWQgdXAgYnkKdGhlIGRlZmF1bHQgcGF0aC4KCkJhY2stcGF0Y2ggdG8gdjE4IG9u bHk7IHRoaXMgZml4IGV4dGVuZHMgdGhlIHdhbGtlciBhZGRlZCBieSBjb21taXQKZjc2Njg2Y2U3 IGFuZCBpbmhlcml0cyBpdHMgZGVwZW5kZW5jeSBvbiB0aGUgdjE4IFJURV9HUk9VUCBtZWNoYW5p c20uCgpBdXRob3I6IFNBVFlBTkFSQVlBTkEgTkFSTEFQVVJBTSA8c2F0eWFuYXJsYXB1cmFtQGdt YWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFJpY2hhcmQgR3VvIDxndW9mZW5nbGludXhAZ21haWwuY29t PgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSGcrUURjcVBkZD0yVjBQUV9vTllq NTBPVWVxU3F6bnFGYVl0UDNSZG9rTEJEWEJxd0BtYWlsLmdtYWlsLmNvbQpCYWNrcGF0Y2gtdGhy b3VnaDogMTgKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9n aXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iYTgyZGU0OGU2MmM2MzNmNWFkNWU5ZGM5 ZTZmMmYzZTg0NTVhMDlmCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2Vu ZC9vcHRpbWl6ZXIvcGxhbi9wbGFubmVyLmMgICAgICAgICAgIHwgNjIgKysrKysrKysrKysrKysr KysrKysrKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jb2xsYXRlLmljdS51dGY4Lm91 dCB8IDUxICsrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jb2xsYXRl LmljdS51dGY4LnNxbCAgICAgIHwgMTUgKysrKysrKwozIGZpbGVzIGNoYW5nZWQsIDEyNCBpbnNl cnRpb25zKCspLCA0IGRlbGV0aW9ucygtKQoK --===============1827591076219625096==--