pt-table-checksum 2.2.3
Server version: 5.5.31-30.3-log Percona Server (GPL), Release rel30.3, Revision 520
The server is configured with
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
07-15T23:00:06 Error executing EXPLAIN SELECT COUNT(*), '0' FROM `mysql`.`time_zone_transition` FORCE INDEX(`PRIMARY`) WHERE ((`time_zone_id` < ?) OR (`time_zone_id` = ? AND `transition_time` < ?)) ORDER BY `time_zone_id`, `transition_time` /*explain past lower chunk*/: DBD::mysql::st execute failed: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [for Statement "EXPLAIN SELECT COUNT(*), '0' FROM `mysql`.`time_zone_transition` FORCE INDEX(`PRIMARY`) WHERE ((`time_zone_id` < ?) OR (`time_zone_id` = ? AND `transition_time` < ?)) ORDER BY `time_zone_id`, `transition_time` /*explain past lower chunk*/" with ParamValues: 0='1', 1='1', 2='-1830383032'] at /usr/bin/pt-table-checksum line 10903.
07-15T23:00:06 Skipping chunk 4 of mysql.time_zone_transition because MySQL chose no index instead of the PRIMARYindex.
07-15T23:00:06 Error executing EXPLAIN SELECT COUNT(*), '0' FROM `mysql`.`time_zone_transition` FORCE INDEX(`PRIMARY`) WHERE ((`time_zone_id` > ?) OR (`time_zone_id` = ? AND `transition_time` > ?)) ORDER BY `time_zone_id`, `transition_time` /*explain past upper chunk*/: DBD::mysql::st execute failed: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [for Statement "EXPLAIN SELECT COUNT(*), '0' FROM `mysql`.`time_zone_transition` FORCE INDEX(`PRIMARY`) WHERE ((`time_zone_id` > ?) OR (`time_zone_id` = ? AND `transition_time` > ?)) ORDER BY `time_zone_id`, `transition_time` /*explain past upper chunk*/" with ParamValues: 0='1734', 1='1734', 2='2140045225'] at /usr/bin/pt-table-checksum line 10903.
Odd, the tool should set the sql mode it needs.