On 1 Mar 2017, at 1:52pm, Richard Hipp <[email protected]> wrote: > On 3/1/17, Simon Slavin <[email protected]> wrote: > >> If you have a case where VACUUM does not fix a faulty index, that would be >> very interesting. > > Not necessarily. VACUUM does not recreate the indexes, it just copies > them, row by row. So if the index is self-consistent but it does not > match its table (it has extra rows and/or is missing rows) then VACUUM > won't fix it.
Ah. Okay, thanks for the correction. Edwin, ignore that bit. Sorry to waste your time. So I learned something today: VACUUM does not guarantee an uncorrupt database. Interesting. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
