Reported By: Ricardo Oliveira Reported On: 3/17/2006 For: Version 4.22 Build 6
# 2175Comparing 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.
ResolutionFixed Problem on 3/26/2006 in version 4.23 build 1
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