Re: Strange SQL Bug

In article 14533_at_ml.csiro.au, jstander_at_ml.csiro.au (Jeff Stander) writes:
>My colleagues have discovered the following bug in V6.
>..
>
>The SQL code is;
>
> set termout off
> set pause off
>
> column result format 99999.99
> column prefx format a17
>
> select '323168 / 323810 = ' prefx, 323168/323810 result from
> dual;
>
> select '333168 / 333810 = ' prefx, 333168/333810 result from
> dual;
>
> select '313168 / 313810 = ' prefx, 313168/313810 result from
> dual;
>
> exit
>
>The output is;
>
> PREFX RESULT
> ----------------- -----------------
> 323168 / 323810 = .00
> 333168 / 333810 = 1.00
> 313168 / 313810 = 1.00
>
>Bizarre, eh?
>
>1) Can anyone explain this?

You don't menion which release of V6 your problem occurs in, but I remember seeing this bug associated with version 6.0.33. It was fixed in 6.0.34. We are running 6.0.36, and your query returns the output you would expect...

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

No, it's fixed.

---
======================================================================
Ken Melcher (e-mail: kmelcher_at_arco.com) 
Diplomacy is the art of saying "nice doggy" until you can find a rock.
======================================================================