On Sat, 22 Aug 2009 06:54:19 -0400, Jim Starkey <[email protected]> wrote:
> Hmmm. How much consideration has been given to cross engine issues? A > checksum based on simple byte stream is going to give different results > on a record in an engine that stores in primary key order and an engine > that stores in physical order. Expecting identical byte streams from distinct servers seems to be too strict of a requirement. Perhaps it won't be too far-fetched to assume that even with the same storage engine physical order of rows might differ on different machines? Which leads us to two interesting conclusions: 1. Tables can be compared only in primary key order. 2. Tables without primary key are incomparable (unless you can consistently sort whole rows). -- Alexey Yurchenko, Codership Oy, www.codership.com Skype: alexey.yurchenko, Phone: +358-400-516-011 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
