Icon View Incident Report

Serious 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 Comments and Workarounds
The problem only occurred if the stop words sorted before the other words in the TEXTSEARCH search string.


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


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