| Subject | Numeric Calculation Error ? |
|---|---|
| Author | kamen_lai |
| Post date | 2005-01-14T02:50:17Z |
select 0.00 - (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASE
the wrong result is -230930.057593950041
but
select 0.00 + (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASE
get correct result is 4984.2725939500006
in IB 6.01. & WI-V1.5.1.4481 Firebird 1.5
the wrong result is -230930.057593950041
but
select 0.00 + (13060.45*9.031631) - (13060.45*8.65) from RDB$DATABASE
get correct result is 4984.2725939500006
in IB 6.01. & WI-V1.5.1.4481 Firebird 1.5