Microsoft KB Archive/198998

= BUG: ANSI Join a Table with a Nested View with Group by Clause May Cause AV =

Article ID: 198998

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q198998



BUG #: 18083 (SQLBUG_65)



SYMPTOMS
When you use an ANSI-style join to join a table with a nested view that contains a GROUP BY clause, if that nested view contains another view, an access violation (AV) may occur.



WORKAROUND
You can use any of the following workarounds to avoid this problem:
 * Use a SQL Server-style join instead of an ANSI-style join.
 * Remove the GROUP BY clause from the view.
 * Simplify the view so that the view does not contain another view.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.



MORE INFORMATION
The bug occurs during preprocessing of the query statement. The bug does not occur in SQL Server 7.0.

Additional query words: kbbug6.50 av prodsql

Keywords: kbbug kbpending KB198998

-

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

© Microsoft Corporation. All rights reserved.