Reported By: Kunikazu Okada Reported On: 2/15/2006 For: Version 4.22 Build 5
# 2165Using 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
ResolutionFixed Problem on 2/20/2006 in version 4.22 build 6
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