pt-table-sync --ignore-columns case sensitivity

[Kenny Gryp]

using pt-table-sync with an upper case character in --ignore-columns will make the column not to be ignored.

CREATE TABLE test (
 id primary key,
 IGNOREME char(32)
);

You can only ignore this column with --ignore-columns=ignoreme,
--ignore-columns=IGNOREME does not work.

~line 10528:
      # Determine which columns to compare.
      my $ignore_columns = $o->get('ignore-columns');
      my @compare_columns = grep {
         !$ignore_columns->{lc $_};
      } @{$o->get('columns') || $tbl_struct->{cols}};

The table columns are converted to lower case, but the columns provided with --ignore-columns are not.

[Nilnandan Joshi (nilnandan-joshi)]

Verified with pt-table-sync 2.2.9,

nilnandan@nilnandan-Dell-XPS:~$ pt-table-sync --version
pt-table-sync 2.2.9
nilnandan@nilnandan-Dell-XPS:~$

~line 10510:

# Determine which columns to compare.
      my $ignore_columns = $o->get('ignore-columns');
      my @compare_columns = grep {
         !$ignore_columns->{lc $_};
      } @{$o->get('columns') || $tbl_struct->{cols}};

[Shahriyar Rzayev (rzayev-sehriyar)]

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