pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST 2+ messages / 2 participants [nested] [flat]
* BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST @ 2022-10-16 16:50 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2022-10-16 16:50 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: postgresql@zr40.nl The following bug has been logged on the website: Bug reference: 17644 Logged by: Matthijs van der Vleuten Email address: postgresql@zr40.nl PostgreSQL version: 14.5 Operating system: Debian 11.5 Description: The following query causes EXPLAIN VERBOSE to raise an error. EXPLAIN VERBOSE WITH RECURSIVE test AS ( SELECT 1 AS x UNION ALL SELECT x+1 FROM test ) SEARCH BREADTH FIRST BY x SET y SELECT * FROM test LIMIT 10; ERROR: record type has not been registered EXPLAIN without VERBOSE, and the query itself, do not raise an error. Also, the error does not appear when using SEARCH DEPTH FIRST. Reproduced on 14.5 and 15.0. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST @ 2022-10-16 23:21 Tom Lane <tgl@sss.pgh.pa.us> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-10-16 23:21 UTC (permalink / raw) To: postgresql@zr40.nl; +Cc: pgsql-bugs@lists.postgresql.org PG Bug reporting form <noreply@postgresql.org> writes: > The following query causes EXPLAIN VERBOSE to raise an error. > EXPLAIN VERBOSE > WITH RECURSIVE test AS ( > SELECT 1 AS x > UNION ALL > SELECT x+1 > FROM test > ) SEARCH BREADTH FIRST BY x SET y > SELECT * FROM test LIMIT 10; > ERROR: record type has not been registered Thanks for the report! We'd fixed some closely-related cases during v14 beta, but nobody stumbled on this one. The key point seems to be using all constants in the non-recursive term's SELECT list. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-10-16 23:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-10-16 16:50 BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST PG Bug reporting form <noreply@postgresql.org> 2022-10-16 23:21 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox