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

• Microsoft SQL Server version 7.0

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 version 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 

Additional query words: rollup access violation

Keywords          : kbbug7.00 kbSQLServ700bug access violation 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: July 19, 1999