Failed assertion in joininfo.c, remove_join_clause_from_rels - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject Failed assertion in joininfo.c, remove_join_clause_from_rels
Date
Msg-id 878r5famj5.fsf@ansel.ydns.eu
Whole thread Raw
Responses Re: Failed assertion in joininfo.c, remove_join_clause_from_rels
List pgsql-hackers
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 null and exists (select);

-- TRAP: failed Assert("list_member_ptr(rel->joininfo, restrictinfo)"), File: "joininfo.c", Line: 144, PID: 777839

regards,
Andreas



pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Should we remove -Wdeclaration-after-statement?
Next
From: Richard Guo
Date:
Subject: Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals