| From: | torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> | 
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails | 
| Date: | 2021-09-07 03:41:02 | 
| Message-ID: | 5bafa66ad529e11860339565c9e7c166@oss.nttdata.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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?
Regards,
--
Atsushi Torikoshi
NTT DATA CORPORATION
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2021-09-07 04:00:08 | Re: Estimating HugePages Requirements? | 
| Previous Message | torikoshia | 2021-09-07 03:39:46 | Re: RFC: Logging plan of the running query |