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 1uthn7-00CzFb-NS for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:20:26 +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 1uthn6-007n63-Lg for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:20:25 +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 1uthn6-007n5C-EL for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:20:24 +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 1uthmy-000JHK-0v for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:20:19 +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=bBZ2SokjoK8ajoCP/Hmf69NYhB/TTlUwKpa8hVN2Rxc=; b=wJ/jR7PhNAkc7KUmOENEL/n5y5 OZbmzZQC5SHf92Dp1emaTcR26kNzoTKzsGrILIN8ZG2g8lAv7hBALY610PmnTyLpAW90YMpCUvTc8 EVO5YbstmEZyuCzahujD1bC+HkzA3HiBF4sNbz0gEzNQqLBOLvGM5NaVzPvcsJw+gbqc4ISt6+fOJ moCmeTO+iTOGATfAJ2m0XORCg9UiJ4HXuUbgrG+fgCl27MlhwK5LZ+ysxiIU5k8oYrlnlN42HfLQQ QgLiZipjlIJt2ilRrJx9IqXd+nM5BM1hIZ00ToC2vu1SWkjZB3dFax3JLcbljgOcvP2stVwetaJ6J icgyiDqA==; 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 1uthmx-000oVG-DP for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:20:16 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uthmy-000H7d-0K for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:20:15 +0000 Content-Type: multipart/mixed; boundary="===============5617102405652988378==" 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:20:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5617102405652988378== 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 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTMKCkJyYW5jaAotLS0tLS0KUkVMXzEzX1NU QUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvOGMwMmQ5MmM2NDc1YzI0ODhmNmU2NGI5MDk2ZDgxMjcxMzY5MmY4MgoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUu YyB8IDE4ICsrKysrKysrKysrKysrKystLQoxIGZpbGUgY2hhbmdlZCwgMTYgaW5zZXJ0aW9ucygr KSwgMiBkZWxldGlvbnMoLSkKCg== --===============5617102405652988378==--