FIX: AV Selecting View with Aggregate Subquery and Outer Join (158269)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 1 and later
This article was previously published under Q158269
6.50
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbnetwork KB158269
©2003 Microsoft Corporation. All rights reserved.