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 1ubWlB-001vs9-8M for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 03:55:17 +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 1ubWl9-00GqT4-AJ for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 03:55:15 +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 1ubWl9-00GqSw-1T for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 03:55:15 +0000 Received: from fout-a4-smtp.messagingengine.com ([103.168.172.147]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1ubWl5-007LIq-1p for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 03:55:13 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfout.phl.internal (Postfix) with ESMTP id CB38CEC01B1; Mon, 14 Jul 2025 23:55:10 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Mon, 14 Jul 2025 23:55:10 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1752551710; x=1752638110; bh=whLfHGUeHq A7ZK/AVMfZF3YK9lxbUlE55PpEKrJeUO0=; b=SaFszV2SZQ58JHXnV8rzralsMV D7qbaqfR9HbKkgLl9f03eJMKRunCylYnecPGsOPkXuk+CvRClTwwXnlI8AwNWMVC gBcsfnj6PDCfPGrrtUQ8iMrFG+xvsgHvyGxl5m019aJbQ9hQMlrF9fXXYdwAgY0f F/L1n5Ukj2RbeboWBTmO/oiY9c1TKcBTxG0H0e2zM+0g2o5NF3dUy2es5mrCCSus qzkx55wUzdboTWCLpNxl7Ux3DeO5CB0IkzvLeAUbHn5dzQJEpDjspzdiu4BtWg1G uNAcP5tSmV/wVr9m4Xx65OKRtLexdoGFw2yCkqmrzM7VS/kbJrZ2RNQZXEWg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1752551710; x=1752638110; bh=whLfHGUeHqA7ZK/AVMfZF3YK9lxbUlE55Pp EKrJeUO0=; b=aFfL3w0oOwW/CIv99KI4yaxq6aZFo1XLuGof2915hyulk8Enw4e FKm7PsrA4rrvg+rQj9DsA6CmVezZ+M+sqMDozCqJBTzqzDoTSXtmDh38ayDDGnDo kvccofkADIFbr5y8yfwxaCZCzPgcnM+8haDGwr5gk+BSJU9kJilvWJ81dzAGBYrl FYN6XLEMGwGUEWjzqj1m3oUhFXBaKC/65G3IDF4H+QlRj5x0oDeWxbOpIdtBnTuW Z1MXv/Cj2YaPHGnlQYGlwV0fot0g8in02xywySFIP/5WOyYH7AQgRfrsQvx1nHXh W4ViTiyGlbaZ/+c48p6l/O080mVa1RMVIqw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdehfeekudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuf fkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgv rhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpe etleeifedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeenucev lhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvg hlsehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhp ohhuthdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtoh epvgigtghluhhsihhonhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdgs uhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 14 Jul 2025 23:55:09 -0400 (EDT) Date: Tue, 15 Jul 2025 12:54:46 +0900 From: Michael Paquier To: Tom Lane Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18984: Empty prepared statement from psql \parse triggers assert in PortalRunMulti Message-ID: References: <18984-0f4778a6599ac3ae@postgresql.org> <715434.1752521761@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="rcb0Uq4E+gwFXFCe" Content-Disposition: inline In-Reply-To: <715434.1752521761@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --rcb0Uq4E+gwFXFCe Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jul 14, 2025 at 03:36:01PM -0400, Tom Lane wrote: > BTW, d55322b0d simply made it easy to trigger the bug from psql. > If I use current psql to connect to older servers, I can demonstrate > crashes (or sometimes "stack depth limit exceeded") back to v12. > Pre-v12 is immune because it just returns a command tag of EXECUTE > regardless of what is in the prepared statement. Oh. It's pretty cool to see that these new meta-commands are able to find such problems more easily. That was one of the reasons to have them in v18. -- Michael --rcb0Uq4E+gwFXFCe Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmh10QUACgkQnvQgOdby QH1t+A//fvBEgLF8fmBO9fluli1VqXkwyCO39UzoujL7UlqtSWjwpiILokgfr/AK FR++eehM7/Jh4bsFjZn1I134p3YM8I1aOsOAaePqMiKErEJYUCKJGBtn85U+yiHI gbN15lAL68N2ObHtr68PUuhRTmiNq/YzuP25dKgRsd661VKZ/GA2zPOzFafswRVj Efc0+l3EEZUAAO4JINtRqxuIfhbdmteDz5Nk+0kbpz7vPv0Wbqnwb8mL39MYgJ5v QGHTCM63O3fyChb1WE8a77aEZXBQz5KYNp2vw+Vd2ziFbDmp/thPp3BICpOdJDHA clANQRRajaeIC9A+5fDdv1zEL9A82y30+d0V3SaM6MWm7GZBKtiChrTt5AFq8CMi J7hSw85OalJQblT5K+pOFCs/SkCJj9ayVVeDlU8huRbf9ACbMsxZ+ZxPjyHrry0/ y/iqmpPh1Rj7LB5Rv5cuHcV8Zqw0/ysAS7RXA04q8s1ZJWAVLDxTyr49ObJiV+pq kQpA17r5WcKlgDg0qrwS2bf7YKIUPo0+PPnxvSD2KkAyJjiOnMicCRaJM40L02/H BDUZaKOrYggLXhvv9qWLI/c6oyqODWIwKyoyecbTiWpABPYeh/xtepp6459Pud1c jH4unU+kWtZtlhyJDbKTpl50s6DAcTwJKi9xi9AbuNKyj5/Qx6Q= =geR3 -----END PGP SIGNATURE----- --rcb0Uq4E+gwFXFCe--