January 5, 2010 at 12:46 pm
I have a very simple Full Text Index on a table, with the index on one field "ObjectName", it's fully defaulted (auto population, based on a single integer primary key, etc.).
There are two specific records in the table, one of which has an objectName of "City Cloak of Zeal" the other has an objectName of "City Cloak of Might".
This query returns the row with an objectName "City Cloak of Zeal"
SELECT *
FROM lib.allObjects
WHERE CONTAINS ( ObjectName, '"Zeal*"' )
AND objectName LIKE '%city%'
This query DOES NOT return the record for "City Cloak of Might"
SELECT *
FROM lib.allObjects
WHERE CONTAINS ( ObjectName, '"Might*"' )
AND objectName LIKE '%city%'
I've rebuilt the index, I've even completely deleted the Full Text Index and Re-made it from scratch with the same results.
SELECT *
FROM lib.allObjects
WHERE CONTAINS ( ObjectName, '"Might*"' ) does return another record for "The Mighty Lipnik", so it's not skipping Might.
I'm stumped, and it seems like it may be a bug. Any suggestions or thoughts on this?
January 6, 2010 at 6:51 am
"Might" is a noise word, thus it is not contained in the full-text index. You need to remove it from the noise words file and re-populate the index.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 6, 2010 at 9:46 am
Thank you. Yes it was in there. I'm not sure how I missed it the first time. I did a simple search for the word might in the noise file using notepad, and it said it couldn't find it. So I closed the file and have since looked elsewhere. I must have not been at the top of the file or something when I did the search (notepad doesn't loop around the file for searches).
Anyway, thanks again!
January 7, 2010 at 10:01 am
I strongly suggest that you eliminate the "noise" (stop) words. After several years of continual customer frustration with the "search" feature of our product, we finally killed them. Now everyone is happy.
Most modern full-text search systems don't use "stop" words. It is a legacy item when disk storage was at a premium.
January 7, 2010 at 10:27 am
That's great to know. Thank you!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply