Icon View Incident Report

Minor Minor
Reported By: Danny Humphress
Reported On: 1/26/2006
For: Version 4.22 Build 4
# 2159 Using an ESCAPE Character in the Middle of a LIKE Constant Confuses Optimizer

The problem is the following is not optimized but it should be:

WHERE UPPER(MyField) LIKE UPPER(‘ABC/%DEF%’) ESCAPE ‘/’



Resolution Resolution
Fixed Problem on 1/28/2006 in version 4.22 build 5


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