On 19 May 2015, at 4:23pm, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote:
> I guess not good: > > sqlite> PRAGMA integrity_check; > integrity_check > ------------------------------------------------- > row 37 missing from index sqlite_autoindex_Exam_1 There you go. Problem diagnosed. Use the SQLite shell tool. Do a .dump of the existing database to a text file. Read the text file by eye to see if it looks okay. Do a .read of the text file into a new empty database. See if there are any error messages. If not, try your original test again and see if it passes this time. On 19 May 2015, at 4:43pm, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: > Now I have two questions: > > 1. I created database from scratch using new version of SQLITE and PRAGMA > integrity_check; produces "missing index" as before. Are you telling us that you have a sequence of commands which, done entirely inside the SQLite shell tool, produce a corrupt database ? If so, please please please try to find a short set of commands which produce the error and post them here. With regard to your other question, if the database is corrupt all bets are off. There's no predicting what any commands or clauses will do. Simon.
