On Mon, 13 Feb 2017 22:22:24 +0000 jose isaias cabrera <jic...@barrioinvi.net> wrote:
> sqlite> select id from LSOpenProjects where id > 13460 and id < > sqlite> 115520; > 13461 > 13462 > 13463 > 13464 > 13758 > 115516 > 115517 > 115518 > 115519 > sqlite> > > As you can see, the id indexing is broken and there is a huge > discrepancy in the sequential id. That doesn't not show a broken index or any discrepancy. I guess you defined id as autoincrement and believe that to guarantee sequentially generated values. There are many valid reasons observed values in such a column will not be sequential; DELETE is only one. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
