EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails

Поиск
Список
Период
Сортировка
От torikoshia
Тема EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails
Дата
Msg-id 5bafa66ad529e11860339565c9e7c166@oss.nttdata.com
обсуждение исходный текст
Ответы Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

While working on [1], we found that EXPLAIN(VERBOSE) to CTE with SEARCH 
BREADTH FIRST ends up ERROR.

This can be reproduced at the current HEAD(4c3478859b7359912d7):

   =# create table graph0( f int, t int, label text);
   CREATE TABLE

   =# insert into graph0 values (1, 2, 'arc 1 -> 2'),(1, 3, 'arc 1 -> 
3'),(2, 3, 'arc 2 -> 3'),(1, 4, 'arc 1 -> 4'),(4, 5, 'arc 4 -> 5');
   INSERT 0 5

   =# explain(verbose) with recursive search_graph(f, t, label) as (
       select * from graph0 g
       union all
       select g.*
       from graph0 g, search_graph sg
       where g.f = sg.t
   ) search breadth first by f, t set seq
   select * from search_graph order by seq;
   ERROR:  failed to find plan for CTE sg

Is this a bug?


[1] 
https://www.postgresql.org/message-id/flat/cf8501bcd95ba4d727cbba886ba9eea8@oss.nttdata.com

Regards,

--
Atsushi Torikoshi
NTT DATA CORPORATION



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

Предыдущее
От: torikoshia
Дата:
Сообщение: Re: RFC: Logging plan of the running query
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Estimating HugePages Requirements?