Message-ID: <8ed9ba8971e114c3d6325c50a5f9fb6984140a01.camel@cybertec.at>
Subject: Re: BUG #18806: When enable_rartitionwise_join is set to ON, the
 database shuts down abnormally
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: m_lingbin@126.com, pgsql-bugs@lists.postgresql.org
Date: Wed, 12 Feb 2025 08:38:34 +0100
In-Reply-To: <18806-d70b0c9fdf63dcbf@postgresql.org>
References: <18806-d70b0c9fdf63dcbf@postgresql.org>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/8ed9ba8971e114c3d6325c50a5f9fb6984140a01.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-02-12 at 07:01 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 17.2
> Operating system:=C2=A0=C2=A0 CentOS Linux release 7.9.2009 (Core)
> Description:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=20
>=20
> After upgrading PG17.2, testing found that when enable_rartitionwise_join=
 is
> set to ON, when executing a query, if the main query and subquery have th=
e
> same table, the query will report an error.
>=20
> The database log shows the following error:
> LOG:=C2=A0 server process (PID 24796) was terminated by signal 6: Aborted
> DETAIL:=C2=A0 Failed process was running: select * from test t join order=
s o on
> t.order_id =3Do.order_id where t.order_id in (select order_id from orders=
);
> LOG:=C2=A0 terminating any other active server processes

That is a crash that may well indicate a PostgreSQL bug.

However, without a way to reproduce the behavior, we won't be able to fix
the problem.  Try to come up with a self-contained test case.  It would
also be interesting to know which PostgreSQL extensions are present.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.