Re: [sqlite] Integrity check reliability

[Simon Slavin]

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

[sqlite] Integrity check reliability

[Verstappen, Jos]

Dear SQLite users,

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.


Thank you!
Jos

This message and attachment(s) are intended solely for use by the addressee and 
may contain information that is privileged, confidential or otherwise exempt 
from disclosure under applicable law.

If you are not the intended recipient or agent thereof responsible for 
delivering this message to the intended recipient, you are hereby notified that 
any dissemination, distribution or copying of this communication is strictly 
prohibited.

If you have received this communication in error, please notify the sender 
immediately by telephone and with a 'reply' message.

Thank you for your co-operation.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users