Icon View Incident Report

Minor Minor
Reported By: Ricardo Oliveira
Reported On: 3/17/2006
For: Version 4.22 Build 6
# 2175 Comparing an Invalid Word Value to a Word Column Causes Incorrect Results

I have a problem with the following SQL. I was expecting the query to return zero rows or DBISAM to throw an exception, yet the query returns every record where FIELD1 = 0. Filtering the table also returns the same result.


Select Field1 from Table1 where Field1=-1

where FIELD1 type is Word.




Resolution Resolution
Fixed Problem on 3/26/2006 in version 4.23 build 1


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