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

right join with partitioned table crash

2021-09-15 Thread Jaime Casanova
Hi everyone, Here's another crash caught by sqlsmith. """ drop table if exists fkpart3_pk5 cascade; drop table if exists inet_tbl; create table fkpart3_pk5 ( a integer not null primary key ) partition by range (a); create table fkpart3_pk51 partition of fkpart3_pk5 for values from (