October 28, 2015 at 11:12 am
We are running SQL 2014 SP1. We are using defined Full text indexes on several tables in the database. However, on one specific set of servers, a certain search will not return any data. This exact same search works on another set of servers built identically. The first responses I'm sure will be stop list, but I have dropped and recreated the FTI multiple times with different stop lists or no stop list at all and get the same results.
The specific word being searched on is YUM. If I change the value to YUMk, it actually returns, and if I change the data to TUM it returns, but YUM does not. This exact query is working on multiple other systems, so it seems to be something environmental, but I haven't been able to pinpoint it.
Any thoughts?
October 28, 2015 at 11:28 am
Don Shoemaker (10/28/2015)
We are running SQL 2014 SP1. We are using defined Full text indexes on several tables in the database. However, on one specific set of servers, a certain search will not return any data. This exact same search works on another set of servers built identically. The first responses I'm sure will be stop list, but I have dropped and recreated the FTI multiple times with different stop lists or no stop list at all and get the same results.The specific word being searched on is YUM. If I change the value to YUMk, it actually returns, and if I change the data to TUM it returns, but YUM does not. This exact query is working on multiple other systems, so it seems to be something environmental, but I haven't been able to pinpoint it.
Any thoughts?
I would start by comparing the COLLATIONs between the servers & ensuring that they're in line.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
October 28, 2015 at 11:37 am
The collations and sort orders match across the servers. They are on the same Version, SP, CU.
October 28, 2015 at 1:55 pm
The plot thickens a bit. After further analysis, Most, but not all, rows that have a three letter word/prefix followed by a space or special character at the beginning are not returning, even though they show up in the search term. This seems to relate to an issue with CONTAINS or FREETEXT...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply