FIX: AV if 4 or More Correlated Subqueries with Self-Join

ID: Q153851

The information in this article applies to:

Microsoft SQL Server version 6.5

SYMPTOMS

If a complex query does a self-join and has four or more subqueries, all referencing the same table, it may get a thread-level access violation (AV) if the table has only a non-clustered index.

WORKAROUND

Convert the non-clustered index to a clustered index, or drop it.

STATUS

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

Additional query words: sp1 default


Keywords          : kbnetwork SSrvGen kbbug6.50 kbfix6.50.sp1 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 31, 1999