Icon View Incident Report

Serious Serious
Reported By: Timo Saisa
Reported On: 3/17/2005
For: Version 4.18 Build 1
# 2002 Using 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



Resolution Resolution
Fixed Problem on 3/18/2005 in version 4.19 build 1


Products Affected Products Affected
DBISAM 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

Image