BUG: Using Subquery on MIPS Can Cause Thread Level AV

ID: Q150187


The information in this article applies to:

BUG#: 14444 (6.00)

SYMPTOMS

If you use a subquery on SQL Server 6.0 running on a MIPS computer, it can cause a thread level access violation (AV).


CAUSE

The following criteria must be present for the problem to occur:

  1. Two levels of subquery, three tables involved.


  2. One of the tables must have a unique index.


  3. Columns involved in the join must be char/varchar; using int avoids the problem.


  4. The amount of data in these tables is critical.




WORKAROUND

Use a join to replace the inner subquery, such as the following, where t is table, c is column:


select my_result=
   (select count(*) from t2,t3 where t2.c1=t1.c1 and t2.c1=t3.c1)
from t1 


STATUS

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


Keywords          : kbprg SSrvProg kbbug6.00 
Version           : 6.0
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 25, 1999