Groups | Blog | Home
all groups > sql server full text search > january 2005 >

sql server full text search : inflectional causing "query contained only ignored words" error


Tony Vargas
1/21/2005 8:29:04 AM
Hi

I am receiving the error "query contained only ignored words" from the word
"best" that is not in the ignored words list. While researching the problem
online I found the following link:
http://www.dbforums.com/archive/index.php/t-965368.html

In the post the poster states this is a known bug in full-text indexing and
has been written up as a "DOC bug" (not sure what that means) by MS. I am
hoping there is an update and/or fix for this problem.

Any help would be appreciated.

Thanks

Tony Vargas
1/21/2005 10:21:04 AM
Well there-in lies the problem. It does not exist in the noise word list.
"best" is not a noise word. It is a bug with full-text indexing when using
inflectional with certain words.

This works:
Contains(my_field, 'best')

This doesn't Work:
Contains(my_field, 'formsof(INFLECTIONAL, "best")')

In my original post I stated that in another forum someone said MS had this
listed as a bug, but I was hoping there may be a fix for this already.


[quoted text, click to view]
Hilary Cotter
1/21/2005 12:58:51 PM
remove the word well from your noise word list. Stop MSSearch before making
this change and restart it after. Then rebuild your index.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]

Hilary Cotter
1/21/2005 1:35:09 PM
I'm curious as to why it works on my machine.

If you don't mind me asking - which word breaker are you using? Which OS?
Which noise file did you edit?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]

John Kane
1/21/2005 7:42:25 PM
Tony,
A "DOC bug" is a documentation bug, i.e., a "by design" feature that is not
documented in Books Online (BOL) or in a KB article.
I'll confirm that the DOC bug, however, and to the best of my knowledge, no
KB article for this has been written or made public, I'm sad to say. The
workaround at this time, is not to use the 'FORMSOF(INFLECTIONAL) parameter.

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/



[quoted text, click to view]

AddThis Social Bookmark Button