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 1uthVc-00CtcB-48 for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:02:21 +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 1uthVb-007fEM-2v for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:02:19 +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 1uthVa-007fEE-Q3 for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:02:19 +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 1uthVX-000J8P-24 for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:02:18 +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=KYxdzgIuV7Bg32mOqAsWwkQayBQHX1stuCCKvXBAIUA=; b=N1ApKdnBb/IJ1KurkquAAyMqS2 iQXBNiCn/L41Ikw2jv5gUcOCX2YPOy+Xq+6zAmW46DwPfN49ApcXDTzFxM6i90k2iBFhEKCs38sWY PPK+Y5ePiF82lQsBeplpHlU9Okal6akGkDBwp25IP+tN6juuXHY+mx1SNxDN0M/tu+be//qIGQz4h b89V8JvuAfwitItsz9TU4T4p1lfQgn0U4R+7b9B5VyLP5PSW9drffhn01IYIbIANxKTQdtbykXXVw XQTPAufqPypu2/vpytoLxJsn9NLAuPxJFnZqfOO3D+0bQK8ZP2b0uAZchzMh6kdG/NX0wF275om5A kI1oS5bQ==; 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 1uthVW-000o8S-LD for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:02:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uthVX-000GpE-1C for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:02:15 +0000 Content-Type: multipart/mixed; boundary="===============2235704160753580551==" 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:02:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2235704160753580551== 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 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTMKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9h YmE4ZjYxYzMwOTExY2JhYzFhMzEwYjdkMjE3NzdlMDQ3MTFjNjZlCgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgfCAx OCArKysrKysrKysrKysrKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdWJzZWxlY3Qu b3V0IHwgMTkgKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdWJzZWxl Y3Quc3FsICAgICAgfCAgOSArKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA0NCBpbnNlcnRpb25z KCspLCAyIGRlbGV0aW9ucygtKQoK --===============2235704160753580551==--