Re: right join with partitioned table crash - Mailing list pgsql-hackers

From Tom Lane
Subject Re: right join with partitioned table crash
Date
Msg-id 1402882.1631907779@sss.pgh.pa.us
Whole thread Raw
In response to right join with partitioned table crash  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> On Wed, Sep 15, 2021 at 07:53:49PM -0400, Tom Lane wrote:
>> Jaime Casanova <jcasanov@systemguards.com.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Next
From: Tom Lane
Date:
Subject: Re: initdb --pwfile /dev/zero