[sqlsmith] Failed assertion in postgres_fdw/deparse.c:1116

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [sqlsmith] Failed assertion in postgres_fdw/deparse.c:1116
Date: 2016-06-05 14:01:03
Message-ID: 87h9d7pwf4.fsf@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Creating some foreign tables via postgres_fdw in the regression db of
master as of de33af8, sqlsmith triggers the following assertion:

TRAP: FailedAssertion("!(((((const Node*)(var))->type) == T_Var))", File: "deparse.c", Line: 1116)

gdb says var is holding a T_PlaceHolderVar instead. In a build without
assertions, it leads to an error later:

ERROR: cache lookup failed for type 0

Recipe:

--8<---------------cut here---------------start------------->8---
create extension postgres_fdw;
create server myself foreign data wrapper postgres_fdw;
create schema fdw_postgres;
create user mapping for public server myself options (user :'USER');
import foreign schema public from server myself into fdw_postgres;
select subq_0.c0 as c0 from
(select 31 as c0 from fdw_postgres.a as ref_0
where 93 >= ref_0.aa) as subq_0
right join fdw_postgres.rtest_vview5 as ref_1
on (subq_0.c0 = ref_1.a )
where 92 = subq_0.c0;
--8<---------------cut here---------------end--------------->8---

regards,
Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-06-05 14:16:14 Re: [sqlsmith] Failed assertion in joinrels.c
Previous Message Tatsuo Ishii 2016-06-05 13:11:10 Re: Statement timeout