We were getting inconsistent Report results and, after investigation by Microsoft, this was sent to us...
FIX: A Parallel Query with a COUNT Aggregate Function May Return Unexpected Results
The information in this article applies to:
Microsoft SQL Server 2000 (all editions)
BUG #: 364025 (SHILOH_BUGS)
SYMPTOMS
When the following conditions are met, a parallel query that uses the COUNT aggregate function may return unexpected results:
- The query uses a parallel non-clustered index scan in the execution plan.
- The query contains an IS NULL condition in the WHERE clause of the query.
RESOLUTION
A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem. This fix may receive additional testing. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next Microsoft SQL Server 2000 service pack that contains this fix.
FIX: A Parallel Query with a COUNT Aggregate Function May Return Unexpected Results
The information in this article applies to:
Microsoft SQL Server 2000 (all editions)
BUG #: 364025 (SHILOH_BUGS)
SYMPTOMS
When the following conditions are met, a parallel query that uses the COUNT aggregate function may return unexpected results:
- The query uses a parallel non-clustered index scan in the execution plan.
- The query contains an IS NULL condition in the WHERE clause of the query.
RESOLUTION
A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem. This fix may receive additional testing. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next Microsoft SQL Server 2000 service pack that contains this fix.
