pt-show-grants --separate dumps UPDATE grants incorrectly

[Carl Welch]

If the mysql user has a grant to UPDATE specific columns, pt-show-grants (with the --separate option) dumps them incorrectly.

This is with percona-toolkit v2.0.3 and MySQL server v5.0.77 (the mysql-server-5.0.77-4.el5_6.6.i386 RPM from CentOS 5).

CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `percona` (
    `id` int unsigned NOT NULL auto_increment,
    `col1` varchar(10) NOT NULL default '',
    `col2` varchar(10) NOT NULL default '',
    `col3` varchar(10) NOT NULL default '',
    PRIMARY KEY (`id`)
);
GRANT USAGE ON *.* TO 'percona'@'localhost';
SET PASSWORD FOR 'percona'@'localhost'=PASSWORD('password');
GRANT SELECT, UPDATE (col1, col2) ON `test`.`percona` TO 'percona'@'localhost';

(excerpted) output of "pt-show-grants --separate":

-- Grants dumped by pt-show-grants
-- Dumped from server Localhost via UNIX socket, MySQL 5.0.77-log at 2012-02-14 13:18:16
-- Grants for 'percona'@'localhost'
GRANT USAGE ON *.* TO 'percona'@'localhost' IDENTIFIED BY PASSWORD '5d2e19393cc5ef67';
GRANT SELECT ON `test`.`percona` TO 'percona'@'localhost';
GRANT UPDATE (col2 ON `test`.`percona` TO 'percona'@'localhost';
GRANT col1) ON `test`.`percona` TO 'percona'@'localhost';

[Brian Fraser (fraserbn)]

Is this a duplicate of https://bugs.launchpad.net/percona-toolkit/+bug/866075 ?

[Carl Welch (carl-welch-2-718)]

Yes, looks like this is a duplicate of https://bugs.launchpad.net/percona-toolkit/+bug/866075

I did a search before filing this bug report, but I overlooked that one.

Sorry about that. I'll mark it as a duplicate in a moment.