Microsoft KB Archive/230555

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

Article ID: 230555

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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

Additional query words: rollup access violation

Keywords: kbbug kbpending KB230555

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.