pt-table-checksum error when column name has two spaces

[Mrten]

This is my table:

CREATE TABLE `bedrijven2011_20110329` (
 `BEDRIJF-ID` int(10) DEFAULT NULL,
 `AJB Vermelding-ID` int(10) NOT NULL AUTO_INCREMENT,
 `Afval Jaarboek` varchar(20) DEFAULT NULL,
 `Vet` tinyint(1) NOT NULL,
[trimmed for brevity]
 PRIMARY KEY (`AJB Vermelding-ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1419 DEFAULT CHARSET=latin1

This is the error:

Error checksumming table afval.bedrijven_import: Error executing checksum query: DBD::mysql::st execute failed: Unknown column 'afval jaarboek' in 'field list' [for Statement "REPLACE INTO `maatkit`.`pt_checksum` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(MURMUR_HASH(CONCAT_WS('#', `bedrijf-id`, `ajb vermelding-id`, `afval jaarboek`, `vet`, `logo`, `logo_yes_no`, `ajb bedrijf`, `ajb postadres`, `ajb pc en plaats`, `ajb land`, `ajb telefoon`, `ajb telefax`, `ajb e-mail`, `ajb internet`, `certificaten`, `merken`, `informatie`, `foto`, `gem provincie`, `huishoudens`, `inzameldienst`, `diftar`, `actief`, `status`, `modifier`, `modification`, `creator`, `creation`, CONCAT(ISNULL(`bedrijf-id`), ISNULL(`afval jaarboek`), ISNULL(`logo`), ISNULL(`ajb bedrijf`), ISNULL(`ajb postadres`), ISNULL(`ajb pc en plaats`), ISNULL(`ajb land`), ISNULL(`ajb telefoon`), ISNULL(`ajb telefax`), ISNULL(`ajb e-mail`), ISNULL(`ajb internet`), ISNULL(`certificaten`), ISNULL(`merken`), ISNULL(`informatie`), ISNULL(`foto`), ISNULL(`gem provincie`), ISNULL(`huishoudens`), ISNULL(`inzameldienst`), ISNULL(`diftar`), ISNULL(`actief`), ISNULL(`modifier`), ISNULL(`modification`), ISNULL(`creator`), ISNULL(`creation`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `afval`.`bedrijven_import` /*checksum table*/" with ParamValues: 0='afval', 1='bedrijven_import', 2=1, 3=undef, 4=undef, 5=undef] at /usr/bin/pt-table-checksum line 6865.

There are two spaces in the column definition of 'Afval Jaarboek', but there is only one in the resulting REPLACE INTO query.

[Daniel Nichter (daniel-nichter)]

The problem is caused by this line in TableParser::get_create_table(): $href->{$key} =~ s/\b[ ]{2,}/ /g; That was introduced in r121 when pt-table-checksum 2.0 was merged. MySQLDump.pm was removed and TableParser.pm took over functions like get_create_table(). I probably flattened spaces to make testing consistent, but this shouldn't be done; the original MySQLDump::get_create_table() didn't alter the table def. So I'll fix this.

[Daniel Nichter (daniel-nichter)]

Tested for TableParser.pm and pt-table-checksum and fixed. This will be in the next release, 2.0.4.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-474