Horton

Re: right join with partitioned table crash

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: pgsql-hackers@postgresql.org
Date: 2021-09-15T23:53:49Z
Lists: pgsql-hackers 
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.

(That being the case, this isn't a blocker for 14rc1,
though of course it'd be nice if we fix it in time for that.)

			regards, tom lane

Commits

  1. Fix pull_varnos to cope with translated PlaceHolderVars.