Arithmetic Overflow

Hi,

This is still happening. Although the calculated results seem ok it still worries me a bit. All DB fields involved have a precision of 19 and scale of 2.

Asked this question before here: Decimal scaling is not adjusted in the DB and Overflow exception

alt text

Regards Paul

1: http://support.x-tensive.com/upfiles/Arithmetic Overflow Problem_2.png

decimals

asked Nov 28 '14 at 05:30

Paul Sinnema
261●88●88●96

edited Nov 28 '14 at 05:33

Uploading images does not work for some reason

(Nov 28 '14 at 05:31) Paul Sinnema

One Answer:

oldest newest most voted

Hello Paul

This is internal behavior of some comparison operators of SqlDecimal. According my experiments, it happens when difference between scales or compared SqlDecimals is more than 9. But this exception catches on higher level (see image bellow).

answered Dec 02 '14 at 05:43

Alexey Kulakov
772●2●5

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

decimals ×1

Asked: Nov 28 '14 at 05:30

Seen: 4,201 times

Last updated: Dec 02 '14 at 05:43

Subscription:

Related questions