On 3/16/15, Simon Slavin <slavins at bigfraud.org> wrote:
>
> Because of the format in which SQLite keeps its indexes, you
> cannot always repair a corrupted index by deleting the rows which you think
> are corrupt.  Sometimes you need to delete other rows too (for example those
> immediately before and after a corrupt row) and you need detailed analysis
> of what's wrong with the index to know exactly what you need to delete.

But you can always repair corruption in indexes using the "REINDEX" command.

-- 
D. Richard Hipp
drh at sqlite.org

Reply via email to