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 
<> </div><div>Date:2017-10-06  16:23  (GMT-07:00) 
</div><div>To: SQLite mailing list <> 
</div><div>Subject: Re: [sqlite] PRAGMA optimize; == no busy handler? 
sqlite-users mailing list

Reply via email to