BUG: Multiple Result Set Reported When GROUP BY Clause Is Used (152811)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q152811
BUG# 15009

SYMPTOMS

If you use a GROUP BY clause with the bit field (this has to be converted to another datatype, such as int, char, and so forth) will cause more than one row to be returned in the result set when only one should be expected.

This problem occurs GROUP BY clause processing during query processing time especially when there are repeated records in the table.

WORKAROUND

Rewriting the query with the DISTINCT keyword will report the correct result set.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.0 and 6.5.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbbug kbpending kbProgramming KB152811
©2003 Microsoft Corporation. All rights reserved.