Reported on the mailing list. When making a dump the SQL text from sqlite_master is taken as is and a semi-colon appended. For tables, triggers and indexes SQLite strips trailing comments before putting their text into sqlite_master. However this is not done for views. Consequently the view text can end up like:
<pre>create view ...... -- a comment</pre>
When this is dumped the trailing comment swallows any semicolon appended.
Mailing list thread: <a href="http://thread.gmane.org/gmane.comp.db.sqlite.general/71502">http://thread.gmane.org/gmane.comp.db.sqlite.general/71502</a>
|