View Incident Report

Serious

Reported By: Bernd Kuhlmann
Reported On: 3/6/2003
For: Version 3.21 Build 1

# 1318 Using More Than One % Wildcard Character at the End of a LIKE Constant Returns Incorrect Results

There is a problem with "%%" at the end of a like-string.

select * from table1 where field1 like "red%%"
returns 0 records (it should return 1 record)

select * from table1 where field1 like "%%"
returns 1 record

select * from table1 where field1 like "red%"
returns 1 record

 /* SQL-92 Table Creation Script with DBISAM Extensions */ 
 
DROP 
TABLE IF EXISTS "Table1"; 
 
CREATE TABLE IF NOT EXISTS "Table1" 
( 
 
  "id" AUTOINC, 
   "field1" CHARACTER(30) 
LANGUAGE "ANSI Standard" 
SORT "Default Order" 
USER MAJOR VERSION 1 
); 
 
INSERT INTO 
"Table1" VALUES (1 , 
         "red") NOAUTOINC;

Resolution

Could Not Reproduce Problem on in version 0.00 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap