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 1uXMl6-00905x-H4 for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Jul 2025 16:26:00 +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 1uXMl4-00Ehvv-L9 for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Jul 2025 16:25:59 +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 1uXMZd-00EXG1-Br for pgsql-bugs@lists.postgresql.org; Thu, 03 Jul 2025 16:14:10 +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 1uXMZa-005XDJ-1a for pgsql-bugs@lists.postgresql.org; Thu, 03 Jul 2025 16:14:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=UEXKfI0wc9+0Duko93FXoYuk7lGbyfixURKlEeoVHLc=; b=ZILPjuU5epOL60E+QZAewvs7UO r3+xWFrd7zynhXl9jzVa8yMOJ3tLD+io7veG4irxM/LtT0uWS8oE4cyIgjcAk+TNlCKT61U+QKHAm j61DEQwh061uJwUxFZnzzErr/AnrLecqVdajeZ9tiv9E5G1sVR/XhXIxoKy3ClYUsadGSD5cvPuwu ZIEq7Wax3Iz+jqbL55FmUBxJStXdE8XRU+7nD/HxczEXnXmnaNEX3o9qqs6XFrIzIICeYxvunFVPK dj7/G8LaEJdwCtk6iLF3ywDBe9HVz3dZqW8pGPqK0/ifk/A/i9Gr6hSUM0DdReRG/CiHHk/yAXiLB Pds9ryCA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXMZY-00Eubw-1d for pgsql-bugs@lists.postgresql.org; Thu, 03 Jul 2025 16:14:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uXMZW-00DsgP-0z for pgsql-bugs@lists.postgresql.org; Thu, 03 Jul 2025 16:14:02 +0000 Content-Type: multipart/mixed; boundary="===============1387996990611135905==" MIME-Version: 1.0 Subject: BUG #18978: Index does not work in aggregate function filter To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhui-lai@foxmail.com Reply-To: jinhui-lai@foxmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 03 Jul 2025 16:13:59 +0000 Message-ID: <18978-646ebd7e8e0744ae@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1387996990611135905== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk3OApMb2dnZWQgYnk6ICAgICAgICAgIEppbmh1aQpFbWFpbCBhZGRy ZXNzOiAgICAgIGppbmh1aS1sYWlAZm94bWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy41 Ck9wZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAgCgpE ZWFyIFBHIGRldmVsb3BlcnMsClRoYW5rcyBmb3IgcmVhZGluZyBteSByZXBvcnQhCkkgd291bGQg bGlrZSB0byBzYXkgdGhhdCAiYWdncmVnYXRlX2Z1bmN0aW9uKGNvbHVtbikgRklMVEVSIChXSEVS RQpjb25kaXRpb24pIiBpcyByZWFsbHkgYSB3b25kZXJmdWwgZmVhdHVyZSBpbiBQRy4gRm9yIGV4 YW1wbGUsICAiU0VMRUNUCkNPVU5UKGMxKSBBUyB0b3RhbCwgQ09VTlQob3JkZXJfaWQpIEZJTFRF UiAoV0hFUkUgYzE8MikgQVMgZmlsdGVyZWQgRlJPTQp0MSIsIHRoaXMgcXVlcnkgaGVscHMgdXNl cnMgZ2V0IGJvdGggdG90YWwgYW5kIGZpbHRlcmVkIGNvdW50LgpIb3dldmVyLCB3aGVuIHVzZXJz IHdhbm5hIHRvIGFkZCBhbiBpbmRleCB0byBzcGVlZCB1cCBzdWNoIHF1ZXJpZXMsIGl0CmRvZXNu J3Qgc2VlbSB0byB3b3JrLiBZb3UgY2FuIHJlcHJvZHVjZSBpdCBhcyBmb2xsb3dzOgpDUkVBVEUg VEFCTEUgdDEoYzEgSU5UOCk7CklOU0VSVCBJTlRPIHQxIFNFTEVDVCBpIEZST00gZ2VuZXJhdGVf c2VyaWVzKDEsIDEwMDAwMDAwMCkgQVMgaTsKQ1JFQVRFIElOREVYIGkgT04gdDEoYzEpOwpTRUxF Q1QgQ09VTlQoYzEpIEZJTFRFUiAoV0hFUkUgYzE8MikgRlJPTSB0MTsKIGNvdW50Ci0tLS0tLS0K ICAgICAxCigxIHJvdykKVGltZTogMzEzMy4yMjUgbXMgKDAwOjAzLjEzMykKU0VMRUNUIENPVU5U KGMxKSBGUk9NIHQxIFdIRVJFIGMxPDI7CiBjb3VudAotLS0tLS0tCiAgICAgMQooMSByb3cpClRp bWU6IDMuNzU2IG1zCmV4cGxhaW4gU0VMRUNUIENPVU5UKGMxKSBGSUxURVIgKFdIRVJFIGMxPDIp IEZST00gdDE7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBM QU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIEZpbmFsaXplIEFnZ3JlZ2F0ZSAg KGNvc3Q9MTA2ODQ3OC4yMi4uMTA2ODQ3OC4yMyByb3dzPTEgd2lkdGg9OCkKICAgLT4gIEdhdGhl ciAgKGNvc3Q9MTA2ODQ3OC4wMC4uMTA2ODQ3OC4yMSByb3dzPTIgd2lkdGg9OCkKICAgICAgICAg V29ya2VycyBQbGFubmVkOiAyCiAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9 MTA2NzQ3OC4wMC4uMTA2NzQ3OC4wMSByb3dzPTEgd2lkdGg9OCkKICAgICAgICAgICAgICAgLT4g IFBhcmFsbGVsIFNlcSBTY2FuIG9uIHQxICAoY29zdD0wLjAwLi44NTkxNDQuNjcKcm93cz00MTY2 NjY2NyB3aWR0aD04KQogSklUOgogICBGdW5jdGlvbnM6IDUKICAgT3B0aW9uczogSW5saW5pbmcg dHJ1ZSwgT3B0aW1pemF0aW9uIHRydWUsIEV4cHJlc3Npb25zIHRydWUsIERlZm9ybWluZwp0cnVl CmV4cGxhaW4gU0VMRUNUIENPVU5UKGMxKSBGUk9NIHQxIFdIRVJFIGMxPDI7CiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIEFnZ3JlZ2F0ZSAg KGNvc3Q9NC41OS4uNC42MCByb3dzPTEgd2lkdGg9OCkKICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1 c2luZyBpIG9uIHQxICAoY29zdD0wLjU3Li40LjU4IHJvd3M9MSB3aWR0aD04KQogICAgICAgICBJ bmRleCBDb25kOiAoYzEgPCAyKQpEbyB5b3UgdGhpbmsgdGhpcyBncmVhdCBmZWF0dXJlIG9mIFBH IG5lZWRzIHRvIGJlIG9wdGltaXplZD8KVGhhbmtzIHlvdSBvbmNlIGFnYWluLiBJIGxvb2sgZm9y d2FyZCB0byB5b3VyIHJlcGx5LgpCZXN0IHJlZ2FyZCwKSmluaHVpCgo= --===============1387996990611135905==--