Re: Failed assertion in joininfo.c, remove_join_clause_from_rels

2023-12-27 Thread Alexander Korotkov
On Wed, Dec 27, 2023 at 2:04 PM Richard Guo wrote: > On Wed, Dec 27, 2023 at 8:00 PM Alexander Korotkov > wrote: >> >> On Wed, Dec 27, 2023 at 1:54 PM Andreas Seltenreich >> wrote: >> > SQLsmith found a failing Assertion in joininfo.c on master. I can >> > reproduce it on an

Re: Failed assertion in joininfo.c, remove_join_clause_from_rels

2023-12-27 Thread Richard Guo
On Wed, Dec 27, 2023 at 8:00 PM Alexander Korotkov wrote: > On Wed, Dec 27, 2023 at 1:54 PM Andreas Seltenreich > wrote: > > SQLsmith found a failing Assertion in joininfo.c on master. I can > > reproduce it on an assertion-enabled build like this: > > > > create table t1(a int primary key); >

Re: Failed assertion in joininfo.c, remove_join_clause_from_rels

2023-12-27 Thread Alexander Korotkov
On Wed, Dec 27, 2023 at 1:54 PM Andreas Seltenreich wrote: > SQLsmith found a failing Assertion in joininfo.c on master. I can > reproduce it on an assertion-enabled build like this: > > create table t1(a int primary key); > create table t2(a int); > > select * from t2 right join > (t1

Failed assertion in joininfo.c, remove_join_clause_from_rels

2023-12-27 Thread Andreas Seltenreich
Hi, SQLsmith found a failing Assertion in joininfo.c on master. I can reproduce it on an assertion-enabled build like this: create table t1(a int primary key); create table t2(a int); select * from t2 right join (t1 as t1a inner join t1 as t1b on t1a.a = t1b.a) on t1a.a is not