View Incident Report

Serious

Reported By: Elevate Software
Reported On: 8/20/2002
For: Version 3.07 Build 1

# 1174 ROUND() SQL and Filter Function Returning Incorrect Results in Some Cases

The following SQL results in 103271.17 but the right result is 103271.18.

select round(826.5/100*12495 to 2) from test

Comments

Problem was caused by rounding functions using Double data type instead of Extended, which caused a loss of precision needed for proper rounding.

Resolution

Fixed Problem on 8/20/2002 in version 3.14 build 1

More Support Options