Different results between Oracle 8.1.7 and 9.2

From: Nicolas Bronke <Nicolas_bronke_at_web.de>
Date: Mon, 17 May 2004 20:48:07 +0200
Message-ID: <2gsfn8F6acq1U1@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 Received on Mon May 17 2004 - 13:48:07 CDT