Knowledge Base

FIX: AV Selecting View with Aggregate Subquery and Outer Join

Article ID: 158269

Article Last Modified on 10/3/2003

APPLIES TO

Microsoft SQL Server 6.5 Service Pack 1

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.

Keywords: kbbug kbfix kbnetwork KB158269