Re: [sqlsmith] Failing assertions in spgtextproc.c

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