Icon View Incident Report

Serious Serious
Reported By: Kunikazu Okada
Reported On: 2/15/2006
For: Version 4.22 Build 5
# 2165 Using an ORDER BY on an Aggregate Column Returns Incorrect Results

The following SQL returns erroneous results:

select Key, AVG(Data) X from Table1 group by Key
order by X DESC 



Resolution Resolution
Fixed Problem on 2/20/2006 in version 4.22 build 6


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
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