Microsoft KB Archive/152263

{|
 * width="100%"|

BUG: Query with Join in Subselect May Cause Handled Exception

 * }

Q152263

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG#: 13120

SYMPTOMS
A query with a subselect that contains a join may cause a handled exception that terminates the client connection.

WORKAROUND
Rewrite the query, possibly using a normal join instead of the subselect.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.0.

MORE INFORMATION
Here is an example of a query that can cause this problem:

  SELECT A.column1 FROM A, B  WHERE A.id1 = B.id1  AND A.id2 = B.id2 AND A.column1 IN (SELECT A0.column1 FROM A A0, B B0      WHERE A0.id1 = B0.id1) Additional query words: access violation

Keywords : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600