Icon View Incident Report

Serious Serious
Reported By: Ralf Bieber [EDV Dienstleistungen Ralf B
Reported On: 9/12/2012
For: Version 4.33 Build 4
# 3623 CASTing BLOB Fields to Memo Fields Cause Incorrect String Result

BLOB fields that are CAST to Memo fields are not compared properly in an SQL WHERE clause.

cast(Z.EtikettBenutzerfeld_1 as memo) <> cast(Q.EtikettBenutzerfeld_1 as memo)

where EtikettBenutzerfeld_1 is a Blob field.



Comments Comments
The problem was that DBISAM was not properly adding a NULL byte at the end of the string created by the CAST, thus causing any subsequent string comparisons to be indeterminate.


Resolution Resolution
Fixed Problem on 9/18/2012 in version 4.34 build 1


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