Failed assertion in joininfo.c, remove_join_clause_from_rels

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org, Alexander Korotkov <akorotkov(at)postgresql(dot)org>
Subject: Failed assertion in joininfo.c, remove_join_clause_from_rels
Date: 2023-12-27 11:54:22
Message-ID: 878r5famj5.fsf@ansel.ydns.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2023-12-27 11:58:26 Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals
Previous Message Jelte Fennema-Nio 2023-12-27 11:48:40 Should we remove -Wdeclaration-after-statement?