New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

too many SQL variables #111

Open

razpeitia opened this issue Feb 12, 2019 · 0 comments

razpeitia commented Feb 12, 2019

I'm getting this error because I'm trying to insert around 2000 columns. Which is within the default limit for sqlite3.

I noticed that this is because the maximum number of SQL variables (999 by default).

and this is because the way you insert the rows. I think this should be done in batches.
https://github.com/dinedal/textql/blob/master/storage/sqlite.go#L151-L160

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment