BUG #1854: SQL Bug

The following bug has been logged online:

Bug reference: 1854
Logged by: Christian Almeida
Email address: cbalmeida(at)gmail(dot)com
PostgreSQL version: 8.0
Operating system: Windows XP SP2
Description: SQL Bug
Details:

Should this sql work?

I just picked 3 tables from pg_catalog and build this query. It really
should not work, because there's a reference to a table
(PG_CATALOG.PG_CLASS) wich is not listed in any from clauses.

Try it yourself:

SELECT
*
FROM
PG_CATALOG.PG_AM
WHERE
NOT EXISTS
(
SELECT
1
FROM
PG_CATALOG.PG_CAST
WHERE
PG_CATALOG.PG_CLASS.RELOWNER = PG_CATALOG.PG_AM.AMOWNER
)

Cheers,

Christian Almeida.

SELECT
*
FROM
PG_CATALOG.PG_AM
WHERE
NOT EXISTS
(
SELECT
1
FROM
PG_CATALOG.PG_CAST
WHERE
PG_CATALOG.PG_CLASS.RELOWNER = PG_CATALOG.PG_AM.AMOWNER
)