Left join bug?

Hi,

create table a (num integer)
create table b (num integer)

insert into a values (1)
insert into b values (2)

select * from a left join b

       on b.num = 123
       where a.num = 1 and b.num is null

MySQL & Oracle 10i show the following result: 1 null

Oracle 9.2.0.1 shows:
Empty result set

Is this a bug of Oracle 9,2.0.1?
Any workaround? Received on Fri Aug 03 2007 - 06:10:09 CDT