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
-
Fix inability to reference CYCLE column from inside its CTE.
- ea5ae4cae6a2 14.7 landed
- ae98debf77d4 15.2 landed
- 935277b24172 16.0 landed