Microsoft KB Archive/158269

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.