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.94.2) (envelope-from ) id 1vB3At-009flU-HN for pgsql-committers@arkaria.postgresql.org; Tue, 21 Oct 2025 03:36:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vB3As-00685z-II for pgsql-committers@arkaria.postgresql.org; Tue, 21 Oct 2025 03:36:37 +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.94.2) (envelope-from ) id 1vB3As-00685h-5S for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:36:37 +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.96) (envelope-from ) id 1vB3Ao-003LhW-2H for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:36:36 +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=ooaGRnoTRM7Df4evWR9NL+mW76kQCmfzcjK7T0ghoo4=; b=UU0ZKtiOXOfzR7E/0Wta0foZs4 WQF1nLdPfrt8oELYvbov8MCPEAE2Syh2WPtd/WzZ1mwTDhq9mFzMGZEFZ67Mw4mLxG7NoROqqU0fo 0sFCVdSKeM5zDpyo0EBU36R2LoOGL544GWGz+gWk8q88UG//+zgkmqGaYN+bItvi71sFOYU4l2gKT KuuOcNou823nC40kueBoParzjhQ8GWOugsKRv3Pe06vP0sncoSMy/ctcw87aBEcnMBh5BY9jdVTEN GplxqNTHwpLp9JYvbcD898tjdhldEHD0OKBhmK4fnVZLadNGsz5fKxW8+wqzXF/klGyGmmTOf3stT b4qtd+cA==; 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.94.2) (envelope-from ) id 1vB3Ao-00377J-FR for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:36:33 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vB3Am-002i6Y-1p for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:36:32 +0000 Content-Type: multipart/mixed; boundary="===============2325823129919875344==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix pushdown of degenerate HAVING clauses X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 21 Oct 2025 03:36:32 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2325823129919875344== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHB1c2hkb3duIG9mIGRlZ2VuZXJhdGUgSEFWSU5HIGNsYXVzZXMKCjY3YTU0YjllOCB0YXVn aHQgdGhlIHBsYW5uZXIgdG8gcHVzaCBkb3duIEhBVklORyBjbGF1c2VzIGV2ZW4gd2hlbgpncm91 cGluZyBzZXRzIGFyZSBwcmVzZW50LCBhcyBsb25nIGFzIHRoZSBjbGF1c2UgZG9lcyBub3QgcmVm ZXJlbmNlCmFueSBjb2x1bW5zIHRoYXQgYXJlIG51bGxhYmxlIGJ5IHRoZSBncm91cGluZyBzZXRz LiAgSG93ZXZlciwgdGhlcmUKd2FzIGFuIG92ZXJzaWdodDogaWYgYW55IGVtcHR5IGdyb3VwaW5n IHNldHMgYXJlIHByZXNlbnQsIHRoZQphZ2dyZWdhdGlvbiBub2RlIGNhbiBwcm9kdWNlIGEgcm93 IHRoYXQgZGlkIG5vdCBjb21lIGZyb20gdGhlIGlucHV0LAphbmQgcHVzaGluZyBkb3duIGEgSEFW SU5HIGNsYXVzZSBpbiB0aGlzIGNhc2UgbWF5IGNhdXNlIHVzIHRvIGZhaWwgdG8KZmlsdGVyIG91 dCB0aGF0IHJvdy4KCkN1cnJlbnRseSwgbm9uLWRlZ2VuZXJhdGUgSEFWSU5HIGNsYXVzZXMgYXJl IG5vdCBwdXNoZWQgZG93biB3aGVuCmVtcHR5IGdyb3VwaW5nIHNldHMgYXJlIHByZXNlbnQsIHNp bmNlIHRoZSBlbXB0eSBncm91cGluZyBzZXRzIHdvdWxkCm51bGxpZnkgdGhlIHZhcnMgdGhleSBy ZWZlcmVuY2UuICBIb3dldmVyLCBkZWdlbmVyYXRlICh2YXJpYWJsZS1mcmVlKQpIQVZJTkcgY2xh dXNlcyBhcmUgbm90IHN1YmplY3QgdG8gdGhpcyByZXN0cmljdGlvbiBhbmQgbWF5IGJlCmluY29y cmVjdGx5IHB1c2hlZCBkb3duLgoKVG8gZml4LCBleHBsaWNpdGx5IGNoZWNrIGZvciB0aGUgcHJl c2VuY2Ugb2YgZW1wdHkgZ3JvdXBpbmcgc2V0cyBhbmQKcmV0YWluIGRlZ2VuZXJhdGUgY2xhdXNl cyBpbiBIQVZJTkcgd2hlbiB0aGV5IGFyZSBwcmVzZW50LiAgVGhpcwplbnN1cmVzIHRoYXQgd2Ug ZG9uJ3QgZW1pdCBhIGJvZ3VzIGFnZ3JlZ2F0ZWQgcm93LiAgQSBjb3B5IG9mIGVhY2gKc3VjaCBj bGF1c2UgaXMgYWxzbyBwdXQgaW4gV0hFUkUgc28gdGhhdCBxdWVyeV9wbGFubmVyKCkgY2FuIHVz ZSBpdCBpbgphIGdhdGluZyBSZXN1bHQgbm9kZS4KClRvIGZhY2lsaXRhdGUgdGhpcyBjaGVjaywg dGhpcyBwYXRjaCBleHBhbmRzIHRoZSBncm91cGluZ1NldHMgdHJlZSBvZgp0aGUgcXVlcnkgdG8g YSBmbGF0IGxpc3Qgb2YgZ3JvdXBpbmcgc2V0cyBiZWZvcmUgYXBwbHlpbmcgdGhlIEhBVklORwpw dXNoZG93biBvcHRpbWl6YXRpb24uICBUaGlzIGRvZXMgbm90IGFkZCBhbnkgYWRkaXRpb25hbCBw bGFubmluZwpvdmVyaGVhZCwgc2luY2Ugd2UgbmVlZCB0byBkbyB0aGlzIGV4cGFuc2lvbiBhbnl3 YXkuCgpJbiBwYXNzaW5nLCBtYWtlIGEgc21hbGwgdHdlYWsgdG8gcHJlcHJvY2Vzc19ncm91cGlu Z19zZXRzKCkgYnkKcmVvcmRlcmluZyBpdHMgaW5pdGlhbCBvcGVyYXRpb25zIGEgYml0LgoKQmFj a3BhdGNoIHRvIHYxOCwgd2hlcmUgdGhpcyBpc3N1ZSB3YXMgaW50cm9kdWNlZC4KClJlcG9ydGVk LWJ5OiBZdWhhbmcgUWl1IDxpYW1xeWhAZ21haWwuY29tPgpBdXRob3I6IFJpY2hhcmQgR3VvIDxn dW9mZW5nbGludXhAZ21haWwuY29tPgpBdXRob3I6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51 cz4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8wODc5RDlDOS03RkUyLTRBMjAtOTU5 My1CMjNGN0EwQjUyOTBAZ21haWwuY29tCkJhY2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0t LS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzE4ZDI2MTQwOTM0ODFjYjdhZTg5ZTFmNWI3MmYzZGRmNWZiNDliNGMKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3Bs YW5uZXIuYyAgICAgICB8IDY3ICsrKysrKysrKysrKysrKy0tLS0tLS0tLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2dyb3VwaW5nc2V0cy5vdXQgfCA4MiArKysrKysrKysrKysrKysrKysrKysr KysrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ3JvdXBpbmdzZXRzLnNxbCAgICAgIHwgMjAg KysrKysrKy0KMyBmaWxlcyBjaGFuZ2VkLCAxNDMgaW5zZXJ0aW9ucygrKSwgMjYgZGVsZXRpb25z KC0pCgo= --===============2325823129919875344==--