Good day,

show-grant outputs incorrect Sql format when access to the table is on selected fields only.

consider the ff. table

CREATE TABLE IF NOT EXISTS `table3` ( `SOrNum` mediumint(9) unsigned NOT NULL auto_increment, `SPNum` mediumint(9) unsigned NOT NULL, `DateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP, `DateRelease` timestamp NOT NULL default '0000-00-00 00:00:00', `ActualReleasedDate` timestamp NULL default NULL, `PckPrice` decimal(10,2) NOT NULL default '0.00', `Status` varchar(20) NOT NULL, `PaymentStat` varchar(20) NOT NULL default 'Unpaid', `CusCode` int(9) unsigned NOT NULL, `SANumber` mediumint(9) unsigned NOT NULL default '0', `SpecialInstruction` varchar(500) default NULL, PRIMARY KEY (`SOrNum`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



if the user have only access to the following fields: DateCreated, PckPrice, PaymentStat, SANumber
the ouput of

pt-show-grants --user=root --ask-pass --only=user


is the ff. which is invalid
GRANT DateCreated, PaymentStat, PckPrice), SELECT (SANumber ON `inventory`.`table3` TO 'user'@'%';

Regards,