1

I have full text index on field1 in table1. The problem is that not all expected rows are returned when doing a query.

Example:

select * 
from CONTAINSTABLE(xxxdb.dbo.table1, field1, '"123 456"' )

returns 

123 456 1.1
123 456 1.2
123 456 1.3

but not

123 456 1.4

If I use

select * 
from xxxdb.dbo.table1 where field1 like '%123 456%'

then I get all 4 rows

Does anyone have any idea what could be causing this behavior or how to troubleshoot? Any suggestions are welcome.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3392351
  • 135
  • 1
  • 7
  • Can you post executable code that creates all necessary objects and data? – usr Jul 29 '14 at 15:25
  • 1
    Is it possible the [full text index population hasn't completed](http://stackoverflow.com/questions/2727911/how-can-i-know-when-sql-full-text-index-population-is-finished)? – Dave Mason Jul 29 '14 at 16:07
  • 1
    @usr for now i cannot because the data is a confidential. I will try to reproduce with other data and post back if i succeed. – user3392351 Jul 30 '14 at 08:21
  • @DMason I just dont know and dont know how to find out - all queries i found online that are supposed to give me the status return empty tables – user3392351 Jul 30 '14 at 08:24
  • Did the link to the other SO question help? There's a lot of good info there. – Dave Mason Jul 30 '14 at 12:50

0 Answers0