Strange SQL Bug

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


___________________________________________________________________________