From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Zhidenkov <pensnarik@gmail.com>
cc: Heikki Linnakangas <hlinnaka@iki.fi>, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19108: Stack overflow duting query parse
In-reply-to: 
 <CAN=gQ4DQKP+Hb+a57SKE9_g2_Utumfccacc9pnw9Okpr6RwVrQ@mail.gmail.com>
References: <19108-13b9dd7a2d30a9cc@postgresql.org>
 <e7c2340a-3a01-4095-b606-0e8e77384084@iki.fi>
 <CAN=gQ4DQKP+Hb+a57SKE9_g2_Utumfccacc9pnw9Okpr6RwVrQ@mail.gmail.com>
Comments: In-reply-to Andrey Zhidenkov <pensnarik@gmail.com>
	message dated "Mon, 10 Nov 2025 16:23:53 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1879800.1762790568.1@sss.pgh.pa.us>
Date: Mon, 10 Nov 2025 11:02:48 -0500
Message-ID: <1879801.1762790568@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1879801.1762790568%40sss.pgh.pa.us>
Precedence: bulk

Andrey Zhidenkov <pensnarik@gmail.com> writes:
>> Can you create a self-contained SQL script to reproduce this, and post it
>> on this thread with reply-all, please?

> Unfortunately, I cannot reproduce the issue even on an existing 15.7
> node (one that hasn't upgraded) (don't know if it matters, but now it's a
> hot standby node) but there are core dumps and debug info packages
> installed so I can provide more data from core dump.

Could you at least provide a not-mangled-to-the-point-of-incorrectness
version of the query?  The posted one fails with

ERROR:  table name "tablename_v2" specified more than once

and there are other visible bugs in it.  Some clarity about the column
data types would be helpful as well.

			regards, tom lane