pt-duplicate-key-checker not finding some duplicated keys
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Invalid
|
Undecided
|
Unassigned | ||
2.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
2.2 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
With the following table:
CREATE TABLE `ezcontentobjec
`attribute_
`contentclass
`contentobjec
`data_float` double DEFAULT NULL,
`data_int` int(11) DEFAULT NULL,
`data_text` longtext,
`data_
`id` int(11) NOT NULL AUTO_INCREMENT,
`language_code` varchar(20) NOT NULL DEFAULT '',
`language_id` int(11) NOT NULL DEFAULT '0',
`sort_key_int` int(11) NOT NULL DEFAULT '0',
`sort_key_string` varchar(255) NOT NULL DEFAULT '',
`version` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`version`),
KEY `ezcontentobjec
KEY `ezcontentobjec
KEY `ezcontentobjec
KEY `sort_key_int` (`sort_key_int`),
KEY `sort_key_string` (`sort_key_string`)
) ENGINE=InnoDB;
I expect to see a suggestion about dropping: "ezcontentobjec
Changed in percona-toolkit: | |
importance: | Undecided → Medium |
assignee: | nobody → Daniel Nichter (daniel-nichter) |
milestone: | none → 2.2.6 |
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
Yes, it looks like it should suggest that. Which version of the tool?