BUG #17723: cache lookup failed for type 0

The Post Office <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: vik@postgresfriends.org
Date: 2022-12-16T15:38:04Z
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17723
Logged by:          Vik Fearing
Email address:      vik@postgresfriends.org
PostgreSQL version: Unsupported/Unknown
Operating system:   Ubuntu
Description:        

This query:

WITH RECURSIVE

run(x, y) AS (
  SELECT 0, 0
  UNION ALL
  SELECT x, y FROM run AS r WHERE r.is_cycle
)
CYCLE x, y SET is_cycle USING path

TABLE run
;

in which I mistakenly tried to access the is_cycle column from inside the
wle, provokes the following error:

ERROR:  XX000: cache lookup failed for type 0
LOCATION:  typeOrDomainTypeRelid, parse_type.c:699

Even though I did not need to add that WHERE clause because the CYCLE clause
does it for me, I still should have been able to.  And in any case, I should
not have received an XX000 error.

Commits

  1. Fix inability to reference CYCLE column from inside its CTE.