pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Lepikhov Andrei <a.lepikhov@postgrespro.ru>
Cc: Richard Guo <guofenglinux@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: fuboat@outlook.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18077: PostgreSQL server subprocess crashed by a SELECT statement with WITH clause
Date: Thu, 7 Sep 2023 18:46:43 +0900
Message-ID: <ZPmcAwVO4qO4z5T5@paquier.xyz> (raw)
In-Reply-To: <3933834e-b657-4ad1-bf4e-5f3fbba7ba14@app.fastmail.com>
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>

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. 
> 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.
> 
> [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

Attachments:

  [application/pgp-signature] signature.asc (832B, ../ZPmcAwVO4qO4z5T5@paquier.xyz/2-signature.asc)
  download

view thread (16+ messages)  latest in thread

Message-ID: <ZPmcAwVO4qO4z5T5@paquier.xyz>
Permalink:  ../ZPmcAwVO4qO4z5T5@paquier.xyz/
Also on:    postgresql.org/message-id/ZPmcAwVO4qO4z5T5@paquier.xyz

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: michael@paquier.xyz, a.lepikhov@postgrespro.ru, guofenglinux@gmail.com, 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
  In-Reply-To: <ZPmcAwVO4qO4z5T5@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox