Re: Strange SQL Bug

In article <1993May19.062754.14533_at_ml.csiro.au> jstander_at_ml.csiro.au 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?
>2) Does this bug exist in V7? (Ours is not yet installed so I can't test it
> yet).
>
>---
>___________________________________________________________________________
>
>Jeff.Stander_at_ml.csiro.au _--_|\ Database Analyst
>CSIRO Division Of Fisheries / \ Pelagic Fisheries Resources
>GPO Box 1538, Hobart \_.--._/ Tasmania 7001, Australia
>Aus Tel: 002-325-332 v Intl Tel: +61-02-325-332
>Aus Fax: 002-325-000 Intl Fax: +61-02-325-000
>___________________________________________________________________________
>
>

  Hi

  What version of 6 are you running , there was a formatting bug in the kernal at about 6.0.30 which caused rounding problems.

  I have a tech note at work, email me with your version and I will check it out.

-- 
tina C London