Something confusing about FormsOf (Sql server Full-Text searching)
- by AspOnMyNet
hi
I'm using Sql Server 2008
1)
A given <simple_term> within a <generation_term> will not match both nouns and
verbs.
If I understand the above text correctly, then query
SELECT *
FROM someTable
WHERE CONTAINS ( *, ' FORMSOF ( INFLECTIONAL, park ) ' )
should search for either nouns or verbs derived from the root word
“park”, but not for both? Thus out of the two rows, one containing
noun parks and other verb parking, the above query should return
just one of the two rows?
But as it turns out, query returns both rows, so are perhaps my assumptions a bit off or is the above quote wrong?!
2)
From Msdn:
If freetext_string is enclosed in double quotation marks, a phrase
match is instead performed; stemming and thesaurus are not performed.
According to the above quote the following query shouldn’t return rows
containing strings surfing ( due to query not performing stemming ),
surf ( due to query performing phrase matching and not individual
word matching ) and surfing with suzy’s sister ( due to query not
performing stemming and due to query performing phrase matching and
not word matching ), but it does.
Thus, it appears that even when *freetext_string* is enclosed in double
quotation marks, stemming is still preformed, while phrase matching is
not:
SELECT *
FROM someTable
WHERE FREETEXT( *, ' "surf sister" ' )
So is the above quote wrong or...?
thanx
