Microsoft KB Archive/191809

= BUG: SELECT from View with UNION ALL and Aggregate Function AVs =

Article ID: 191809

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q191809



BUG #: 18230 (SQLBUG_65)



SYMPTOMS
You may receive a handled access violation (AV) if all of the following conditions are true:


 * You issue a SELECT statement against a view.

-and-
 * That view uses UNION ALL to union a SELECT statement containing an aggregate function with another view.

-and-
 * That other view also contains UNION ALL.



WORKAROUND
To work around this problem, do any one of the following:


 * Change any of the UNION ALL statements to a UNION.

-or-
 * Eliminate the aggregate function from the SELECT statement in the outer view.

-or-
 * Execute the Transact-SQL statements that make up the outer view directly (as opposed to selecting from the outer view).



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

Additional query words: MIN MAX SUM AVG COUNT

Keywords: kbbug kbpending KB191809

-

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

© Microsoft Corporation. All rights reserved.