Query Returns Empty Results with IS NULL Test Condition (309567)

The information in this article applies to:

Microsoft Index Server 3.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.

Modification Type:	Minor	Last Reviewed:	9/23/2005
Keywords:	kbHotfixServer kbQFE kbbug kbfix kbWin2000sp3fix KB309567