Reported By: Timo Saisa Reported On: 3/17/2005 For: Version 4.18 Build 1
# 2002Using the SQL AVG() Aggregate Function On Word Fields Causes Incorrect Results Something goes wrong with the following query. After changing the column data type to integer both results are correct.
VALUE1: data type Word
SELECT AVG(VALUE1) FROM TABLE1
WHERE VALUE1 = 0
result = 82723110
SELECT AVG(1*VALUE1) FROM TABLE1
WHERE VALUE1 = 0
result = 0
ResolutionFixed Problem on 3/18/2005 in version 4.19 build 1
Products AffectedDBISAM Additional Software and Utilities DBISAM ODBC Client-Server DBISAM ODBC Client-Server with Source DBISAM ODBC Standard DBISAM ODBC Standard with Source DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source