BUG: Assertion Occurs When You Try to Run a Query That Uses a Parallel Plan (317089)

SYMPTOMS

When you run a SELECT query that uses a parallel plan in SQL Server 7.0 Service Pack 3 or SQL Server 7.0 Service Pack 4, the query may fail with the following assertion: The assertion occurs if:

• The query has multiple joins. -and-
  
  
• The query has aggregate functions in the SELECT clause.

You will see the following stack dump in the SQL Server error log when you experience this problem:

SQL Server 7.0 SP3 Stack Dump

----------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x0078a1d0 Module(sqlservr+38a1d0) (utassert_fail+1a0)
0x0066dedb Module(sqlservr+26dedb) (CXPipe::NewRow+aa)
0x0066a2e0 Module(sqlservr+26a2e0) (CQScanXProducer::Open+7f)
0x00669f3f Module(sqlservr+269f3f) (FnProducerThread+1e3)
0x004ad883 Module(sqlservr+ad883) (subproc_main+f4)
0x41092a15 Module(ums+2a15) (ProcessWorkRequests+ed)
0x410932cb Module(ums+32cb) (ThreadStartRoutine+139)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
2002-01-24 18:21:51.07 kernel SQL Server Assertion: File: <port.cpp>, line=1348 
Failed Assertion = 'hr == S_OK'.
----------------------------------------------------------------------