BUG: AV Using Aggregate Functions in the Select List

• Microsoft SQL Server versions 6.0, 6.5

SYMPTOMS

You receive a handled access violation error (AV) when both of the following conditions are true:

• There are two or more aggregate functions in the SELECT list of the query.
  
  NOTE: The AV does not occur for a single aggregate function.



• One aggregate function is used in the WHERE clause of the select query that uses the derived table.

WORKAROUND

To work around this problem, avoid constructing such queries involving a combination of two or more aggregate functions in the select list and an aggregate function in the derived table.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords          : kbusage SSrvTran_SQL kbbug6.50 kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 9, 1999