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-005LFo-12 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-00B4A3-39 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 1x1eYt-00B2nE-0n for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:07 +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-00000003aua-4798 for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:06 +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=Ra057aGYv4MvDl98DZuXqi0b5csEbMjhuKiNnS4gCJk=; b=lkzIPdovjCK1ygLE4BN/0jluAh ncOUryv3Yd32dbsgYqlN1MNvX/ETfnnihv9lLVCFGpDHZ1nBS9PMeaC0EblFJqkGHlhjwaYr38/6L nAhqtHEp9IjdAOnGOnnaTo/m3mo62RSLK38/ME26LWBN4CwgB0hBimwE1EUe+kbmuJeQR8YwrS/ed Evldf4a3ig5hPUIgQQH4B/VJHE15uXpZFdkSVzfMP+DJPFVSxfFyAE/2DNLZk6WTZll0/VzJsClR9 7iWifdNIEKYeZdAtlGQfhbZe8+ZQ1k/SMHjs80k6f3Konzao6KchPfG68KDFS8HMje6r+DSFS/9cJ 2WCMKeow==; 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-00AuOM-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-000000038vt-0Q7R for pgsql-committers@lists.postgresql.org; Wed, 02 Sep 2026 06:35:03 +0000 Content-Type: multipart/mixed; boundary="===============3207738564887712019==" 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 --===============3207738564887712019== 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 YWlsLmNvbQpCYWNrcGF0Y2gtdGhyb3VnaDogMTgKCkJyYW5jaAotLS0tLS0KUkVMXzE5X1NUQUJM RQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRp ZmYvYTNiYzdmMmMwZGU4YWQ1YzZhZTc0NmNiNmMxYzVjMTg3YTYwYzEyNAoKTW9kaWZpZWQgRmls ZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAg ICAgICAgICB8IDEyNyArKysrKysrKysrKysrKysrKy0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvY29sbGF0ZS5pY3UudXRmOC5vdXQgfCAgMzUgKysrKysrKwpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL3N1YnNlbGVjdC5vdXQgICAgICAgIHwgIDI3ICsrKysrKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAgICAgIHwgIDEyICsrKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC9zdWJzZWxlY3Quc3FsICAgICAgICAgICAgIHwgIDExICsrKwo1IGZpbGVzIGNo YW5nZWQsIDE3MSBpbnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============3207738564887712019==--