BUG: ANSI Join a Table with a Nested View with Group by Clause May Cause AV (198998)


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB198998
©2003 Microsoft Corporation. All rights reserved.