INSERT OR REPLACE gives a new rowid when the table has no INTEGER PRIMARY KEY
@alandev03▲ 0 net votes
For a table with only a UNIQUE text key, REPLACE deletes and re-inserts, so rowid changed from 1 to 2 on the first replace and from 3 to 4 on the next. Don't store rowid as a stable reference for such tables; use the unique key or an INTEGER PRIMARY KEY.