View Incident Report

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.

CREATE TEXT INDEX "Descr"
ON "code"
("Descr" COLLATE "UNI_CI")
INDEXED WORD LENGTH 30
WORD GENERATOR "Default"

No records:

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

Separate queries:

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

Comments and Workarounds

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

Resolution

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap