FIX: Select Statement Can Cause Arithmetic Overflow (155710)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q155710
BUG #: 15785 (6.50) 15607 (6.00)
SYMPTOMS
In general, when you use the Select statement and a query that involves the
multiplication of a decimal number and the value returned from a function,
an Arithmetic Overflow error message appears. This error message also
appears in the following three specific conditions:
- Calculation must involve at least three operands
- Calculation must include the following three operations:
- an integer constant multiplied by
- an integer returned from a function multiplied by
- a decimal or numeric value in the form of either a constant, local
variable or a column value.
- Calculation be performed in the order in which they are listed in
Condition 2 above.
WORKAROUND
To work around this problem, convert the decimal or numeric values to
integer values using the Convert function. For more information on how to
use the Convert function, please see the Transact-SQL Reference guide.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack
4 for Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
| Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
|---|
| Keywords: | kbBug kbfix kbnetwork KB155710 |
|---|
|