{"action":"created","issue":{"url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/87","repository_url":"https://api.github.com/repos/ClickSimply/Nano-SQL","labels_url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/87/labels{/name}","comments_url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/87/comments","events_url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/87/events","html_url":"https://github.com/ClickSimply/Nano-SQL/issues/87","id":365989081,"node_id":"MDU6SXNzdWUzNjU5ODkwODE=","number":87,"title":"SQL Error: too many SQL variables","user":{"login":"MattNewberry","id":108004,"node_id":"MDQ6VXNlcjEwODAwNA==","avatar_url":"https://avatars0.githubusercontent.com/u/108004?v=4","gravatar_id":"","url":"https://api.github.com/users/MattNewberry","html_url":"https://github.com/MattNewberry","followers_url":"https://api.github.com/users/MattNewberry/followers","following_url":"https://api.github.com/users/MattNewberry/following{/other_user}","gists_url":"https://api.github.com/users/MattNewberry/gists{/gist_id}","starred_url":"https://api.github.com/users/MattNewberry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MattNewberry/subscriptions","organizations_url":"https://api.github.com/users/MattNewberry/orgs","repos_url":"https://api.github.com/users/MattNewberry/repos","events_url":"https://api.github.com/users/MattNewberry/events{/privacy}","received_events_url":"https://api.github.com/users/MattNewberry/received_events","type":"User","site_admin":false},"labels":[{"id":496077014,"node_id":"MDU6TGFiZWw0OTYwNzcwMTQ=","url":"https://api.github.com/repos/ClickSimply/Nano-SQL/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2018-10-02T16:54:18Z","updated_at":"2018-11-08T18:00:02Z","closed_at":null,"author_association":"NONE","body":"**Describe the bug**\r\nWhen using a table with a primary key and secondary index, `WebSQL` queries fail to execute on large-ish datasets.\r\n\r\n`SQLError {code: 5, message: \"could not prepare statement (1 too many SQL variables)\"}`\r\n\r\n**Example**\r\nWith a table consisting of 2 indexes and 7500 records, the following error occurs with the `WebSQL` adapater during the initial connect:\r\n\r\n`_this._sql(false, \"SELECT id FROM \" + table, [], function (result) {`\r\n\r\nError: \r\n```SELECT data from Vehicles WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, (7483) [392430, 392437, 392441, 392442, 392443, 392446, 392449, 392450, 392451, 392455, 392533, 392537, 392539, 392540, 392546, 392555, 392556, 392558, 392561, 392566, 392572, 392574, 392576, 392581, 392582, 392583, 392584, 392585, 392597, 392598, 392605, 392609, 392620, 392631, 392643, 392647, 392656, 392657, 392659, 392660, 392662, 392663, 392668, 392669, 392670, 392671, 392672, 392683, 392690, 392697, 392700, 392710, 392713, 392716, 392718, 392724, 392727, 392734, 392743, 392755, 392762, 392766, 392767, 392771, 392789, 392793, 392797, 392816, 392820, 392821, 392822, 392831, 392834, 392842, 392843, 392847, 392851, 392852, 392854, 392858, 392859, 392861, 392862, 392863, 392872, 392936, 392939, 392942, 392948, 392949, 392952, 392956, 392960, 392961, 392969, 392974, 392976, 392979, 392983, 392987, …] SQLError {code: 5, message: \"could not prepare statement (1 too many SQL variables)\"}```\r\n\r\n**Expected behavior**\r\nExpectation is for queries to execute correctly despite the data size and index count.\r\n"},"comment":{"url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/comments/437097071","html_url":"https://github.com/ClickSimply/Nano-SQL/issues/87#issuecomment-437097071","issue_url":"https://api.github.com/repos/ClickSimply/Nano-SQL/issues/87","id":437097071,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNzA5NzA3MQ==","user":{"login":"MattNewberry","id":108004,"node_id":"MDQ6VXNlcjEwODAwNA==","avatar_url":"https://avatars0.githubusercontent.com/u/108004?v=4","gravatar_id":"","url":"https://api.github.com/users/MattNewberry","html_url":"https://github.com/MattNewberry","followers_url":"https://api.github.com/users/MattNewberry/followers","following_url":"https://api.github.com/users/MattNewberry/following{/other_user}","gists_url":"https://api.github.com/users/MattNewberry/gists{/gist_id}","starred_url":"https://api.github.com/users/MattNewberry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MattNewberry/subscriptions","organizations_url":"https://api.github.com/users/MattNewberry/orgs","repos_url":"https://api.github.com/users/MattNewberry/repos","events_url":"https://api.github.com/users/MattNewberry/events{/privacy}","received_events_url":"https://api.github.com/users/MattNewberry/received_events","type":"User","site_admin":false},"created_at":"2018-11-08T18:00:02Z","updated_at":"2018-11-08T18:00:02Z","author_association":"NONE","body":"My last attempt at build my fix did not work, however I directly applied your `Adapter-Sqlite3` fixes to the `Adapter-Sqlite-Cordova` module and it now appears to work. Please see attached PR. "}}
{"actor":{"display_login":"MattNewberry"}}