Karl Forner wrote: > On Tue, Dec 19, 2017 at 3:12 PM, Clemens Ladisch <clem...@ladisch.de> wrote: >> Where does the hex number in "excluded_mice_temp2b5036f270" come from? >> Is it random? > > Yes, thanks, I think I got it. In order to alter tables, we first move them > to a new table with a temp name, copy them, then drop them. > The temp name is random, so is different between the two computers. > > After doing a "vacuum" on both files, they are now identical ! > > So it is our fault, we should do a vacuum after the drop table.
No. If you care about repeatability, don't use random numbers. Instead use a deterministic algorithm to generate the temp table name. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
