Knowledge Base

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

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.