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

asked Nov 28 '14 at 05:30

Paul%20Sinnema's gravatar image

Paul Sinnema

edited Nov 28 '14 at 05:33

Uploading images does not work for some reason

(Nov 28 '14 at 05:31) Paul Sinnema Paul%20Sinnema's gravatar image

One Answer:

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%20Kulakov's gravatar image

Alexey Kulakov

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


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



Asked: Nov 28 '14 at 05:30

Seen: 4,201 times

Last updated: Dec 02 '14 at 05:43

Related questions

powered by OSQA