From: | Andreas Seltenreich <seltenreich(at)gmx(dot)de> |
---|---|
To: | Peter Geoghegan <pg(at)heroku(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [sqlsmith] Failing assertions in spgtextproc.c |
Date: | 2015-12-19 06:04:09 |
Message-ID: | 877fkbgejq.fsf@credativ.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Geoghegan writes:
> Can you do this?:
>
> (gdb) p debug_query_string
output below. Since sqlsmith ist no longer restricted to read-only
statements, the chances for reproduction are low :-/.
select
pg_catalog.pg_stat_get_buf_written_backend() as c0,
subq_1.c0 as c1,
subq_1.c0 as c2,
subq_1.c0 as c3
from
(select
(select ordinal_position from information_schema.parameters limit 1 offset 12)
as c0,
ref_2.t as c1
from
public.radix_text_tbl as ref_2
inner join pg_catalog.pg_stat_activity as ref_3
on (ref_2.t = ref_3.application_name )
where ref_2.t @@ cast(coalesce(ref_2.t, ref_3.client_hostname) as text)
limit 111) as subq_1,
lateral (select
subq_1.c0 as c0,
subq_2.c2 as c1,
56 as c2,
cast(coalesce(cast(coalesce((select pop from public.real_city limit 1 offset 34)
, subq_1.c0) as integer), subq_2.c0) as integer) as c3,
74 as c4,
(select unique1 from public.onek2 limit 1 offset 17)
as c5
from
(select
(select ordinal_position from information_schema.parameters limit 1 offset 27)
as c0,
sample_2.umoptions as c1,
sample_2.umserver as c2
from
pg_catalog.pg_user_mapping as sample_2 tablesample system (6.2)
where 49 is NULL) as subq_2
where cast(coalesce(subq_1.c0, subq_2.c0) as integer) is not NULL
limit 105) as subq_3
where ((select x from public.tt0 limit 1 offset 12)
<= subq_3.c0)
and (subq_3.c4 <= 30);
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2015-12-19 07:59:14 | Re: pg_tables bug? |
Previous Message | Pavel Stehule | 2015-12-19 05:55:46 | Re: [patch] Proposal for \rotate in psql |