Re: [sqlsmith] Failing assertions in spgtextproc.c

Поиск
Список
Период
Сортировка
От Andreas Seltenreich
Тема Re: [sqlsmith] Failing assertions in spgtextproc.c
Дата
Msg-id 877fkbgejq.fsf@credativ.de
обсуждение исходный текст
Ответ на Re: [sqlsmith] Failing assertions in spgtextproc.c  (Peter Geoghegan <pg@heroku.com>)
Ответы Re: [sqlsmith] Failing assertions in spgtextproc.c  (Andres Freund <andres@anarazel.de>)
Список 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
asc1     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)
limit111) as subq_1, lateral (select       subq_1.c0 as c0,       subq_2.c2 as c1,       56 as c2,
cast(coalesce(cast(coalesce((selectpop 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
offset17)as c5     from       (select             (select ordinal_position from information_schema.parameters limit 1
offset27)as c0,             sample_2.umoptions as c1,             sample_2.umserver as c2           from
pg_catalog.pg_user_mappingas 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);



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [patch] Proposal for \rotate in psql
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: pg_tables bug?