Re: [sqlite] Problem to delete all data with a LIKE

[Ludovic Gasc Lemaire]

Hi Simon,

Thanks for your tip, this command has found problems, see below.
It should explain this strange behavior with DELETE ?

I have found this procedure on the Web to fix the file:
https://www.2doapp.com/kb/article.php?id=743&oid=38

Is it the correct way or another way exists ?

Kind regards.

*** in database main ***
On tree page 290 cell 13: Rowid 21980476 out of order
On tree page 290 cell 6: Rowid 21980466 out of order
On tree page 290 cell 5: Rowid 21980467 out of order
On tree page 290 cell 4: Rowid 21980468 out of order
On tree page 290 cell 3: Rowid 21980468 out of order
On tree page 290 cell 2: Rowid 21980468 out of order
On tree page 290 cell 1: Rowid 21980469 out of order
On tree page 290 cell 0: Rowid 21980474 out of order
On tree page 289 cell 15: Rowid 21980442 out of order
On tree page 289 cell 14: Rowid 21980445 out of order
On tree page 289 cell 13: Rowid 21980448 out of order
On tree page 289 cell 12: Rowid 21980450 out of order
On tree page 289 cell 11: Rowid 21980450 out of order
On tree page 289 cell 10: Rowid 21980450 out of order
On tree page 289 cell 7: Rowid 21980448 out of order
On tree page 289 cell 6: Rowid 21980449 out of order
On tree page 288 cell 23: Rowid 21980426 out of order
On tree page 288 cell 22: Rowid 21980426 out of order
On tree page 288 cell 21: Rowid 21980426 out of order
On tree page 288 cell 20: Rowid 21980429 out of order
On tree page 288 cell 19: Rowid 21980429 out of order
On tree page 288 cell 18: Rowid 21980429 out of order
On tree page 288 cell 17: Rowid 21980429 out of order
On tree page 288 cell 16: Rowid 21980429 out of order
On tree page 288 cell 15: Rowid 21980432 out of order
On tree page 288 cell 14: Rowid 21980434 out of order
On tree page 288 cell 7: Rowid 21980415 out of order
On tree page 288 cell 6: Rowid 21980418 out of order
On tree page 287 cell 20: Rowid 21980410 out of order
On tree page 287 cell 7: Rowid 21980401 out of order
On tree page 287 cell 6: Rowid 21980402 out of order
On tree page 287 cell 5: Rowid 21980408 out of order
On tree page 286 cell 28: Rowid 21980386 out of order
On tree page 286 cell 27: Rowid 21980386 out of order
On tree page 286 cell 26: Rowid 21980388 out of order
On tree page 286 cell 25: Rowid 21980388 out of order
On tree page 286 cell 24: Rowid 21980393 out of order
On tree page 286 cell 23: Rowid 21980394 out of order
On tree page 286 cell 22: Rowid 21980396 out of order
On tree page 286 cell 21: Rowid 21980396 out of order
On tree page 286 cell 20: Rowid 21980400 out of order
On tree page 286 cell 19: Rowid 21980410 out of order
On tree page 286 cell 16: Rowid 21980408 out of order
On tree page 286 cell 15: Rowid 21980410 out of order
On tree page 286 cell 14: Rowid 21980410 out of order
On tree page 286 cell 13: Rowid 21980410 out of order
On tree page 286 cell 12: Rowid 21980410 out of order
On tree page 286 cell 11: Rowid 21980410 out of order
On tree page 286 cell 10: Rowid 21980410 out of order
On tree page 286 cell 9: Rowid 21980410 out of order
On tree page 286 cell 8: Rowid 21980410 out of order
On tree page 286 cell 7: Rowid 21980410 out of order
On tree page 286 cell 6: Rowid 21980411 out of order
On tree page 286 cell 5: Rowid 21980411 out of order
On tree page 286 cell 4: Rowid 21980411 out of order
On tree page 286 cell 3: Rowid 21980411 out of order
On tree page 286 cell 2: Rowid 21980411 out of order
On tree page 286 cell 1: Rowid 21980411 out of order
On tree page 286 cell 0: Rowid 21980411 out of order
On tree page 2 cell 281: Rowid 21980411 out of order
On tree page 285 cell 28: Rowid 21980411 out of order
On tree page 285 cell 27: Rowid 21980411 out of order
On tree page 285 cell 26: Rowid 21980411 out of order
On tree page 285 cell 25: Rowid 21980416 out of order
On tree page 285 cell 23: Rowid 21980411 out of order
On tree page 285 cell 22: Rowid 21980411 out of order
On tree page 285 cell 21: Rowid 21980411 out of order
On tree page 285 cell 20: Rowid 21980411 out of order
On tree page 285 cell 19: Rowid 21980411 out of order
On tree page 285 cell 18: Rowid 21980411 out of order
On tree page 285 cell 17: Rowid 21980412 out of order
On tree page 285 cell 16: Rowid 21980413 out of order
On tree page 285 cell 15: Rowid 21980414 out of order
On tree page 285 cell 14: Rowid 21980415 out of order
On tree page 285 cell 13: Rowid 21980415 out of order
On tree page 285 cell 12: Rowid 21980416 out of order
On tree page 285 cell 11: Rowid 21980416 out of order
On tree page 285 cell 10: Rowid 21980416 out of order
On tree page 285 cell 9: Rowid 21980416 out of order
On tree page 285 cell 8: Rowid 21980417 out of order
On tree page 285 cell 7: Rowid 21980418 out of order
On tree page 285 cell 6: Rowid 21980425 out of order
On tree page 285 cell 4: Rowid 21980418 out of order
On tree page 285 cell 3: Rowid 21980418 out of order
On tree page 285 cell 2: Rowid 21980418 out of order
On tree page 285 cell 1: Rowid 21980418 out of order
On tree page 285 cell 0: Rowid 21980418 out of order
On tree page 2 cell 280: Rowid 21980418 out of order
On tree page 284 cell 27: Rowid 21980418 out of order
On tree page 284 cell 26: Rowid 21980419 out of order
On tree page 284 cell 25: Rowid 21980419 out of order
On tree page 284 cell 24: Rowid 21980419 out of order
On tree page 284 cell 23: Rowid 21980419 out of order
On tree page 284 cell 22: Rowid 21980419 out of order
On tree page 284 cell 21: Rowid 21980419 out of order
On tree page 284 cell 20: Rowid 21980419 out of order
On tree page 284 cell 19: Rowid 21980419 out of order
On tree page 284 cell 18: Rowid 21980419 out of order
On tree page 284 cell 17: Rowid 21980419 out of order
On tree page 284 cell 16: Rowid 21980419 out of order

--
Ludovic Gasc Lemaire (GMLudo)


Le jeu. 7 févr. 2019 à 17:42, Simon Slavin <slav...@bigfraud.org> a écrit :

> On 7 Feb 2019, at 3:51pm, Ludovic Gasc Lemaire <gml...@gmail.com> 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
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users