View Incident Report

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

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

Resolution

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap