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 1wLAYt-001a4z-38 for pgsql-committers@arkaria.postgresql.org; Fri, 08 May 2026 02:03:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wLAYs-007Cxl-31 for pgsql-committers@arkaria.postgresql.org; Fri, 08 May 2026 02:03:30 +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 1wLAVv-007ByG-1U 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 magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wLAVs-000000018CR-3ONs for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:27 +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=wtXjYl0cMbaPxkwNgL68krHImVW3HEp3LSzbC740wP0=; b=rPW+oYo0p31igcurKdaBk/q7Pq aj7J8CjND/7gP9YiY7ucBkl3lJMTN0N3riJ5ckdSv8dBcBetgB9W3vj/99IND1+RZOh9MEra9OwBK VDu/VH2JDWng7HG0gah8ZNeOZ6dFBBzVPn3vISpht14mIcBPWHE9YHl/WSNgw0kz7c/OONvxy1xVc KmeXiqktytHD0bZB+UgTQeTX1BEUeWAqoRh/zxUCqv6iX6TyfCvxTp+i4uPwdfRlq943JCQta20Lw 6h7ig9DRtHaUmYRk0+I2fhPQ0VKPU6MXEVZFJ7HRG5gOSo7NkuGLcS1yOqJwI5CCHej62LPeRT6nX 6liN4NBA==; 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-0027ei-1p 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-000n9h-1t for pgsql-committers@lists.postgresql.org; Fri, 08 May 2026 02:00:22 +0000 Content-Type: multipart/mixed; boundary="===============7790918921651945469==" 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 --===============7790918921651945469== 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 b3VnaDogMTgKCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMTEzMmFmMjJjZjdkMzFjMjI0 ZDM5YmNmMmI1NTI4N2Y0MmI5NDVkYQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICB8IDYyICsrKysrKysr KysrKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY29sbGF0ZS5pY3Uu dXRmOC5vdXQgfCA1MSArKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv Y29sbGF0ZS5pY3UudXRmOC5zcWwgICAgICB8IDE1ICsrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCAx MjQgaW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCg== --===============7790918921651945469==--