View Incident Report

Serious

Reported By: Jason Wilson
Reported On: 4/19/2002
For: Version 3.10 Build 1

# 1121 A TEXTSEARCH SQL Query that Only Contains Stop Words or Non-Include Chars Returns All Records

See SQL below. If I substitute "A" (or any other alpha string) as the test word/character, the query returns ALL of the records, even though the test word is not in the include list, nor is it actually in any of the records.

SELECT * FROM NODES2 n
WHERE TEXTSEARCH("<test word>" IN n.owner_list)

Comments

This also applies to search strings comprised solely of stop words.

Resolution

Fixed Problem on 4/20/2002 in version 3.11 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap