FIX: Correlated Subquery on Datetime Col May Cause Client AV

ID: Q149174

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG#: 14267 (6.00)

SYMPTOMS

The client thread may access violate if it has the datetime column in correlation, and multiple conditions in the WHERE clause of the correlated subquery and the main outer query.

WORKAROUND

Split the query into multiple queries by using intermediate temporary tables.

STATUS

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

Additional query words: sql6 av


Keywords          : kbprg SSrvProg kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 24, 1999