x

Why have phrase matches stopped working in my 2008 instance?

According to this:

Use of WEIGHT, FORMSOF, wildcards, NEAR and other syntax is not allowed. freetext_string is wordbroken, stemmed, and passed through the thesaurus. If freetext_string is enclosed in double quotation marks, a phrase match is instead performed; stemming and thesaurus are not performed.

Indeed, this has worked just fine for me up until now (mostly on 2005). But on my 2008 instance at home, it's suddenly started ignoring the double quotes in any query I do:

SELECT TOP 3
    Title
FROM
    Articles
WHERE
    FREETEXT([Title], '"global warming"')

Results:

China takes Congress-centered stance in prevention of global warming
Global Nanotechnology R&D Hub Taking Shape in Tsukuba
Warming-related drought leads to decline in plant growth, reversing earlier trend

Why is the FREETEXT predicate stripping or ignoring the double quotes in my query?

I found [this][2] post that seems to suggest this behavior has changed in 2008. Does that mean the MSDN documentation is incorrect? And how can I most easily restore/simulate the previous behavior?

[2]: http://social.msdn.microsoft.com/Forums/en-US/sqlsearch/thread/95922ae3-91ad-4524-b1be-6e987656edee
more ▼

asked Sep 04 '10 at 02:33 AM in Default

fiend gravatar image

fiend
3 2 2 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
more ▼

answered Sep 05 '10 at 09:28 PM

Daniel Ross gravatar image

Daniel Ross
2.9k 10 12 13

Thanks Daniel. Looks like I'm switching to CONTAINS[TABLE] then. I had hoped to avoid it because translating a query such as "global warming" extreme is harder because I need to change that to "global warming" AND extreme otherwise CONTAINS[TABLE] can't parse it.
Sep 06 '10 at 01:44 AM fiend
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x672
x43

asked: Sep 04 '10 at 02:33 AM

Seen: 948 times

Last Updated: Sep 04 '10 at 02:51 AM