Bug Report

I have found in Oracle 8.1.6 that the following code will run in PL/SQL

SELECT field1
FROM table1
WHERE field1 IN (

     SELECT field1
     FROM table1
     MINUS
     SELECT field1
     FROM table2)

Even if field1 does not exist in table2.

Be very very careful.

Daniel A. Morgan Received on Wed Jan 24 2001 - 23:09:25 CST