On 11 Aug 2011, at 6:35pm, Abhinav Upadhyay wrote: > The documentation page of the VACUUM command says that "The VACUUM > command may change the ROWIDs of entries in any tables that do not > have an explicit INTEGER PRIMARY KEY." So what are the possible cases > in which the ROWIDs might change ?
Not documented. So even if someone told you what they were in this version of SQLite, there might be other reasons in the next version. Theoretically it might renumber rows to close up gaps in the AUTOINCREMENT. As it says, to stop it all you need to do is declare one of the columns as INTEGER PRIMARY KEY. Once you do that it assumes that you might be referring to those values elsewhere and won't change them. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users