Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 4/17/2010
For: Version 2.03 Build 11
# 3187 CONTAINS Searches Using More than One Wildcard in Search Words Return Incorrect Results

I have a number of records that contain the phrase "Series Notebooks" in the descr field, such as "Asus 8 Cell Battery for A7 & G2 Series Notebooks, 1 Year Warranty".

I've got a CLOB column called DESCR that contains straight text only and I've added a full text index on this using the UNI_CI collation.

First issue. I'm assuming that the following query would return all records that contain both Seri* AND Noteb*

but I get no records returned.

If I run separate queries for each search value I get the expected results. And if I split the multiple keywords into two separate contains clauses I also get the expected results. So this is either a bug or I don't have the syntax correct to search for multiple works with Wildcards.

ON "code"
("Descr" COLLATE "UNI_CI")

No records:

select * from code where descr contains 'Seri* Noteb*'

Separate queries:

select * from code
where descr contains 'Seri*' AND descr contains 'Noteb*'

Comments Comments and Workarounds
The workaround is as-indicated - split the single CONTAINS search into multiple CONTAINS searches joined by the AND operator.

Resolution Resolution
Fixed Problem on 4/18/2010 in version 2.03 build 12

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial