Re: right join with partitioned table crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: right join with partitioned table crash
Date: 2021-09-17 19:42:59
Message-ID: 1402882.1631907779@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby <pryzby(at)telsasoft(dot)com> writes:
> On Wed, Sep 15, 2021 at 07:53:49PM -0400, Tom Lane wrote:
>> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
>>> Here's another crash caught by sqlsmith.

>> Fun. Looks like it fails back to v12, but not in v11,
>> so it's some optimization we added in v12 that's at fault.

> It seems to be a regression (?) in 12.6 (2021-02-11), from
> | 1cce024fd2 Fix pull_varnos' miscomputation of relids set for a PlaceHolderVar.

Yeah, that patch still had a hole in it. Fix pushed,
thanks for the report!

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2021-09-17 19:53:48 Re: initdb --pwfile /dev/zero
Previous Message Tom Lane 2021-09-17 18:53:02 Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert