Ann,

I'm not sure if this has come to your attention yet,
but the following firebird bug (specifically case 3, which I
recently added) describes modified behaviour for working with
dialect 1 databases, in which numeric calculations that did work
in IB5.6 now return incorrect results.

[ Bug #121589 ] numeric fields and mathematical operations
https://sourceforge.net/bugs/?func=detailbug&bug_id=121589&group_id=9028

I just tested with IB6.01 against an ODS 9.1 database,
and the problem shows up the same as when running against
an ODS 10 database in dialect 1...

--------IB 6.01----------------
WISQL->Session->Display Connect Version
SHOW VERSION
ISQL Version: WI-V5.5.0.742
InterBase/x86/Windows NT (access method), version "WI-V6.0.0.627"
on disk structure version 9.1

SELECT * FROM NUMERIC_TEST;

OUT1
===========

2145.0000
2146.0000
2147.0000
-2146.9673 <=-wrong
-2145.9673 <=-wrong
-2144.9673 <=-wrong
-------------------------------

Basically, this bug makes it a dangerous proposition to
run IB6/firebird with any pre dialect 3 database, as
stored procedures doing numeric calculations can give
incorrect results. Overflow now occurs on the internal
calculations at a lower threshold, and the overflow is not
reported as an error.

We are installing IB5.6 on linux at some customer sites
until we can either get this bug fixed or move our product
to dialect 3.

Best regards,
Corey.

Corey Wangler
Designed Software Solutions
Adelaide, Australia.