Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 7 Sep 2023 18:46:43 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Lepikhov Andrei <a.lepikhov@postgrespro.ru>
Cc: Richard Guo <guofenglinux@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	fuboat@outlook.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT
 statement with WITH clause
Message-ID: <ZPmcAwVO4qO4z5T5@paquier.xyz>
References: <18077-b9db97c6e0ab45d8@postgresql.org>
 <CAMbWs4-4mDc9j5t+d3MbOSFSTqCDAHQKVV8zE8yiwsaXFGHL9Q@mail.gmail.com>
 <CAMbWs4_zxFFSy8+6-FG2ZdJc91TQGM+yG0Yh7gydhjTQfb=9fg@mail.gmail.com>
 <694541.1693600870@sss.pgh.pa.us>
 <CAMbWs49PRmEWmR0BKG-r8Me0kwr1iLo96diFenhtHYGCvcGgvw@mail.gmail.com>
 <1237514.1693879473@sss.pgh.pa.us>
 <CAMbWs4_i5+xB1WQ5SVOe8SQscaMswx8hbbgA1YKmtAD-vgcxnA@mail.gmail.com>
 <3f7bcdb7-c263-4c06-a138-140f5c3898ed@app.fastmail.com>
 <CAMbWs481eExv88QMG1p18sFyjRxvLfiiOHA+OoJYssPcx5ap+w@mail.gmail.com>
 <3933834e-b657-4ad1-bf4e-5f3fbba7ba14@app.fastmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="y9uAKX4aLZNHTj9M"
Content-Disposition: inline
In-Reply-To: <3933834e-b657-4ad1-bf4e-5f3fbba7ba14@app.fastmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZPmcAwVO4qO4z5T5%40paquier.xyz>
Precedence: bulk


--y9uAKX4aLZNHTj9M
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Sep 07, 2023 at 03:25:36PM +0700, Lepikhov Andrei wrote:
> I invented a dummy extension "pg_extension" [1], commit 4199a0c,
> which adds  CustomScan over the first non-parameterized HashJoin at
> the pathlist.=20
> The example presented in my letter earlier causes the ERROR on
> CTE. Moreover, if you remove the word 'materialized', you will find
> the same error on Subquery.
>=20
> [1] https://github.com/danolivo/pg_extension/tree/main

Digressing a bit here about this point..  In the long-term I think
that it would be a good idea to have a template module in
src/test/modules/ that shows how to use a CustomScan so as it is able
to demonstrate how this stuff works, and to check if it is works as
intended.  With regression tests, of course.
--
Michael

--y9uAKX4aLZNHTj9M
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmT5nAMACgkQnvQgOdby
QH0tOxAAmyShYFJjzJJA9DBFecLkyLy5WkTkXPykErkHSllbic0mkmwWtB/GTh37
Lr1NEOZPZ27Jk33qoqqFiGWouwjRQmyFRAFio4QQb2XAI+whHPGJFqWH2BeKoOMR
gdE1v7ApBc484SqHvcbbI1XnfWcSOmcHTsf29qt4H3kWp+rxlNil3Z5z0CgBstHl
/fcTsvcavRv5HPsRTFkhbmMLojmZIuNmWVzSId1SRQGER7fCZR2rNwVZWppaAGtM
WgRv8F+upSCjlIc2ETMVs7F1qWluLHK9lIo/DbCdy4rLd2APSozuxv/Qan8/Zj5r
UK12bYgtn10gevrk86W1PtScihCwgI0yeV+BULedREw8V10A96c/Q2tJSQcTN0FA
LV2XAcyuDBG10DcvmII+xul3YrdAeKMhSLaDTYvPbHWMYsLzMxKeFXnFVp2NfkWj
yVd5rD/dNWhScs8D/FYT+DbRc3nukzvRBvwSRMWvkYcPpYJXB21Dht+i8ynXMG4r
eZaph1TiN/GdDrHu3cKWls67vRGAVZL0tt79eRgsI/mkPI4WJqYWazYWn7UxzJU/
dYfbvygxRWnAYFXsKj7fuhsYeXjVUtWySsrMPMiKmWvomnM9DoM4R5gjyPAsi3Y1
OfuMRJTZJ/j5+lxa9l0jtPLpqELUhQEExYgrIWUrv5cGFF93RKs=
=M5E6
-----END PGP SIGNATURE-----

--y9uAKX4aLZNHTj9M--