{"action":"created","issue":{"url":"https://api.github.com/repos/rstats-db/RSQLite/issues/141","repository_url":"https://api.github.com/repos/rstats-db/RSQLite","labels_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/141/labels{/name}","comments_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/141/comments","events_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/141/events","html_url":"https://github.com/rstats-db/RSQLite/issues/141","id":157998919,"number":141,"title":"dbListResults() on new RSQLite connection has length 1","user":{"login":"nimame","id":5930886,"avatar_url":"https://avatars.githubusercontent.com/u/5930886?v=3","gravatar_id":"","url":"https://api.github.com/users/nimame","html_url":"https://github.com/nimame","followers_url":"https://api.github.com/users/nimame/followers","following_url":"https://api.github.com/users/nimame/following{/other_user}","gists_url":"https://api.github.com/users/nimame/gists{/gist_id}","starred_url":"https://api.github.com/users/nimame/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nimame/subscriptions","organizations_url":"https://api.github.com/users/nimame/orgs","repos_url":"https://api.github.com/users/nimame/repos","events_url":"https://api.github.com/users/nimame/events{/privacy}","received_events_url":"https://api.github.com/users/nimame/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/rstats-db/RSQLite/milestones/3","html_url":"https://github.com/rstats-db/RSQLite/milestones/1.1","labels_url":"https://api.github.com/repos/rstats-db/RSQLite/milestones/3/labels","id":1868599,"number":3,"title":"1.1","description":"Intermediate release with updated SQLite and DBI compatibility","creator":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars.githubusercontent.com/u/1741643?v=3","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":2,"state":"open","created_at":"2016-07-06T21:10:17Z","updated_at":"2016-08-21T21:51:01Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-06-01T20:25:31Z","updated_at":"2016-08-22T15:27:46Z","closed_at":null,"body":"When I create a new database like this:\r\n```\r\n> require(RSQLite)\r\n> con <- dbConnect(dbDriver(\"SQLite\"), dbname='sqlite.db'))\r\n```\r\nand then run `dbListResults`:\r\n```\r\n> dbListResults(con)\r\n[[1]]\r\n<SQLiteResult>\r\n```\r\nThere seems to be an SQLiteResult. Running `fetch` or `dbClearResults` on that SQLiteResult gives an error:\r\n```\r\n> fetch(dbListResults(con)[[1]])\r\nError: Expired SQLiteResult\r\n> dbClearResult(dbListResults(con)[[1]])\r\nError: Expired SQLiteResult\r\n```\r\nIs this a bug? This would break all my code that expects `length(dbListResults(con))==0` when there is no SQLiteResult, that has not been fetched.\r\n\r\nMy System:\r\n- OS: Windows 10 64Bit\r\n- R version 3.3.0\r\n- RSQLite 1.0.0\r\n- DBI 0.4-1 \r\n\r\nCopied from: http://stackoverflow.com/questions/37574040/why-does-dblistresults-on-fresh-rsqlite-connection-issue-a-list-of-length-1-inst"},"comment":{"url":"https://api.github.com/repos/rstats-db/RSQLite/issues/comments/241450291","html_url":"https://github.com/rstats-db/RSQLite/issues/141#issuecomment-241450291","issue_url":"https://api.github.com/repos/rstats-db/RSQLite/issues/141","id":241450291,"user":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars.githubusercontent.com/u/1741643?v=3","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"created_at":"2016-08-22T15:27:46Z","updated_at":"2016-08-22T15:27:46Z","body":"Can't get rid of dbListResults() just yet."}}
{"actor":{"display_login":"krlmlr"}}