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 1wgdcB-006Izm-38 for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jul 2026 07:19:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgdcA-00FXZ3-1N for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jul 2026 07:19:38 +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 1wgdZB-00FWHK-1g for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 07:16:33 +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 1wgdZ7-00000001m0b-2DEf for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 07:16:32 +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=SSuDDaE+u1PDf3DMZwxnoTKnX/sXD7u1dARCnLViurk=; b=vU9QAGp4uPSxJDR76AHyXMVQrX vqFiUZPVSDZ7pbYFsoCcgZJXrXzE32DAMKdTiJ4KjE2SLictOjFTxC8VjPr6VurqWhFefbi+L4Dtp pJpPFfAEtnGZDSzKDZndeTHF6ZnF/bcIioGfUqAuWIwX/cOBIjXZzamN0zWqdQj9g3RjQovr88XHY 5dzZNsXamZcV9kJvS9s/eKa3FTrDpz850HryhvD/F5ZZbWJqG9YAFre3ehndA+pnwhM2P2bW6SCC+ R88cxjBwPyY0nGJMThD8zvvJbdWg6kTdfcttlPPd1yaQa0IZihQ98DxDZCKIgC2P1xoYKy1tfO0qI gFSiTOvg==; 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 1wgdZ6-00BRmn-2A for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 07:16:28 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgdZ6-001Ydd-0Y for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 07:16:27 +0000 Content-Type: multipart/mixed; boundary="===============3877207523006225385==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix qual pushdown past grouping with mismatched equivalence X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 06 Jul 2026 07:16:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3877207523006225385== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHF1YWwgcHVzaGRvd24gcGFzdCBncm91cGluZyB3aXRoIG1pc21hdGNoZWQgZXF1aXZhbGVu Y2UKClRoZSBwbGFubmVyIGhhcyB0d28gb3B0aW1pemF0aW9ucyB0aGF0IG1vdmUgYSBxdWFsIGNs YXVzZSBhY3Jvc3MgYQpncm91cGluZyBib3VuZGFyeTogc3VicXVlcnlfcGxhbm5lciB0cmFuc2Zl cnMgSEFWSU5HIGNsYXVzZXMgdG8gV0hFUkUKc28gdGhleSBjYW4gYmUgZXZhbHVhdGVkIGJlZm9y ZSBhZ2dyZWdhdGlvbiwgYW5kIHF1YWxfaXNfcHVzaGRvd25fc2FmZQpwdXNoZXMgb3V0ZXIgcmVz dHJpY3Rpb24gY2xhdXNlcyBpbnRvIGEgc3VicXVlcnkgcGFzdCBpdHMgRElTVElOQ1QsCkRJU1RJ TkNUIE9OLCB3aW5kb3cgUEFSVElUSU9OIEJZLCBvciBzZXQtb3BlcmF0aW9uIGdyb3VwaW5nIGxh eWVyLgpCb3RoIHByb2R1Y2Ugd3JvbmcgcmVzdWx0cyB3aGVuIHRoZSBtb3ZlZCBjbGF1c2UncyBl cXVpdmFsZW5jZQpyZWxhdGlvbiBkaXNhZ3JlZXMgd2l0aCB0aGUgZ3JvdXBpbmcncywgc2luY2Ug dGhlIGNsYXVzZSB0aGVuIGZpbHRlcnMKcm93cyB0aGUgZ3JvdXBpbmcgd291bGQgaGF2ZSBtZXJn ZWQuCgpUaGUgZGlzYWdyZWVtZW50IGhhcyB0d28gZm9ybXMuICBBIHR5cGUgbWF5IGJlbG9uZyB0 byBtdWx0aXBsZSBidHJlZQpvcGZhbWlsaWVzIHdob3NlIGVxdWFsaXR5IG9wZXJhdG9ycyBkaXNh Z3JlZSAoZS5nLiByZWNvcmRfb3BzIHZzCnJlY29yZF9pbWFnZV9vcHMpOyBvciB0aGUgZ3JvdXBp bmcgbWF5IHVzZSBhIG5vbmRldGVybWluaXN0aWMKY29sbGF0aW9uLCB3aGVyZSBjb21wYXJpbmcg dGhlIGNvbHVtbiB1bmRlciBhIGRpZmZlcmVudCBjb2xsYXRpb24sIG9yCndyYXBwaW5nIGl0IGlu IGEgZnVuY3Rpb24gb3Igb3BlcmF0b3IsIGNhbiBkaXN0aW5ndWlzaCB2YWx1ZXMgdGhlCmNvbGxh dGlvbiBjb25zaWRlcnMgZXF1YWwuICBCZWNhdXNlIHdlIGNhbm5vdCBwcm92ZSBhbiBhcmJpdHJh cnkKZXhwcmVzc2lvbiBwcmVzZXJ2ZXMgdGhhdCBlcXVhbGl0eSwgYSBncm91cGluZyBjb2x1bW4g d2l0aCBhCm5vbmRldGVybWluaXN0aWMgY29sbGF0aW9uIGlzIHNhZmUgdG8gcHVzaCBvbmx5IGFz IGEgZGlyZWN0IG9wZXJhbmQgb2YKYSBjb21wYXJpc29uIHVuZGVyIGl0cyBvd24gY29sbGF0aW9u LgoKRml4IGJvdGggY2FsbCBzaXRlcyB0aHJvdWdoIGEgc2hhcmVkIHdhbGtlciBwYXJhbWV0ZXJp emVkIGJ5IGEKY2FsbGJhY2sgdGhhdCBtYXBzIGVhY2ggVmFyIHRvIHRoZSBncm91cGluZyBlcXVh bGl0eSBvcGVyYXRvciBmb3IgaXRzCmNvbHVtbiAob3IgSW52YWxpZE9pZCBmb3Igbm9uLWdyb3Vw aW5nIFZhcnMpLiAgRm9yIEhBVklORywgdGhlCmNhbGxiYWNrIHJlY292ZXJzIHRoZSBTb3J0R3Jv dXBDbGF1c2UncyBlcW9wIHZpYSB0aGUgR1JPVVAgVmFyJ3MKdmFyYXR0bm8sIHdoaWNoIHJlcXVp cmVzIHJ1bm5pbmcgYmVmb3JlIGZsYXR0ZW5fZ3JvdXBfZXhwcnMgd2hpbGUKaGF2aW5nUXVhbCBz dGlsbCBjb250YWlucyBHUk9VUCBWYXJzLiAgRm9yIHN1YnF1ZXJ5IHB1c2hkb3duLCB0aGUKY2Fs bGJhY2sgcmVjb3ZlcnMgdGhlIGVxb3AgZnJvbSBzdWJxdWVyeS0+ZGlzdGluY3RDbGF1c2UsIGEg d2luZG93J3MKcGFydGl0aW9uQ2xhdXNlLCBvciBhbnkgZ3JvdXBpbmcgbm9kZSBpbiB0aGUgU2V0 T3BlcmF0aW9uU3RtdCB0cmVlLgpUaGUgd2Fsa2VyIGZpcmVzIG9ubHkgd2hlbiB0aGVyZSBpcyBh biBlcXVpdmFsZW5jZSBib3VuZGFyeSB0byBjcm9zcywKZ2F0ZWQgYnkgZWl0aGVyIHRoZSBleGlz dGluZyBVTlNBRkVfTk9USU5fRElTVElOQ1RPTl9DTEFVU0UgYW5kClVOU0FGRV9OT1RJTl9QQVJU SVRJT05CWV9DTEFVU0UgZmxhZ3Mgb3IgYnkgYSByZWN1cnNpdmUgY2hlY2sgZm9yIGFueQpncm91 cGluZyBub2RlIGluIHRoZSBzZXQtb3AgdHJlZS4KCkJhY2stcGF0Y2ggdG8gdjE4IG9ubHkuICBU aGUgSEFWSU5HIGhhbGYgcmVsaWVzIG9uIHRoZSBSVEVfR1JPVVAKbWVjaGFuaXNtIGludHJvZHVj ZWQgaW4gdjE4IChjb21taXQgMjQ3ZGVhODlmKSwgd2hpY2ggaXMgd2hhdCBsZXRzIHVzCmlkZW50 aWZ5IGdyb3VwaW5nIGV4cHJlc3Npb25zIHZpYSBHUk9VUCBWYXJzIG9uIHByZS1mbGF0dGVuCmhh dmluZ1F1YWwuICBQcmUtdjE4IGJyYW5jaGVzIGxhY2sgdGhhdCBtYWNoaW5lcnksIHNvIGEgYmFj ay1wYXRjaAp0aGVyZSB3b3VsZCBuZWVkIGEgZGlmZmVyZW50IGFwcHJvYWNoLiAgR2l2ZW4gdGhl IGFic2VuY2Ugb2YgZmllbGQKcmVwb3J0cyBvZiB0aGVzZSBidWdzIG9uIGJhY2sgYnJhbmNoZXMs IHRoZSByaXNrIG9mIGNhcnJ5aW5nIGEKZGlmZmVyZW50IGZpeCBvbiBzdGFibGUgYnJhbmNoZXMg aXMgbm90IGp1c3RpZmllZC4KCkF1dGhvcjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFp bC5jb20+ClJldmlld2VkLWJ5OiBUaG9tIEJyb3duIDx0aG9tQGxpbnV4LmNvbT4KUmV2aWV3ZWQt Ynk6IEZsb3JpbiBJcmlvbiA8aXJpb25yQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFpzb2x0IFBh cnJhZ2kgPHpzb2x0LnBhcnJhZ2lAcGVyY29uYS5jb20+ClJldmlld2VkLWJ5OiBUZW5kZXIgV2Fu ZyA8dG5kcndhbmdAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogQ2hlbmdwZW5nIFlhbiA8Y2hlbmdw ZW5nX3lhbkBvdXRsb29rLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1i V3M0LVFMWnBuM1VWT3BlRzJmT3h4aGRua0ROTVpfM1pjbTNkcUp3UkFwaHo2OGdAbWFpbC5nbWFp bC5jb20KQmFja3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tClJFTF8xOV9TVEFCTEUK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm Lzk4ZDVkN2VlNjQxOWRjNGIzODk0ZDdiNDYxMGEyZTEyOGY2NzUwNTIKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2FsbHBhdGhzLmMgICAg ICAgICAgfCAxNzkgKysrKysrKysrKysrKysrKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9w bGFubmVyLmMgICAgICAgICAgIHwgMjYzICsrKysrKystLS0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL2NsYXVzZXMuYyAgICAgICAgICAgfCAyNjggKysrKysrKysrKysr KysrKysrKysrKysKc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvbHN5c2NhY2hlLmMgICAgICAgICAg ICB8ICAyNCArKy0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL2NsYXVzZXMuaCAgICAgICAgICAgICAg ICB8ICAxNCArKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FnZ3JlZ2F0ZXMub3V0ICAgICAg IHwgIDgwICsrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jb2xsYXRlLmljdS51dGY4 Lm91dCB8IDI4NiArKysrKysrKysrKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvc3Vic2VsZWN0Lm91dCAgICAgICAgfCAyMTQgKysrKysrKysrKysrKysrKysrCnNyYy90 ZXN0L3JlZ3Jlc3Mvc3FsL2FnZ3JlZ2F0ZXMuc3FsICAgICAgICAgICAgfCAgNDYgKysrLQpzcmMv dGVzdC9yZWdyZXNzL3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAgICAgIHwgMTI5ICsrKysrKysr KystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N1YnNlbGVjdC5zcWwgICAgICAgICAgICAgfCAxMDUg KysrKysrKysrCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAgICAgICAgICAgICAg fCAgIDQgKy0KMTIgZmlsZXMgY2hhbmdlZCwgMTM3MCBpbnNlcnRpb25zKCspLCAyNDIgZGVsZXRp b25zKC0pCgo= --===============3877207523006225385==--