[sqlsmith] ERROR: plan should not reference subplan's variable

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [sqlsmith] ERROR: plan should not reference subplan's variable
Date: 2018-08-11 15:45:43
Message-ID: 87va8g7vq0.fsf@ansel.ydns.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

sqlsmith caused another internal error while testing REL_11_STABLE at
1b9d1b08fe. The query below on the regression DB yields "plan should
not reference subplan's variable" for me.

regards,
Andreas

delete from public.prt1_l
where
EXISTS (
select
from
public.xmltest as ref_10 ,
lateral (select
ref_10.data as c0
from
public.radix_text_tbl as ref_0,
lateral (select
ref_11.name as c0
from
public.equipment_r as ref_11
limit 134) as subq_0
limit 110) as subq_1
where public.prt1_l.c is NULL)
returning 42;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-08-11 17:18:26 NetBSD vs libxml2
Previous Message Fabien COELHO 2018-08-11 14:42:16 Re: libpq connection timeout mismanagement