Horton

Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails

Andreas Joseph Krogh <andreas@visena.com>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreas@visena.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Andrew Dunstan <andrew@dunslane.net>, torikoshia <torikoshia@oss.nttdata.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2021-09-16T16:53:07Z
Lists: pgsql-hackers 
På torsdag 16. september 2021 kl. 01:40:31, skrev Tom Lane <tgl@sss.pgh.pa.us 
<mailto:tgl@sss.pgh.pa.us>>: 
[...]
 regression=# with recursive cte (x,r) as (
 select 42 as x, row(i, 2.3) as r from generate_series(1,3) i
 union all 
 select x, row((c.r).f1, 4.5) from cte c
 ) 
 select * from cte;
 ERROR: record type has not been registered 




FWIW; I saw this Open Item was set to fixed, but I'm still getting this error 
in 388726753b638fb9938883bdd057b2ffe6f950f5 

--
 Andreas Joseph Krogh

Commits

  1. Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.

  2. Fix EXPLAIN to handle SEARCH BREADTH FIRST queries.

  3. Message style improvements