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 1uthY2-00CuSL-Ux for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:04:52 +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 1uthY2-007gBk-4k for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:04:50 +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.94.2) (envelope-from ) id 1uthY1-007gBc-Ss for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:04:50 +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.96) (envelope-from ) id 1uthY0-000HtY-1x for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:04:49 +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=0NiRUxmqBmSbezxZ5M8W1xhkMR4GkdYHabao2pWExx0=; b=mjF9CaO60K8Zk3c89oqGfJ74u+ Nq1UhHpFv3erGxngu+3I7W/gDpVjeuLd4bWEhsSTREZ2yrw7kjN8m5V9RT7u6cpLZyMu3CpyivUjw GZJ3fkbTKbHk29lWrulG2RFrDSpMshG6JA70UCjI3FI0YnjXV7OUTzHAnW16auGnt2fk92VdXpROl tNrRc9N03+MNL70maRrL4RPp6HjOqZgIzp/obETEMz1kjEgJOZkAvucFKa0Qba6RMAYuRxw0f2KcB g0lQ1XdoUHYk5YueOZ2vauwL5O8cdicLUwu7Psz8UMNiwNxQg372L4W5v4RmyZ4YBdS46CKMNS3kB xuKfAMJg==; 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 1uthXz-000oB7-Hf for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:04:48 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uthY0-000GrA-0s for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:04:47 +0000 Content-Type: multipart/mixed; boundary="===============8136934144765542029==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix planner error when estimating SubPlan cost X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 03 Sep 2025 07:04:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8136934144765542029== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBsYW5uZXIgZXJyb3Igd2hlbiBlc3RpbWF0aW5nIFN1YlBsYW4gY29zdAoKU3ViUGxhbiBu b2RlcyBhcmUgdHlwaWNhbGx5IGJ1aWx0IHZlcnkgZWFybHksIGJlZm9yZSBhbnkgUmVsT3B0SW5m b3MKaGF2ZSBiZWVuIGNvbnN0cnVjdGVkIGZvciB0aGUgcGFyZW50IHF1ZXJ5IGxldmVsLiAgQXMg YSByZXN1bHQsIHRoZQpzaW1wbGVfcmVsX2FycmF5IGluIHRoZSBwYXJlbnQgcm9vdCBoYXMgbm90 IHlldCBiZWVuIGluaXRpYWxpemVkLgpDdXJyZW50bHksIGR1cmluZyBjb3N0IGVzdGltYXRpb24g b2YgYSBTdWJQbGFuJ3MgdGVzdGV4cHIsIHdlIG1heSBjYWxsCmV4YW1pbmVfdmFyaWFibGUoKSB0 byBsb29rIHVwIHN0YXRpc3RpY2FsIGRhdGEgYWJvdXQgdGhlIGV4cHJlc3Npb25zLgpUaGlzIGNh biBsZWFkIHRvICJubyByZWxhdGlvbiBlbnRyeSBmb3IgcmVsaWQiIGVycm9ycy4KClRvIGZpeCwg cGFzcyByb290IGFzIE5VTEwgdG8gY29zdF9xdWFsX2V2YWwoKSBpbiBjb3N0X3N1YnBsYW4oKSwg c2luY2UKdGhlIHJvb3QgZG9lcyBub3QgeWV0IGNvbnRhaW4gZW5vdWdoIGluZm9ybWF0aW9uIHRv IHNhZmVseSBjb25zdWx0CnN0YXRpc3RpY3MuCgpPbmUgZXhjZXB0aW9uIGlzIFN1YlBsYW4gbm9k ZXMgYnVpbHQgZm9yIHRoZSBpbml0cGxhbnMgb2YgTUlOL01BWAphZ2dyZWdhdGVzIGZyb20gaW5k ZXhlcy4gIEluIHRoaXMgY2FzZSwgaGF2aW5nIGEgTlVMTCByb290IGlzIHNhZmUKYmVjYXVzZSB0 ZXN0ZXhwciB3aWxsIGJlIE5VTEwuICBBZGRpdGlvbmFsbHksIGFuIGluaXRwbGFuIHdpbGwgYnkK ZGVmaW5pdGlvbiBub3QgY29uc3VsdCBhbnl0aGluZyBmcm9tIHRoZSBwYXJlbnQgcGxhbi4KCkJh Y2twYXRjaCB0byBhbGwgc3VwcG9ydGVkIGJyYW5jaGVzLiAgQWx0aG91Z2ggdGhlIHJlcG9ydGVk IGNhbGwgcGF0aAp0aGF0IHRyaWdnZXJzIHRoaXMgZXJyb3IgaXMgbm90IHJlYWNoYWJsZSBwcmlv ciB0byB2MTcsIHRoZXJlJ3Mgbm8KZ3VhcmFudGVlIHRoYXQgb3RoZXIgY29kZSBwYXRocyAtLSBl c3BlY2lhbGx5IGluIGV4dGVuc2lvbnMgLS0gY291bGQKbm90IGVuY291bnRlciB0aGUgc2FtZSBp c3N1ZSB3aGVuIGNvc3RfcXVhbF9ldmFsKCkgaXMgY2FsbGVkIHdpdGggYQpyb290IHRoYXQgbGFj a3MgYSB2YWxpZCBzaW1wbGVfcmVsX2FycmF5LiAgVGhlIHRlc3QgY2FzZSBpcyBub3QKaW5jbHVk ZWQgaW4gcHJlLXYxNyBicmFuY2hlcyB0aG91Z2guCgpCdWc6ICMxOTAzNwpSZXBvcnRlZC1ieTog QWxleGFuZGVyIExha2hpbiA8ZXhjbHVzaW9uQGdtYWlsLmNvbT4KRGlhZ25vc2VkLWJ5OiBUb20g TGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+CkF1dGhvcjogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51 eEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+CkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTkwMzctM2QxYzdiYjU1M2M3Y2U4NEBwb3N0 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTMKCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NU QUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvYWI0YTM1YjRlYTlkMjI5MGIxZWU1ZWMyNWY2NWRmNGM3MzkwNzdjYgoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUu YyAgIHwgMTggKysrKysrKysrKysrKysrKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vi c2VsZWN0Lm91dCB8IDE5ICsrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv c3Vic2VsZWN0LnNxbCAgICAgIHwgIDkgKysrKysrKysrCjMgZmlsZXMgY2hhbmdlZCwgNDQgaW5z ZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============8136934144765542029==--