On 7 Feb 2019, at 3:51pm, Ludovic Gasc Lemaire <[email protected]> wrote:
> When I launch this SQL query:
> DELETE FROM astdb WHERE key LIKE '%SIP%';
>
> It deletes between 3 and 40 lines, but not all lines.
> And each time I launch this SQL query, it removes between 3 and 40 other
> lines, but not all lines.
Please run
PRAGMA integrity_check
on the database. If that doesn't spot anythnig wrong, can you prepare a small
sample database so we can reproduce the problem ?
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users