Bug in Oracle 9i query processing?

Hello,

This sample SQL script reproduces the problem...

create table A ( id int not null primary key ); create table B ( id int not null primary key );

• This query runs correctly select * from A where not exists (select * from B where id = A.id);
• This query fails to resolve the reference to A.id in the
• derived table expression. select * from A where not exists (select * from (select * from B where id = A.id) T1));

Has anyone seen this behavior? Am I doing something wrong? Can anyone confirm this to be a problem?

Thanks
Bryn Rhodes
Alphora Received on Thu May 09 2002 - 19:07:39 CEST