On 1 Mar 2017, at 12:28pm, Edwin Yip <edwin....@innovationgear.com> wrote:
> B - The "VACCUM" only fix the issue for a table, but the very same issue > retains for another table. If you have a case where VACUUM does not fix a faulty index, that would be very interesting. However, we would need a copy of the unfixed version of the database. Crashes in your program should not be able to corrupt your database. I’m not saying that it’s completely impossible, just that it’s very unexpected. Are you doing any of the things mentioned here ? <https://www.sqlite.org/howtocorrupt.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users