Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Different results between Oracle 8.1.7 and 9.2
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
![]() |
![]() |