Re: Q+E Corrupting Numbers in Oracle Database
From: Tim Bunce <Tim.Bunce_at_ig.co.uk>
Date: 1995/07/25
Message-ID: <DCA8xp.8A2_at_ig.co.uk>#1/1
Date: 1995/07/25
Message-ID: <DCA8xp.8A2_at_ig.co.uk>#1/1
In article <3v1tem$a50_at_news.onramp.net>, <jschmidt_at_onramp.net> wrote:
> I have found Q+E is capable of corrupting number fields in an Oracle
> Database. [...]
>
> I guess that Q+E is using native number format (as opposed to coercing to int, float, or double)
> and getting it close, but not spot on. any arbitrarily close range works
> such as
> select y from x where y > 99.999999999 and y < 100.000000001 but exact matches don't.
>
> In any event, you have been given the cause, a generic test for data
> corruption and a fix.
>
Thanks. I hope you've also given this info to Intersolve!
Will they be releasing a patch?
Tim. Received on Tue Jul 25 1995 - 00:00:00 CEST