At 02:58 AM 12/28/2006, Nuno Souto wrote:
and that is precisely why there are so many shops out there running very old releases of Oracle and no plans whatsoever to upgrade. Because what they have now works. And they are virtually assured by Oracle when they upgrade the rdbms, the blessed thing WILL break their applications.
If that is the case then their applications ARE already broken, they just may not know it yet. And as Greg pointed out, the "brokenness" can become obvious at any moment even without an upgrade. Another popular application bug is to use the wrong datatype in predicates, e.g. character_column = 12345 and then come running when one day they get an ora-1722 error. "But it worked yesterday and I didn't change anything".
Oracle can not - and should not - cater to all possible application bugs out there. I'd be satisfied if they look after their own bugs - like the overzealous order by elimination ( point 3 in the OP ).
Regards Wolfgang Breitling Centrex Consulting Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
-- //www.freelists.org/webpage/oracle-l