View Incident Report

Serious

Reported By: Aage Johnson
Reported On: 5/25/2005
For: Version 4.20 Build 3

# 2061 Optimized TEXTSEARCH Queries Returning Incorrect Results When Stop Words Included

My Query code is as follows:

1. If TXT contains "WAR WORLDS" the result set contains references (SLNR) to "The War of the Worlds" and (several versions of) "War of the Worlds" - which is correct.

2. If TXT contains "WAR OF THE WORLDS" I get an emtpy result set. The difference are the stop words (OF and THE), but these should be totally ignored.

fDM2.qT1.Close;
fDM2.qT1.SQL.Clear;
fDM2.qT1.SQL.Add('select distinct SLNR '+
                 'from TITTEL '+
                 'where TextSearch('+QuotedStr(TXT)+' in TITTEL)');

Comments and Workarounds

The problem only occurred if the stop words sorted before the other words in the TEXTSEARCH search string.

Resolution

Fixed Problem on 6/2/2005 in version 4.21 build 1

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 VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap