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
)