tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
https://turso.tech/libsql
MIT License
11.25k stars 286 forks source link

Import fails when there are multiline statements in the dump #1562

Closed avinassh closed 4 months ago

avinassh commented 4 months ago
$ turso db create mydb --from-file local.db

Error: could not create database mydb: received incomplete input error from database.
This happens when an SQL statement is incomplete or broken over multiple lines.
Multi-line triggers are a common cause of this issue.
Please check your database dump for such statements

temporary workaround: find the multiline statements (lines which don't end with ;) and merge them into one

avinassh commented 4 months ago

dupe of #613