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:

     FREETEXT([Title], '"global warming"')


 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 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?

more ▼

asked Sep 04, 2010 at 02:33 AM in Default

avatar image

3 2 2 4

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

1 answer: sort voted first
more ▼

answered Sep 05, 2010 at 09:28 PM

avatar image

Daniel Ross
2.9k 11 15 18

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, 2010 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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Sep 04, 2010 at 02:33 AM

Seen: 1354 times

Last Updated: Sep 04, 2010 at 02:51 AM

Copyright 2018 Redgate Software. Privacy Policy