Re: Left join bug?

On Aug 3, 1:10 pm, joe <fischauto..._at_yahoo.de> wrote:
> 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?

I think that is only a different behaviour on a condition not defined. It seems to me that "b.num =123 " has no sense as join condition so optimizer as changed behaviour but in my opinion it is not possible to say this is a bug

regards

--
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com