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 1x1ebs-005LFn-15 for pgsql-committers@arkaria.postgresql.org; Wed, 02 Sep 2026 06:38:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1ebq-00B4A2-38 for pgsql-committers@arkaria.postgresql.org; Wed, 02 Sep 2026 06:38:10 +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 1x1eYs-00B2n1-0g for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:06 +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 1x1eYp-00000003auZ-3sdw for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:05 +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=u+UMR8KEe0jOBx5oiM7pNWQccd7N8Va9NCuX1mCvuxY=; b=6pQf5oKBWsn7jFooGCV+/Ilqij ZOtV4L6IWtol0PQJwTcZperi/mJN61+ggYHqDWcTrAJzDTCeqq5gA48jbF92ZyFtO9kUp2RP5So8V yBYMXXXcPG8fALcTZ1UMZVE3UXtRinZeh7mBh05QloI2D2tnDsDHiB9Rl8dO8WhbQU9qflp9mv2Eu nsdZpV1Y3n65mlbMYl3V3UeoXC5RI4rmNujAUNnIRtLk1SS8BMJJ7KZwpYLmvqT6DH6Tpkpw8S3la df/zpt1KEEAU7yEgbh48CH95XLPTCWybT7bd9O1/8QfnJ362YnU04MqmPjb61ZN4rNKZPd1EaC3cX gvNLv2/Q==; 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 1x1eYp-00AuON-1b for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x1eYo-000000038vv-0VRT for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:03 +0000 Content-Type: multipart/mixed; boundary="===============7209084015212641955==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix qual pushdown past grouping through simple CASE X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 02 Sep 2026 06:35:03 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7209084015212641955== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHF1YWwgcHVzaGRvd24gcGFzdCBncm91cGluZyB0aHJvdWdoIHNpbXBsZSBDQVNFCgpDb21t aXQgNDRmYjU5ZmM2IHRhdWdodCB0aGUgZ3JvdXBpbmctY29uZmxpY3Qgd2Fsa2VyIHRvIHRyZWF0 IHRoZSBhcmcKb2YgYSBzaW1wbGUgQ0FTRSBhcyBhIGRpcmVjdCBvcGVyYW5kIG9mIGVhY2ggV0hF TiBjb21wYXJpc29uLCBidXQgaXQKb25seSBjaGVja2VkIHRoZSBjb2xsYXRpb24sIG9uIHRoZSBh c3N1bXB0aW9uIHRoYXQgdGhlIFdIRU4gb3BlcmF0b3IKaXMgYWx3YXlzIHRoZSB0eXBlLWRlZmF1 bHQgIj0iIGFuZCB0aHVzIG1hdGNoZXMgdGhlIGdyb3VwaW5nIGVxb3AuClRoYXQgYXNzdW1wdGlv biBmYWlscyBvbmNlIHRoZSBhcmcgaXMgcmVsYWJlbGVkIHRvIGFub3RoZXIgdHlwZTogdGhlCldI RU4gdGhlbiBjb21wYXJlcyB1bmRlciB0aGF0IHR5cGUncyAiPSIsIHdoaWNoIG5lZWQgbm90IGFn cmVlIHdpdGgKdGhlIGdyb3VwaW5nIGVxdWFsaXR5LiAgRm9yIGluc3RhbmNlLCB3aXRoIGEgRElT VElOQ1Qgb3ZlciBhIGNpdGV4dApjb2x1bW4sIGEgcXVhbCBzdWNoIGFzICJDQVNFIHQ6OnRleHQg V0hFTiAnQScgVEhFTiAuLi4iIHdhcyBwdXNoZWQKYmVsb3cgdGhlIFVuaXF1ZSwgYWx0aG91Z2gg dGhlIGVxdWl2YWxlbnQgInQ6OnRleHQgPSAnQSciIGlzIGNvcnJlY3RseQprZXB0IGFib3ZlIGl0 LgoKSW5zdGVhZCBvZiBzcGVjaWFsLWNhc2luZyB0aGUgYXJnLCBoYXZlIHRoZSB3YWxrZXIgYmlu ZCBhIFZhciBhcmcKd2hpbGUgd2Fsa2luZyB0aGUgV0hFTiBjb25kaXRpb25zIGFuZCByZXNvbHZl IGVhY2ggQ2FzZVRlc3RFeHByIHRvIGl0LApzbyB0aGF0IHRoZSBhcmcgaXMgY2hlY2tlZCBleGFj dGx5IGFzIGVhY2ggV0hFTiB1c2VzIGl0OiB3aXRoIHRoZQpvcGZhbWlseSBhbmQgY29sbGF0aW9u IGNoZWNrcyBvZiBhIGRpcmVjdCBvcGVyYW5kIHdoZW4gdGhlIFdIRU4gaXMgYQpjb21wYXJpc29u LCBhbmQgYXMgYSBub24tb3BlcmFuZCByZWZlcmVuY2Ugb3RoZXJ3aXNlLiAgQSBub24tVmFyIGFy ZwppcyB3YWxrZWQgb25jZSBhcyBhIG5vbi1vcGVyYW5kLCBhcyBiZWZvcmUuICBUaGUgQ2FzZVRl c3RFeHByIGluIGFuCkFycmF5Q29lcmNlRXhwcidzIGVsZW1leHByIGFuZCBhIEpzb25Db25zdHJ1 Y3RvckV4cHIncyBjb2VyY2lvbiBzdGFuZApmb3Igc29tZXRoaW5nIGVsc2UgYW5kIGFyZSBsZWZ0 IGFsb25lLgoKUmVwb3J0ZWQtYnk6IFRlbmRlciBXYW5nIDx0bmRyd2FuZ0BnbWFpbC5jb20+CkF1 dGhvcjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBU ZW5kZXIgV2FuZyA8dG5kcndhbmdAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogRXdhbiBZb3VuZyA8 a2RiYXNlLmhhY2tAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NB SGV3WE5rdkdUT2dpalJMam11ZHBnPXd6MGQtSjhDaFkybzdrc2gzQmUrUV9CeHdvZ0BtYWlsLmdt YWlsLmNvbQpCYWNrcGF0Y2gtdGhyb3VnaDogMTgKCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NUQUJM RQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRp ZmYvZGQ3YzEzNWJiOTdlYzdhNWRhZDA5ZmE5ZTFlMmRkOWMwNDRjZWVlOAoKTW9kaWZpZWQgRmls ZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAg ICAgICAgICB8IDEyNyArKysrKysrKysrKysrKysrKy0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvY29sbGF0ZS5pY3UudXRmOC5vdXQgfCAgMzUgKysrKysrKwpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL3N1YnNlbGVjdC5vdXQgICAgICAgIHwgIDI3ICsrKysrKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAgICAgIHwgIDEyICsrKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9zdWJzZWxlY3Quc3FsICAgICAgICAgICAgIHwgIDExICsrKwo1IGZpbGVzIGNo YW5nZWQsIDE3MSBpbnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============7209084015212641955==--