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 1wgdcC-006Izl-00 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-00FXZ2-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-00FWHJ-0D 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-00000001m0a-1p0b 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=wLJQuba51KghP4iSNAoUOzT1+2GHsdFGNSz2CSwajI8=; b=T2MOc95OwW8DUzgeWLm81QRbqN b3W3HYdkvkGe/PqWr8dNYw5QCiofAt8AdXPLX2ZD/2qHqzvlEFTnqwfQagrZC8Flwk1iALJr9Bwju 3XMCqzx/mAYzidCKDpoFordn/rJonkCADo2c8FRqzpcBNdPFrDSxCwsSENpQneADKDpAEqQmrnOCd rDA91B+sZmGMA8EtCu/p4CsKGY98Igwp7uOdyDPnu0bNpg4FZYk8BZIO6BEw0lpIhzLFGCHwKc5P3 kDduINofNTQnEFj71uKKhcjDv4DZ8KLCXnaGAwrx3D+on0Eb/W1LP0vB8mJkhGpgx3cWHRb/8iTg4 WRSsnmRg==; 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-00BRmm-1q 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-001Ydb-0S for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 07:16:27 +0000 Content-Type: multipart/mixed; boundary="===============3168497624815976135==" 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 --===============3168497624815976135== 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 bC5jb20KQmFja3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWls cwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNDRmYjU5 ZmM2MDVlYTBlYWJkNTgwMjliYjhkYzJjMjQxNmM0MmMzYwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0t LS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0aHMuYyAgICAgICAgICB8 IDE3OSArKysrKysrKysrKysrKysrCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIu YyAgICAgICAgICAgfCAyNjMgKysrKysrKy0tLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0 aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAgICAgICB8IDI2OCArKysrKysrKysrKysrKysrKysr KysrKwpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9sc3lzY2FjaGUuYyAgICAgICAgICAgIHwgIDI0 ICsrLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvY2xhdXNlcy5oICAgICAgICAgICAgICAgIHwgIDE0 ICsrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWdncmVnYXRlcy5vdXQgICAgICAgfCAgODAg KysrKysrLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbGxhdGUuaWN1LnV0Zjgub3V0IHwg Mjg2ICsrKysrKysrKysrKysrKysrKysrKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9z dWJzZWxlY3Qub3V0ICAgICAgICB8IDIxNCArKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVn cmVzcy9zcWwvYWdncmVnYXRlcy5zcWwgICAgICAgICAgICB8ICA0NiArKystCnNyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL2NvbGxhdGUuaWN1LnV0Zjguc3FsICAgICAgfCAxMjkgKysrKysrKysrKy0Kc3Jj L3Rlc3QvcmVncmVzcy9zcWwvc3Vic2VsZWN0LnNxbCAgICAgICAgICAgICB8IDEwNSArKysrKysr KysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgICAgICB8ICAgNCAr LQoxMiBmaWxlcyBjaGFuZ2VkLCAxMzcwIGluc2VydGlvbnMoKyksIDI0MiBkZWxldGlvbnMoLSkK Cg== --===============3168497624815976135==--