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

• Microsoft SQL Server version 6.5

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 version 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          : kbtool SSrvErr_Log SSrvISQL SSrvSQL_Admin SSrvTran_SQL kbbug6.50 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: March 19, 1999