Re: Strange issue after patching to 10.2.0.4 CPU 24
Date: Tue, 8 Dec 2009 10:35:29 -0800
On Mon, Dec 7, 2009 at 12:58 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:
> We went from 10.2.0.3 CPU 12 (I think it was) to 10.2.0.4 CPU 24 and
> discovered a bug I didnít know existed.
> If youíre using ANSI SQL in 10.2.0.3 prior to 10.2.0.4 CPU 2, ORA-00918
> Ambiguous Column may not get raised.
> After patching, youíll have code that starts failing if you failed to
> properly alias duplicate columns.
Ah, for lack of a better name, a "reverse effect bug"
This is a "bug" that rears it's head when only when Oracle fixes the bug, and code that would have previously been broken, but actually ran due to the bug, then stops working.
If someone has a better name, please chime in.
There's probably one already coined somewhere, I just haven't looked for it.
I recall a similar PL/SQL bug from several years ago when some in-house code started failing after a minor patch was applied, a patch that fixed a bug in the PL/SQL whereby an error message was not being raised.
Not unlike the situation you refer to.
In both cases the proper coding technique had long been documented, and apparently long ignored. :)Received on Tue Dec 08 2009 - 12:35:29 CST