Q150187

• Microsoft SQL Server version 6.0

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 : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600