I wrote a test program to deliberately trash a database file, and then see if "PRAGMA integrity_check" could detect the corruption.
The only thing I found that works is writing beyond the end of the file. Writing to the beginning of the file (the first 40 bytes or so) corrupts the database so badly that SQLite can't even execute the pragma. Writing to the middle of the file -- even a large swath of garbage -- does undetected by the pragma. I was hoping that the integrity checking pragma would be more robust than this. Am I missing something? Thanks, - Richard Klein _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
