pt-fingerprint does not parse binary data correctly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
[root@kappigatla kappigatla]# pt-fingerprint --version
pt-fingerprint 2.2.17
[root@kappigatla kappigatla]# pt-fingerprint --query="INSERT IGNORE test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) VALUES (_binary'
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?
Ideally the output should be
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
We are getting the correct output with other binary data
Example:
[root@kappigatla kappigatla]# pt-fingerprint --query="INSERT IGNORE test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) VALUES (_binary'1G?9??\Z? F?<81><9B>???', 1469433660359, 'localhost', 'frontpage', 'test', 'ActionEvent', 131, 1469433000000, 1469433600000, 1469433666056, 0)"
insert ignore test (guid, time, server, service, tier, topic, count, begin_timestamp, end_timestamp, update_time, size_in_bytes) values (_binary?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
This also affects the pt-query-digest report.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1374