Microsoft KB Archive/309567

= Query Returns Empty Results with IS NULL Test Condition =

Article ID: 309567

Article Last Modified on 9/23/2005

-

APPLIES TO


 * Microsoft Index Server 2.0

-



This article was previously published under Q309567



SYMPTOMS
If a query contains a test condition with an IS NULL predicate for a particular property, the query may not return any results.



CAUSE
The query optimizer builds a range of empty to empty for IS NULL predicates. The restriction is sent to the engine, which returns a null cursor, and the query fails.



RESOLUTION
To resolve this problem, obtain the latest service pack for Windows 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

260910 How to Obtain the Latest Windows 2000 Service Pack

The English version of this fix should have the following file attributes or later:   Date         Time   Version        Size       File name ---  10-Nov-2001  00:19  5.0.2195.4620  1,422,608  Query.dll



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Windows 2000 Service Pack 3.

Additional query words: kbIISCom

Keywords: kbbug kbfix kbqfe kbwin2000sp3fix kbhotfixserver KB309567

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.