pt-table-sync --ignore-columns case sensitivity
Bug #1311584 reported by
Kenny Gryp
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
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-
--ignore-
~line 10528:
# Determine which columns to compare.
my $ignore_columns = $o->get(
my @compare_columns = grep {
} @{$o->get(
The table columns are converted to lower case, but the columns provided with --ignore-columns are not.
Related branches
lp:~gryp/percona-toolkit/bug1311584
Ready for review
for merging
into
lp:percona-toolkit/2.2
- Daniel Nichter: Pending requested
-
Diff: 60 lines (+21/-2)3 files modifiedbin/pt-table-sync (+2/-1)
t/pt-table-sync/columns.t (+6/-1)
t/pt-table-sync/samples/before.sql (+13/-0)
To post a comment you must log in.
Verified with pt-table-sync 2.2.9,
nilnandan@ nilnandan- Dell-XPS: ~$ pt-table-sync --version nilnandan- Dell-XPS: ~$
pt-table-sync 2.2.9
nilnandan@
~line 10510:
# Determine which columns to compare. 'ignore- columns' );
!$ignore_ columns- >{lc $_}; 'columns' ) || $tbl_struct- >{cols} };
my $ignore_columns = $o->get(
my @compare_columns = grep {
} @{$o->get(