On 14 Nov 2011, at 1:19pm, Verstappen, Jos wrote: > Can anyone confirm that the command "PRAGMA integrity_check;" will not > crash the SQLite code on a corrupt database? > I made a corrupt database on purpose to test, it seems to run ok. The > command neatly reports the corruption. But this is just one try.
The code is designed to do lots of testing and not make any assumptions. However, it's possible that you'll find some weird situation the programmers never thought of. There's no way you're ever going to get the SQLite team to say that it's completely bug-free. However, there are very few reasons to put that call in to production code anyway. I would expect to see it only in utilities used by whoever wrote the SQLite software. If your software or hardware is so poor that it continually corrupts the SQLite database you should be paying personal attention. So of all the places in SQLite to put code which can crash, this is probably the best ! Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
