Icon View Incident Report

Serious Serious
Reported By: Suat Demirkiran
Reported On: 11/17/2008
For: Version 4.27 Build 1
# 2880 Using 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



Resolution Resolution
Fixed Problem on 11/19/2008 in version 4.27 build 2


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 ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image