{"action":"opened","issue":{"url":"https://api.github.com/repos/patriksimek/node-mssql/issues/529","repository_url":"https://api.github.com/repos/patriksimek/node-mssql","labels_url":"https://api.github.com/repos/patriksimek/node-mssql/issues/529/labels{/name}","comments_url":"https://api.github.com/repos/patriksimek/node-mssql/issues/529/comments","events_url":"https://api.github.com/repos/patriksimek/node-mssql/issues/529/events","html_url":"https://github.com/patriksimek/node-mssql/issues/529","id":256982262,"number":529,"title":"Retrieving numeric(13) returns value that's +/- 1 off original","user":{"login":"rgillan","id":591788,"avatar_url":"https://avatars0.githubusercontent.com/u/591788?v=4","gravatar_id":"","url":"https://api.github.com/users/rgillan","html_url":"https://github.com/rgillan","followers_url":"https://api.github.com/users/rgillan/followers","following_url":"https://api.github.com/users/rgillan/following{/other_user}","gists_url":"https://api.github.com/users/rgillan/gists{/gist_id}","starred_url":"https://api.github.com/users/rgillan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgillan/subscriptions","organizations_url":"https://api.github.com/users/rgillan/orgs","repos_url":"https://api.github.com/users/rgillan/repos","events_url":"https://api.github.com/users/rgillan/events{/privacy}","received_events_url":"https://api.github.com/users/rgillan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-09-12T09:46:00Z","updated_at":"2017-09-12T09:46:00Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\nVery simple query from a third party database replica (SQL Server 2014).  One of the columns TxNo has a numeric(13) data type.  The data value is large, typically 9120904524579417, 9120904500323084 etc.\r\n\r\nWhen we get the response data, the value is out by +/- 1, e.g.\r\n[{\"TxNo\":9120904524579416}].\r\n\r\nIf someone has an idea how to fix this it would be very much appreciated.  Not sure if it's because the value is past the javascript max safe integer (9007199254740991)?  It's causing a lot of grief as we need this to be accurate.  Happy for it to be returned as a string if that's an option.\r\n\r\nThanks\r\nRob"}}
{"actor":{"display_login":"rgillan"}}