pt-table-sync generates empty replace commands

Description

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.

Environment

None

Attachments

1

Smart Checklist

Activity

Show:

Lalit Choudhary May 3, 2019 at 10:49 AM

Hi ,

Thank you for the report.

validated as described with PT version 3.0.13

Test:

 

 

 

Working for following table structure

table def:

Details

Assignee

Reporter

Priority

Affects versions

Smart Checklist

Created May 1, 2019 at 7:41 PM
Updated February 29, 2024 at 9:05 PM