pt-kill matches does not support modifiers
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
This is pt-kill 2.2.14, likely apply to other tools as well - a feature request to support regex modifiers, at least case insensivite matching.
Unfortunately, after looking at the code, the match-info command does not support passing modifiers which seems to be a limitation of the tool.
3572 sub _find_match_Info {
3573 my ( $self, $query, $property ) = @_;
3574 return defined $property && defined $query->{Info}
3575 && $query->{Info} =~ m/$property/;
3576 }
A potential workaround is to specify the permutations of the "SELECT" word in small and uppercase variants in the regex like below. Can you please test and let us know.
--match-
tags: | added: i58590 |
Indeed, the way $property is used modifiers (http:// perldoc. perl.org/ perlre. html#Modifiers) will not work as expected.