FIX: Using a Derived Table in the HAVING Clause May Cause AV

ID: Q158791

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG# 16030 6.50

SYMPTOMS

A SELECT statement using a derived table in the HAVING clause may cause a handled access violation (AV). In addition, the access violation's stack dump may go into a state where it continuously writes the stack to the errorlog. If this occurs, the errorlog will grow very quickly.

WORKAROUND

To work around this problem, do not use derived tables in the HAVING clause.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 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.


Keywords          : kbusage SSrvGPF kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999