Re: Strange SQL Bug

jstander_at_ml.csiro.au (Jeff Stander) writes:

> My colleagues have discovered the following bug in V6.
> .

<stuff deleted>

> The output is;
>
> PREFX RESULT
> ----------------- -----------------
> 323168 / 323810 = .00
> 333168 / 333810 = 1.00
> 313168 / 313810 = 1.00
>
> Bizarre, eh?
>
> 1) Can anyone explain this?
Not directly but it sounds a lot like a bug Oracle UK listed in their Technical Bulletin in March 92. It was in kernel version 6.0.33 and is supposed to be fixed. To quote them:

'With RDBMS version 6.0.32/33 a COLUMN FORMAT or TO_CHAR can return incorrect results. The problem occurs when a rightmost 9 is rounded up. The number is rounded up but the decimal point location is not updated returning a value off by a power of 10'

Assuming that you're running a later release, it sounds like Oracle didnt manage to properly solve this problem.

> 2) Does this bug exist in V7? (Ours is not yet installed so I can't test it
> yet).
>

I havent even got it yet. Somehow Oracle seem not to tell us about new versions of software until we ask.

Regards

Ian

--
Ian Dixon                       Email : idixon_at_infocom.co.uk
Reading, England