Re: right join with partitioned table crash

2021-09-17 Thread Tom Lane
Justin Pryzby writes: > On Wed, Sep 15, 2021 at 07:53:49PM -0400, Tom Lane wrote: >> Jaime Casanova 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 reg

Re: right join with partitioned table crash

2021-09-15 Thread Justin Pryzby
On Wed, Sep 15, 2021 at 07:53:49PM -0400, Tom Lane wrote: > Jaime Casanova 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

Re: right join with partitioned table crash

2021-09-15 Thread Tom Lane
Jaime Casanova 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.)