insert maximum value into 'money' column fails - "Arithmetic overflow error converting expression to data type money" #38

Closed
wread opened this Issue Jul 23, 2012 · 4 comments

Projects

None yet

3 participants

@wread
Contributor
wread commented Jul 23, 2012

Here's the test's log:

CREATE TABLE types_table (id int identity, col2  money)
INSERT INTO types_table (col2) VALUES (null)
INSERT INTO types_table (col2) VALUES (-922337203685477.6)
SELECT * FROM types_table ORDER BY id
assert.js:10444: Uncaught Error: 22003: [Microsoft][SQL Server Native Client 11.
0][SQL Server]Arithmetic overflow error converting numeric to data type money.
@wread wread was assigned Oct 11, 2012
@raol
raol commented Oct 21, 2013

And again inserted value is less than money minimum value according to TechNet
Here is what I have in SQL Studio

INSERT INTO types_table (col2) VALUES (-922337203685477.6)
Msg 8115, Level 16, State 4, Line 4
Arithmetic overflow error converting numeric to data type money.

Though following valid statement is completed successfully

INSERT INTO types_table (col2) VALUES (-922337203685477.5808)
(1 row(s) affected)
@jkint
Contributor
jkint commented Oct 21, 2013

Okay. I will look at it. Thanks.

@raol
raol commented Oct 21, 2013

I believe it can be closed, because value from the original bug description should fail the query, because the value is out of allowed range. 0.6 > 0.5808

@jkint
Contributor
jkint commented Oct 28, 2013

Thanks for the clarification. I'm closing this issue.

@jkint jkint closed this Oct 28, 2013
@wread wread removed their assignment Apr 1, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment