FIX: Access Violation with Extra SELECT in Aggregate Function (156680)



The information in this article applies to:

  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 6.5 Service Pack 1

This article was previously published under Q156680
BUG #: 15979 (SQL 6.5)

SYMPTOMS

The extra SELECT keyword in the selection list of an aggregate function may cause a thread level access violation, and result in the following error message:
This command did not return data, and it did not return any rows.
DB-Library Process Dead - Connection Broken.

WORKAROUND

To work around this problem, remove the extra SELECT keyword.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbusage KB156680