Comment 52 for bug 457791

Revision history for this message
In , Drh (drh) wrote :

FYI: The defect in the SQLITE_SECURE_DELETE implementation of SQLite turned
out to be obscure - much more obscure than I originally thought and reported
to Shawn. The only way that deleted content would fail to be
overwritten with zeros is when all of the content for an entire table fit on a
single database page and the entire table was deleted using "DELETE FROM table"
with no WHERE clause. In other words, very small tables, deleted in total all
at once, might not get overwritten. But as far as we can see now, content is
correctly zeroed-out in all other cases. The defect will be fixed in SQLite
3.6.21.