BUG: Query with CUBE and Duplicate Column in GROUP BY Clause Generates AV (230555)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q230555
BUG #: 53838 (SQLBUG_70)

SYMPTOMS

A query that contains a CUBE operator and a GROUP BY clause, with a duplicate column name, generates an access violation exception on the server. This will appear in the SQL Server errorlog. The user connection with the server will be dropped with a message such as the following:
ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionWrite (WriteFile()). [Microsoft][ODBC SQL Server Driver]Communication link failure

Connection Broken

WORKAROUND

Remove the duplicate column in the GROUP BY clause.

STATUS

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

MORE INFORMATION

This behavior can be reproduced with the following example: 
--SETUP
use tempdb
go
create table t1(c1 int)
go
--QUERY
select a.c1 from t1 a, t1 b, t1 c
group by a.c1, b.c1, c.c1, a.c1
with cube
order by a.c1
go
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB230555
©2002 Microsoft Corporation. All rights reserved.