/ View Ticket
Ticket Hash: c04a8b8a4f0c154cfdbd8a4a3086d04c7ed04027
Title: Trailing comments not stripped from views, invalid dumps
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2012-01-28 21:09:09
Version Found In: 3.7.10
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>