{"action":"created","issue":{"url":"https://api.github.com/repos/jdbi/jdbi/issues/154","labels_url":"https://api.github.com/repos/jdbi/jdbi/issues/154/labels{/name}","comments_url":"https://api.github.com/repos/jdbi/jdbi/issues/154/comments","events_url":"https://api.github.com/repos/jdbi/jdbi/issues/154/events","html_url":"https://github.com/jdbi/jdbi/issues/154","id":79218120,"number":154,"title":"Null handling Mappers of for boxed types","user":{"login":"nileema","id":1034143,"avatar_url":"https://avatars.githubusercontent.com/u/1034143?v=3","gravatar_id":"","url":"https://api.github.com/users/nileema","html_url":"https://github.com/nileema","followers_url":"https://api.github.com/users/nileema/followers","following_url":"https://api.github.com/users/nileema/following{/other_user}","gists_url":"https://api.github.com/users/nileema/gists{/gist_id}","starred_url":"https://api.github.com/users/nileema/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nileema/subscriptions","organizations_url":"https://api.github.com/users/nileema/orgs","repos_url":"https://api.github.com/users/nileema/repos","events_url":"https://api.github.com/users/nileema/events{/privacy}","received_events_url":"https://api.github.com/users/nileema/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/jdbi/jdbi/milestones/2","html_url":"https://github.com/jdbi/jdbi/milestones/JDBI%203%20Requests","labels_url":"https://api.github.com/repos/jdbi/jdbi/milestones/2/labels","id":382959,"number":2,"title":"JDBI 3 Requests","description":"Bucket for issues that should be in JDBI 3","creator":{"login":"stevenschlansker","id":129097,"avatar_url":"https://avatars.githubusercontent.com/u/129097?v=3","gravatar_id":"","url":"https://api.github.com/users/stevenschlansker","html_url":"https://github.com/stevenschlansker","followers_url":"https://api.github.com/users/stevenschlansker/followers","following_url":"https://api.github.com/users/stevenschlansker/following{/other_user}","gists_url":"https://api.github.com/users/stevenschlansker/gists{/gist_id}","starred_url":"https://api.github.com/users/stevenschlansker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stevenschlansker/subscriptions","organizations_url":"https://api.github.com/users/stevenschlansker/orgs","repos_url":"https://api.github.com/users/stevenschlansker/repos","events_url":"https://api.github.com/users/stevenschlansker/events{/privacy}","received_events_url":"https://api.github.com/users/stevenschlansker/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":0,"state":"open","created_at":"2013-07-20T23:48:16Z","updated_at":"2015-05-22T21:46:51Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2015-05-22T00:30:56Z","updated_at":"2015-10-09T02:50:31Z","closed_at":null,"body":"Mappers for boxed types (LongMapper, ShortMapper, DoubleMapper, etc) return `0` if the column value was `null`. As a consequence, the SqlQuery returning a boxed type may return a `0` or `null` based on whether the column value. There is no way to know if the column value was actually `0` or `null`. \r\nWe can change the Mapper to do the following\r\n```java\r\n        long l = r.getLong(name);\r\n        if (r.wasNull()) {\r\n            return null;\r\n        }\r\n        return l;\r\n```\r\nHowever that is a backwards incompatible change and does not provide a way to differentiate between `NULL` was found and no rows were found. \r\n"},"comment":{"url":"https://api.github.com/repos/jdbi/jdbi/issues/comments/146740922","html_url":"https://github.com/jdbi/jdbi/issues/154#issuecomment-146740922","issue_url":"https://api.github.com/repos/jdbi/jdbi/issues/154","id":146740922,"user":{"login":"qualidafial","id":38629,"avatar_url":"https://avatars.githubusercontent.com/u/38629?v=3","gravatar_id":"","url":"https://api.github.com/users/qualidafial","html_url":"https://github.com/qualidafial","followers_url":"https://api.github.com/users/qualidafial/followers","following_url":"https://api.github.com/users/qualidafial/following{/other_user}","gists_url":"https://api.github.com/users/qualidafial/gists{/gist_id}","starred_url":"https://api.github.com/users/qualidafial/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qualidafial/subscriptions","organizations_url":"https://api.github.com/users/qualidafial/orgs","repos_url":"https://api.github.com/users/qualidafial/repos","events_url":"https://api.github.com/users/qualidafial/events{/privacy}","received_events_url":"https://api.github.com/users/qualidafial/received_events","type":"User","site_admin":false},"created_at":"2015-10-09T02:50:31Z","updated_at":"2015-10-09T02:50:31Z","body":"With the merge of #182 this issue should be fixed, and could be closed."}}