From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?=
 <n.kalinin@postgrespro.ru>
cc: =?UTF-8?B?TWljaGFlbCBQYXF1aWVy?= <michael@paquier.xyz>,
        pgsql-bugs@lists.postgresql.org,
        =?UTF-8?B?UGllcnJlIEZvcnN0bWFubg==?= <pierre.forstmann@gmail.com>
Subject: Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS
 subquery and DO_NOT_SCAN advice
In-reply-to: <1779843554.737126560@fmail2.qdit>
References: <19493-5878eac7a2525c23@postgresql.org>
 <2d59d7d6-6afe-4565-8ff7-ae764651589a@gmail.com>
 <ahY_s6GLOGoceXHT@paquier.xyz> <1779843554.737126560@fmail2.qdit>
Comments: In-reply-to =?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?=
 <n.kalinin@postgrespro.ru>
	message dated "Wed, 27 May 2026 03:59:14 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <418105.1779844099.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 26 May 2026 21:08:19 -0400
Message-ID: <418106.1779844099@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/418106.1779844099%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?=3D <n.kalinin@postgrespr=
o.ru> writes:
> Could this be related to GCC? I'm using GCC 16.1.1 and I can reproduce t=
he crash with that version.

Maybe.  Does it still fail if you set the optimization level to -O0 ?

			regards, tom lane