Integer and decimal operands
If one operand is an integer with zero scale and the other is decimal, the operation is performed in decimal using a temporary copy of the integer that has been converted to a decimal number with precision and scale 0.
This is defined in the following table:
Operand | Precision of Decimal Copy |
---|---|
Column or variable: big integer | 19 |
Column or variable: large integer | 11 |
Column or variable: small integer | 5 |
Constant (including leading zeros) | Same as the number of digits in the constant |
If one operand is an integer with nonzero scale, it is first converted to a decimal operand with the same precision and scale.