FIX: AV Selecting View with Aggregate Subquery and Outer Join

ID: Q158269

6.50

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 1 and later

BUG #: 16035

SYMPTOMS

When you select from a view with an aggregate subquery using an ANSI style outer join, you receive an access violation error message.

For example, the following view will cause this behavior:


   Create view testview as
   select titles.title_id, totalcount = (select count(*) from titles) from titles
   Left Outer Join titleauthor On titles.title_id = titleauthor.title_id

WORKAROUND

Replace Left Outer Join with "*=" to avoid the access violation.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5 Service Pack 1. 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          : kbnetwork SSrvGen kbbug6.50 kbfix6.50.sp2 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 3, 1999