LP #912470: pt-table-checksum inaccurate reports when timezones are different

**Reported in Launchpad by Paul Graydon last update 06-01-2012 23:50:30

pt-table-checksum was reporting diffs between data on the master and data on the slave, despite numerous attempts to create and re-create the slave.

In the end it turned out to be that because the Master server was set to EST and the slave HST (Master should have been HST like the rest of the servers, something had messed up the tzdata), the returned data from timestamp fields was different. timestamp data is stored as UTC but converted to localtime during select.

You might want to either throw up an error if you can detect that the master & slave are on different timezones, or maybe force the timezone to UTC for your connection through the time_zone variable.

pt-table-checksum version 2.0.1, mysql 5.1.58 on master, 5.1.59 on slave.