{"action":"created","issue":{"url":"https://api.github.com/repos/SOCI/soci/issues/674","repository_url":"https://api.github.com/repos/SOCI/soci","labels_url":"https://api.github.com/repos/SOCI/soci/issues/674/labels{/name}","comments_url":"https://api.github.com/repos/SOCI/soci/issues/674/comments","events_url":"https://api.github.com/repos/SOCI/soci/issues/674/events","html_url":"https://github.com/SOCI/soci/issues/674","id":352026898,"node_id":"MDU6SXNzdWUzNTIwMjY4OTg=","number":674,"title":"SQLite3 does not support multiple SQL statements in one call","user":{"login":"M-Fabian","id":19340932,"node_id":"MDQ6VXNlcjE5MzQwOTMy","avatar_url":"https://avatars0.githubusercontent.com/u/19340932?v=4","gravatar_id":"","url":"https://api.github.com/users/M-Fabian","html_url":"https://github.com/M-Fabian","followers_url":"https://api.github.com/users/M-Fabian/followers","following_url":"https://api.github.com/users/M-Fabian/following{/other_user}","gists_url":"https://api.github.com/users/M-Fabian/gists{/gist_id}","starred_url":"https://api.github.com/users/M-Fabian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/M-Fabian/subscriptions","organizations_url":"https://api.github.com/users/M-Fabian/orgs","repos_url":"https://api.github.com/users/M-Fabian/repos","events_url":"https://api.github.com/users/M-Fabian/events{/privacy}","received_events_url":"https://api.github.com/users/M-Fabian/received_events","type":"User","site_admin":false},"labels":[{"id":27086978,"node_id":"MDU6TGFiZWwyNzA4Njk3OA==","url":"https://api.github.com/repos/SOCI/soci/labels/Category/Annoyance","name":"Category/Annoyance","color":"e102d8","default":false},{"id":200718795,"node_id":"MDU6TGFiZWwyMDA3MTg3OTU=","url":"https://api.github.com/repos/SOCI/soci/labels/Priority/Low","name":"Priority/Low","color":"fef2c0","default":false},{"id":17801813,"node_id":"MDU6TGFiZWwxNzgwMTgxMw==","url":"https://api.github.com/repos/SOCI/soci/labels/SQLite","name":"SQLite","color":"BFFF00","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-20T08:06:55Z","updated_at":"2018-08-20T10:17:33Z","closed_at":null,"author_association":"NONE","body":"The SQLite3 backend does not support multiple SQL statements in one call, e.g.\r\n```CREATE TABLE Table1(Foo TEXT);CREATE TABLE Table2(Bar TEXT);```\r\nOnly the first statement is processed. I went into the debugger and found the reason:\r\n\r\nsoci-3.2.3/backends/sqlite3/statement.cpp, line 57: The tail of `sqlite3_prepare_v2` is ignored. Hence only the first SQL statement in the string is processed. The PostgreSQL backend does this correctly, so I consider this a bug of the SQLite3 backend. The backend should process the given string until an error occurs or the tail is empty."},"comment":{"url":"https://api.github.com/repos/SOCI/soci/issues/comments/414267926","html_url":"https://github.com/SOCI/soci/issues/674#issuecomment-414267926","issue_url":"https://api.github.com/repos/SOCI/soci/issues/674","id":414267926,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNDI2NzkyNg==","user":{"login":"vadz","id":146917,"node_id":"MDQ6VXNlcjE0NjkxNw==","avatar_url":"https://avatars0.githubusercontent.com/u/146917?v=4","gravatar_id":"","url":"https://api.github.com/users/vadz","html_url":"https://github.com/vadz","followers_url":"https://api.github.com/users/vadz/followers","following_url":"https://api.github.com/users/vadz/following{/other_user}","gists_url":"https://api.github.com/users/vadz/gists{/gist_id}","starred_url":"https://api.github.com/users/vadz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vadz/subscriptions","organizations_url":"https://api.github.com/users/vadz/orgs","repos_url":"https://api.github.com/users/vadz/repos","events_url":"https://api.github.com/users/vadz/events{/privacy}","received_events_url":"https://api.github.com/users/vadz/received_events","type":"User","site_admin":false},"created_at":"2018-08-20T10:17:33Z","updated_at":"2018-08-20T10:17:33Z","author_association":"MEMBER","body":"Interesting, I had no idea that multiple statements per call were supported, to be honest. Is there any advantage in supporting it, compared to just telling people to use 2 statements?"}}
{"actor":{"display_login":"vadz"}}