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