Microsoft KB Archive/150187

{|
 * width="100%"|

BUG: Using Subquery on MIPS Can Cause Thread Level AV

 * }

Q150187

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

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 : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600