Icon View Incident Report

Serious Serious
Reported By: Dennis Allsopp
Reported On: 3/19/2011
For: Version 4.30 Build 3
# 3406 LIKE Operator Not Working Properly with Leading Wildcards

It appears a bug was introduced in DBISAM build 4.30 Build 3 in that the like operator only functions with the wildcard at the end of the search value, e.g.

Where the wildcard is used at the first position or at both ends of the search string all records are returned.

select * from t801 where ds_class like 'REAGENT%' order by ds_class



Comments Comments
This was caused by a change to the LIKE functionality to improve the handling of MBCS operations.


Resolution Resolution
Fixed Problem on 3/20/2011 in version 4.30 build 4


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

Image