Oracle 10 is not stable and the kernel of the database engine contains
a critical BUG : the result of a select can invert two columns compared
to the request. The same code in oracle 9 do not produce the BUG. In
order to reproduce this BUG, 2 select must load most of the columns of
one table. The exact conditions are not published by ORACLE but
potentially, it concerns all the Oracle 10 client application except
light internet applications that do not use the kernel optimisation
functionalities.
This problem was discovered on November 2004 and the oracle BUG created
in March 2005 and now it is corrected since July 2006. Compared to the
high impact of the BUG, the correction time has been very long whereas
some major clients were impacted. It seems that ORACLE is undergoing
big difficulties with the 10 version which explains the very long delay
for correction. The attempt from ORACLE development team to disconnect
the faulty optimisation function did not succeed and the whole function
had to be analysed.
If you encounter the problem, let me know.
Received on Mon Jul 25 2005 - 11:44:55 CDT
