Microsoft KB Archive/169346

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

Article ID: 169346

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q169346



BUG #: 16833 (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: kbbug kbusage kbsqlserv650bug KB169346

-

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

© Microsoft Corporation. All rights reserved.