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 1uthdh-00CwC9-4x for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:10:42 +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 1uthdg-007jGu-BF for pgsql-committers@arkaria.postgresql.org; Wed, 03 Sep 2025 07:10:40 +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 1uthdg-007jGd-3r for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:10:40 +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 1uthde-000Hw7-2W for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:10:39 +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=+rFeLuwpEW9SbfNUKm1rM7ebS8tScZkn6a7u1+Wq1iY=; b=rocoffciuNReJnxDsKNP7HMMeL m7c9emgvthSnK/8mQ44dDcJkntK7ABFSwIp47rfYlGbjm7lGOJQuZtpw0yu1YKKXDIT6Tr9923yJA Z4PI5spz9Hp1RtDCdOgzZcfok9WFK3/O+2X+nK34wRfJbfpQgqgiqbROMaS1Vynuq+43Fg5TJ/CBX DmLnpBLJXP8vk3pv2Lu5ez4R0997PAWiPz9wg2Wje8C82tP/7QE70yhK6bzWapYU2vONpD+6ez+Wq W+B3dcXWNIOLKriBwRAbdUy2ZeHpcAKv+uBt7xsUzudDtLRhQAqfc2YNSax/K3Od8CGsqolWAFVPD 7WrHTJJw==; 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 1uthdd-000oJD-Oc for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:10:38 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uthde-000H2F-1d for pgsql-committers@lists.postgresql.org; Wed, 03 Sep 2025 07:10:38 +0000 Content-Type: multipart/mixed; boundary="===============6269156986199365916==" 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:10:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6269156986199365916== 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 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTMKCkJyYW5jaAotLS0tLS0KUkVMXzE2X1NU QUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvNzlhZGU1ODczMjMyYzVkZWEyMjUzNDVjNzhmMTYzMmMyMmNiYjA1YQoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUu YyB8IDE4ICsrKysrKysrKysrKysrKystLQoxIGZpbGUgY2hhbmdlZCwgMTYgaW5zZXJ0aW9ucygr KSwgMiBkZWxldGlvbnMoLSkKCg== --===============6269156986199365916==--