> The documentation says: > **"Warning: misuse of this pragma can easily result in a corrupt database > file."**
But it would be nice if corrupted database didn't crash the application ;) 2018-05-20 16:05 GMT+02:00, Clemens Ladisch : > Abroży Nieprzełoży wrote: >> sqlite> PRAGMA writable_schema=1; > > The documentation says: > **"Warning: misuse of this pragma can easily result in a corrupt database > file."** > >> sqlite> CREATE TABLE xqlite_sequence(name TEXT PRIMARY KEY, seq INTEGER) >> WITHOUT ROWID; > > SQLite does not use SQL but raw VDBE commands update the row in the > sqlite_sequence > table (see autoIncBegin() and autoIncrementENd() in insert.c). Without the > rowid, > that code no longer works. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
