Re: Different results between Oracle 8.1.7 and 9.2

"Nicolas Bronke" <Nicolas_bronke_at_web.de> wrote in message news:<2gsfn8F6acq1U1_at_uni-berlin.de>...
> we came to an intesting point. We found out that we got on a 8.1.7 and 9.2
> database different results in a query using a subselect in a where condition
> like
>
> SELECT REFISO.ISO FROM REFISO WHERE REFISO.ISO NOT IN ( SELECT AMRATE.ISO
> FROM AMRATE WHERE 'X' = 'Y')
>
> SELECT REFISO.ISO FROM REFISO WHERE REFISO.ISO NOT IN ( SELECT AMRATE.ISO
> FROM AMRATE WHERE ISO = 'Y')
>
>
> First returns on 9i no records the second the complete set of the table
> REFISO, what we also exxpected with first sql statement.
> Using 8.1.7 database both queries returns the same result set.
>
>
> Now we had a discussion with different colleques and they did not believe it
> until they have sawn it.
>
> What is what we haven recognized during the switch from 8.7 to 9i?
>
> Thanks for any comments
> Nicolas

My guess is that AMRATE.ISO is defined as nullable on 9.2 and not null on 8.7

Dario Received on Tue May 18 2004 - 01:13:07 CDT