Reported By: Suat Demirkiran Reported On: 11/17/2008 For: Version 4.27 Build 1
# 2880Using the DISTINCT Clause with the TOP Clause Can Cause Incorrect Results The following SQL returns 65584 records.
select distinct h.BLOB_ID
from BROADCAST_PLAN h
order by 1
top 10
ResolutionFixed Problem on 11/19/2008 in version 4.27 build 2
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 ODBC Trial DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source DBISAM VCL Trial