Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Different results between Oracle 8.1.7 and 9.2

Re: Different results between Oracle 8.1.7 and 9.2

From: Dario <drga59_at_hotmail.com>
Date: 17 May 2004 23:13:07 -0700
Message-ID: <e409f463.0405172213.1e6b6d1@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US