This is no different that any other xDBMS that permits access to "row" numbers.
If you fail to tell the database engine that your "rowid" is a persistent meaningful value (and not just the current "row number" of the row in some storage somewhere) then you ought not be surprised if its value changes seemingly at random from one moment to the next. I believe this is documented for SQLite and for pretty much every other xDBMS and ISAM file access method I've ever seen. <div>-------- Original message --------</div><div>From: Roman Fleysher <roman.fleys...@einstein.yu.edu> </div><div>Date:2017-10-06 16:23 (GMT-07:00) </div><div>To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> </div><div>Subject: Re: [sqlite] PRAGMA optimize; == no busy handler? </div><div> </div> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
