Article ID: 246598
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q246598
BUG #: 53838 (SQLBUG_70)
SYMPTOMS
When the same column is listed multiple times in a GROUP BY clause that uses the CUBE operator, you may receive the following Access Violation (AV) error message:
WORKAROUND
Use table aliases and qualify the multiple instances of the column in the GROUP BY clause with the aliases.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
MORE INFORMATION
Steps To Reproduce The Problem
Query 1 demonstrates the problem while Query 2 uses table aliases to work around the problem.
Query 1
USE tempdb GO DROP TABLE t1 GO CREATE TABLE t1(c1 INT) GO SELECT c1 FROM t1 GROUP BY c1, c1, c1, c1 WITH CUBE GO
Query 2
USE tempdb GO DROP TABLE t1 go CREATE TABLE t1(c1 INT) GO SELECT a.c1 FROM t1 a, t1 b, t1 c, t1 d GROUP BY a.c1, b.c1, c.c1, d.c1 WITH CUBE GO
Keywords: kbbug kbfix KB246598