FIX: TOP_N_BY_RANK Argument May Not Return Top N by Rank (308763)

SYMPTOMS

If you use the TOP_N_BY_RANK argument in a full-text query, an incorrect result set may return. The inconsistency in the incorrect result set may be that a row that should return because of it's rank does not return. For example, if you use the following full-text query to query table A:

select [key], rank from containstable (A, full_text_column, 'beef')
				

the following result set may return:

key         rank        
----------- ----------- 
2           64
23          85
85          49
97          44
1           56
				

If you now execute the following full-text query, which uses the TOP_BY_N_RANK argument, against the same table in the same database:

select [key], rank from containstable (A, full_text_column, 'beef', 3)
				

the following incorrect result set may return:

key         rank        
----------- ----------- 
23          85
2           64
85          49

				

The preceding result set is incorrect because the following row did not return:

key         rank        
----------- ----------- 
1           56