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

Reply via email to