BUG #1854: SQL Bug

The following bug has been logged online:

Bug reference:      1854
Logged by:          Christian Almeida
Email address:      cbalmeida@gmail.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
  )