Re: BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST - Mailing list pgsql-bugs

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