btw 'PRAGMA integrity_check;' returns 'ok'
2018-05-20 18:27 GMT+02:00, Abroży Nieprzełoży : >> 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
