I am having an issue where pt-table-sync is generating empty replace commands. I believe it is due to the primary key of the table being a VARBINARY. However, using the pt-table-checksum flag --binary-index and the pt-table-sync flag --hex-blob does not seem to resolve the issue.
My belief is that --hex-blob is converting BINARY columns, but not VARBINARY.
I am having an issue where pt-table-sync is generating empty replace commands. I believe it is due to the primary key of the table being a VARBINARY. However, using the pt-table-checksum flag --binary-index and the pt-table-sync flag --hex-blob does not seem to resolve the issue.
My belief is that --hex-blob is converting BINARY columns, but not VARBINARY.
Example of empty replace
Create table of table being checksummed
Create table of checksum table
pt-table-checksum command
pt-table-sync command
Sanitized Debug log is attached.