Article ID: 888008 - View products that this article applies to.
Bug #: 471528 (SQL Server 8.0)
When you run a full-text query that uses the NEAR operator in Microsoft SQL Server 2000, the number of rows that are returned may be different if the NEAR operands are reversed. For example, the following two queries may return different results:
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/ )How to obtain the latest SQL Server 2000 service pack
PrerequisitesThis hotfix requires SQL Server 2000 Service Pack 3.
Restart requirementYou do not have to restart your computer after you apply this hotfix.
Hotfix replacement informationThis hotfix does not replace any other hotfixes.
File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name -------------------------------------------------------------- 07-Aug-2004 00:28 9.107.8320.7 1,536,000 Tquery.dll
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
Steps to reproduce the behaviorTo reproduce the behavior, run the following Transact-SQL script:
Note After you run the Transact-SQL script, the first SELECT statement returns three rows, the second SELECT statement returns four rows, and the third SELECT statement returns two rows.
For more information about full-text searches in SQL Server, visit the following Microsoft Developer Network (MSDN) Web site:
Article ID: 888008 - Last Review: November 2, 2007 - Revision: 2.7