pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andreas Seltenreich <seltenreich@gmx.de>
To: pgsql-hackers@postgresql.org
Subject: [sqlsmith] ERROR:  plan should not reference subplan's variable
Date: Sat, 11 Aug 2018 17:45:43 +0200
Message-ID: <87va8g7vq0.fsf@ansel.ydns.eu> (raw)

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;




view thread (6+ messages)  latest in thread

Message-ID: <87va8g7vq0.fsf@ansel.ydns.eu>
Permalink:  ../87va8g7vq0.fsf@ansel.ydns.eu/
Also on:    postgresql.org/message-id/87va8g7vq0.fsf@ansel.ydns.eu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: seltenreich@gmx.de
  Subject: Re: [sqlsmith] ERROR:  plan should not reference subplan's variable
  In-Reply-To: <87va8g7vq0.fsf@ansel.ydns.eu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox