View Full Version : Results undesirably randomized in fulltext search

08-08-2006, 04:10 PM
I am running a simple query that performs a fulltext search and sorts by score. Everything has been running fine for months now when suddenly I am seeing random results returned in some cases, in others I see less results returned than should be, and in others I see results that are the same but randomly sorted.

I tried copying the database over to another server and ran the exact same fulltext query there. The results that come back are consistantly what is to be expected on this other server.

What could cause such differing results with the same database and query on two separate machines with the same setup?

Kid Charming
08-08-2006, 05:32 PM
Different collations could cause different sorts. Are you getting these differences in direct queries or via a script? Can you post the query?

08-09-2006, 04:16 PM
Turns out the options file wasn't transferred during a recent server move. It simply lacked the correct settings to agree with the index that had already been built.

Works fine now.