Microsoft KB Archive/103748

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:03, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

BUG: SELECT with More than 125 SUM Columns Can GP Fault Server

Q103748



The information in this article applies to:


  • Microsoft SQL Server version 4.2x



NT: 446 (4.2)


SYMPTOMS

A SELECT statement with more than 125 SUM columns of INT NULL will cause SQL Server to get a general protection fault (GP fault).

   Example
   -------
   select sum(c2), sum(c3), sum(c4), ...  sum(c124), sum(c125), sum(c126)
   from t1
   group by c1 

To avoid this problem, you can split the table into multiple tables and do a join, or you can do an inner join on the single table.



STATUS

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

Additional query words: kernel

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: January 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.