{"action":"created","issue":{"url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/117","repository_url":"https://api.github.com/repos/xerial/sqlite-jdbc","labels_url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/117/labels{/name}","comments_url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/117/comments","events_url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/117/events","html_url":"https://github.com/xerial/sqlite-jdbc/issues/117","id":159522103,"number":117,"title":"NULL returned from ResultSet.getBytes() from a NOT NULL column","user":{"login":"archiecobbs","id":545866,"avatar_url":"https://avatars.githubusercontent.com/u/545866?v=3","gravatar_id":"","url":"https://api.github.com/users/archiecobbs","html_url":"https://github.com/archiecobbs","followers_url":"https://api.github.com/users/archiecobbs/followers","following_url":"https://api.github.com/users/archiecobbs/following{/other_user}","gists_url":"https://api.github.com/users/archiecobbs/gists{/gist_id}","starred_url":"https://api.github.com/users/archiecobbs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/archiecobbs/subscriptions","organizations_url":"https://api.github.com/users/archiecobbs/orgs","repos_url":"https://api.github.com/users/archiecobbs/repos","events_url":"https://api.github.com/users/archiecobbs/events{/privacy}","received_events_url":"https://api.github.com/users/archiecobbs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-06-09T22:23:53Z","updated_at":"2016-06-15T07:15:08Z","closed_at":null,"body":"I've run into a case where `ResultSet.getBytes()` is returning `null`, even though the column contains a non null value and in fact the column has a `NOT NULL` constraint.\r\n\r\nHere is a reproducible test case: https://gist.github.com/archiecobbs/6b7a2019ecc1b1198e54787261282689\r\n\r\nWhen I run this test, I get this result:\r\n```\r\n$ ./run.sh \r\n+ CP=.\r\n+ CP=.:sqlite-jdbc-3.8.11.2.jar\r\n+ javac -classpath .:sqlite-jdbc-3.8.11.2.jar Test.java\r\n+ java -classpath .:sqlite-jdbc-3.8.11.2.jar Test foobar.sqlite3\r\nconfiguring SQLite DataSource using URI: jdbc:sqlite:/Users/archie/bugs/sqlite-jdbc-bug/foobar.sqlite3\r\nkey=[B@26eeda37 val=null\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/comments/226107002","html_url":"https://github.com/xerial/sqlite-jdbc/issues/117#issuecomment-226107002","issue_url":"https://api.github.com/repos/xerial/sqlite-jdbc/issues/117","id":226107002,"user":{"login":"magnusr","id":5188162,"avatar_url":"https://avatars.githubusercontent.com/u/5188162?v=3","gravatar_id":"","url":"https://api.github.com/users/magnusr","html_url":"https://github.com/magnusr","followers_url":"https://api.github.com/users/magnusr/followers","following_url":"https://api.github.com/users/magnusr/following{/other_user}","gists_url":"https://api.github.com/users/magnusr/gists{/gist_id}","starred_url":"https://api.github.com/users/magnusr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/magnusr/subscriptions","organizations_url":"https://api.github.com/users/magnusr/orgs","repos_url":"https://api.github.com/users/magnusr/repos","events_url":"https://api.github.com/users/magnusr/events{/privacy}","received_events_url":"https://api.github.com/users/magnusr/received_events","type":"User","site_admin":false},"created_at":"2016-06-15T07:15:08Z","updated_at":"2016-06-15T07:15:08Z","body":"Does this fix your issue?\r\n[0001-Handle-empty-blobs.patch.zip](https://github.com/xerial/sqlite-jdbc/files/315576/0001-Handle-empty-blobs.patch.zip)\r\n"}}
{"actor":{"display_login":"magnusr"}}