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 1vB3ED-009ga0-IS for pgsql-committers@arkaria.postgresql.org; Tue, 21 Oct 2025 03:40:04 +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 1vB3EC-006Ani-Fn for pgsql-committers@arkaria.postgresql.org; Tue, 21 Oct 2025 03:40:03 +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 1vB3EC-006Ana-83 for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:40:03 +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 1vB3E8-003Ljl-32 for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:40:02 +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=lf08buXhYudrD3dpsp+s4OtrDqSPrc4JokAWMRjKgEM=; b=1SFt5W1cGBiczLrVNwt8srHZ/X x3wM8iY4ByVNqgjTus3t0aL+YF3XEQEFy/mnjj7JVonsMpiLC30L0CQE9Czv+ELA1VWSu7C6PwjGA HrKvjDWhW08fCk368JBKfkVKCelHGYfD9Up5cDQlydGHdeLjCNCE+D9CikobfIpKVVQqtioyPtv2q V3s6wPp2kHYakpB25erlgBU5Lw6JmWlPGQgV+nOSXmIlLxDIIkKUsoRJSCm2cTFESrrdWKmbFPGIV EvNgm35XGrNbp0PqLbetYhPDgtXgs3Sqc7bdGysPgCN1WdZk/hoTAO+51vTu1s97VZ4TWzTfDoTLF YtxrIxFA==; 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 1vB3E8-0037Bm-Sj for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:39:59 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vB3E7-002i9E-01 for pgsql-committers@lists.postgresql.org; Tue, 21 Oct 2025 03:39:59 +0000 Content-Type: multipart/mixed; boundary="===============7047041850597408186==" 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:39:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7047041850597408186== 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 LS0tLQpSRUxfMThfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi80MGMyNDI4MzA3YjgyZDU5MGYwY2FmNzNjOTNhNWNkYWY3MjFl OGI4CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIv cGxhbi9wbGFubmVyLmMgICAgICAgfCA2NyArKysrKysrKysrKysrKystLS0tLS0tLS0Kc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9ncm91cGluZ3NldHMub3V0IHwgODIgKysrKysrKysrKysrKysr KysrKysrKysrKysrKystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dyb3VwaW5nc2V0cy5zcWwgICAg ICB8IDIwICsrKysrKystCjMgZmlsZXMgY2hhbmdlZCwgMTQzIGluc2VydGlvbnMoKyksIDI2IGRl bGV0aW9ucygtKQoK --===============7047041850597408186==--