From: Andreas Seltenreich <seltenreich@gmx.de>
To: pgsql-hackers@postgresql.org
Subject: [sqlsmith] ERROR: plan should not reference subplan's variable
Date: Fri, 01 Jul 2016 21:31:46 +0200
Message-ID: <874m89rw7x.fsf@credativ.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Updating master from f8c5855..1bdae16, sqlsmith triggers "failed to
generate plan" errors again. Below is the smallest query logged so far.
regards,
Andreas
-- ERROR: plan should not reference subplan's variable
set force_parallel_mode = 'on';
set max_parallel_workers_per_gather = '1';
explain WITH
jennifer_0 AS (select
(select b from public.rtest_v1 limit 1 offset 5)
as c0,
pg_catalog.pg_current_xlog_location() as c1,
sample_0.a as c2,
sample_0.a as c3
from
public.rtest_view4 as sample_0 tablesample system (5.9)
where cast(null as bigint) = pg_catalog.hashinet(
cast((select client_addr from pg_catalog.pg_stat_activity limit 1 offset 35)
as inet))
limit 76)
select
ref_0.sl_name as c0
from
public.shoelace as ref_0
where (cast(null as anyrange) < cast(null as anyrange))
and (EXISTS (
select
39 as c0
from
jennifer_0 as ref_1
where cast(null as real) = cast(null as real)
limit 81))
limit 96;
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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: <874m89rw7x.fsf@credativ.de>
* 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