mysql> CREATE TABLE order_new (
-> `id` int(20) DEFAULT NULL,
-> `code` varchar(20) DEFAULT NULL,
-> `date` datetime DEFAULT NULL,
-> ```Size_Change``` double(6,4) NOT NULL DEFAULT '0.0000',
-> `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
-> KEY `indx_updated` (`updated`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
nilnandan@desktop:~$ pt-duplicate-key-checker
Can't determine column type for ```size_change``` double(6,4) not null default '0.0000' at /usr/bin/pt-duplicate-key-checker line 360.
nilnandan@desktop:~$
Workaround can be,
nilnandan@desktop:~$ pt-duplicate-key-checker --ignore-tables=order_new
# ########################################################################
# Summary of indexes
# ########################################################################
# Total Indexes 55
nilnandan@desktop:~$
I can suggested some stupid straightforward patch:
[openxs@chief percona-
=== modified file 'bin/pt-
--- bin/pt-
+++ bin/pt-
@@ -356,7 +356,12 @@
my (%type_for, %is_nullable, %is_numeric, %is_autoinc);
foreach my $col ( @cols ) {
my $def = $def_for{$col};
- my ( $type ) = $def =~ m/`[^`]
+ my ( $type );
+ ($type) = $def =~ m/`[^`]
+ unless ($type) {
+ ($type) = $def =~ m/```[^
+ }
+# my ( $type ) = $def =~ m/`[^`]
die "Can't determine column type for $def" unless $type;
if ( $type =~ m/(?:(?