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 :