Comment 5 for bug 1034717
Revision history for this message
| Ryan Brothers (ryan-brothers) wrote Re: pt-table-sync errors with varchar primary key | #5 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
a60fb26
(Get the code!)
Brian - thanks for checking into the issues. I actually was able to create a reproduce script for the 2nd bug and I posted it above in comment #3 in reproduce2.sql. Does that reproduce the problem for you?
For the division by zero bug, rather than returning an error to pick a different algorithm, could pt-table-sync itself just recognize this scenario and pick a different algorithm on its own? In my call to pt-table-sync, I'm not specifying the --algorithm, so I don't have a preference about which algorithm is used, so I prefer in this case just for pt-table-sync to pick the correct algorithm so the data gets synced. Thanks.