On Tue, Dec 19, 2017 at 3:12 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Karl Forner wrote: > > Here's a screenshot of some of the diffs using vbindiff > > > > https://ibb.co/kNm0X6 > > SQLite uses hash tables for schema objects, so different names might > result in such differences. > > 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. Thanks a lot for your help ! > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users