BUG: ANSI Full Outer Join and Non-ANSI Join May Cause Handled AV

• Microsoft SQL Server version 6.5

SYMPTOMS

Optimizing a query may cause a handled access violation (AV) that stops the clients thread on the server if all of the following conditions are true:

• The query contains the same table more than once.



• The query does an ANSI Full Outer Join with one of the instances of the duplicated table.



• The second instance of the table is joined to another table without the ANSI Join syntax.



• There is no join condition between the instances of the table.

WORKAROUND

To work around this problem, rewrite the query:

• Create a join condition between the two or more instances of the table.



• Remove one of the instances of the table from the query.



• Change the ANSI join to either a Left or Right Outer Join.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords          : kbusage SSrvGPF SSrvTran_SQL kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 20, 1999