Re: Strange SQL Bug
Date: Wed, 19 May 1993 15:43:52 GMT
Message-ID: <C7A6D6.HFB_at_mcdgs01.cr.usgs.gov>
In article <1993May19.062754.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?
|> 2) Does this bug exist in V7? (Ours is not yet installed so I can't test it
|> yet).
|>
I seem to have no problem running your SQL code.
The output is:
PREFX RESULT ----------------- --------- 323168 / 323810 = 1.00 PREFX RESULT ----------------- --------- 333168 / 333810 = 1.00 PREFX RESULT ----------------- --------- 313168 / 313810 = 1.00
We are using a Data General (Aviion) 6240 series. Could it be something with your hardware? Or maybe just a one time thing? All three statements are probably using the same parsed version. Try running the first SQL statement twice.
jyoung_at_mcdgs01.cr.usgs.gov Received on Wed May 19 1993 - 17:43:52 CEST