Hello ! Working with sqlite3 I noticed that sqlite3 ".dump", ".schema" and ".fullschema" outputs the contents of the field "sql" stored in "sqlite_master" and if the sql statement ends with a comment the resulted dump will be invalid see example:
=========== valid sql statement stored on sqlite_master CREATE VIEW "event_event_ticket_list_view" AS SELECT a."id", a."name", a."price", a."deadline", a."seats_max", a."product_id", a."event_id" FROM "event_event_ticket" AS a --LEFT JOIN "product_product" AS b ON a."product_id" = b."id" =========== ? Sqlite3 only adds a semicolon to the value of "sql" field and in this case we have an unterminated statement. =========== the above sql statement dumped by sqlite3 CREATE VIEW "event_event_ticket_list_view" AS SELECT a."id", a."name", a."price", a."deadline", a."seats_max", a."product_id", a."event_id" FROM "event_event_ticket" AS a --LEFT JOIN "product_product" AS b ON a."product_id" = b."id";?? <<<<<<<<< here is the problem =========== ? Cheers !
