{"issue":{"milestone":null,"title":"[FRG-46] decimal arithmetic does not handle overflow","created_at":"2011-12-30T03:51:07Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"FRG","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/FRG","color":"1f8f0d"}],"updated_at":"2011-12-30T03:51:08Z","state":"closed","id":2686385,"closed_at":"2011-12-30T03:51:08Z","html_url":"https://github.com/dynamobi/dynamobi/issues/824","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"schoi\", created=\"Thu, 16 Feb 2006 16:11:55 -0500 (GMT-05:00)\"]</i></b>\nrelated to <a href=\"http://jira.eigenbase.org/browse/LDB-21\" title=\"Neither Java nor Fennel calc handles arithmetic overflow\">LDB-21</a>, but not sure if a fix for that will automatically fix this too..<br/>\n<br/>\nWith any decimal overflow, there is no exception or warning; the overflow value is just stored and/or returned.<br/>\n<br/>\nRepro:<br/>\n------------<br/>\ncreate schema s;<br/>\nset schema 's';<br/>\n<br/>\ncreate table t1(a decimal(19,18) primary key);<br/>\ninsert into t1 values(1);<br/>\n<br/>\n-- below queries should throw exceptions but don't:<br/>\n<br/>\nselect a+10 from t1;<br/>\n<br/>\n+------------------------+<br/>\n| EXPR$0 |<br/>\n+------------------------+<br/>\n| -7.446744073709551616  |<br/>\n+------------------------+<br/>\n<br/>\n<br/>\ninsert into t1 values(10);<br/>\nselect * from t1;<br/>\n<br/>\n+------------------------+<br/>\n|   A    |<br/>\n+------------------------+<br/>\n| -8.446744073709551616  |<br/>\n| 1.000000000000000000   |<br/>\n+------------------------+<br/>\n","number":824,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/824","comments":0,"assignee":null},"action":"closed"}