Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1603

pt-table-sync is not considering unsorted enum fields in indexes for calculating chunk boundaries

    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • None
    • 3.0.12
    • None
    • None

    Description

      As concluded in comments of PT-1591 what has been added for pt-online-schema-change and pt-checksum-table (CONCAT when unsorted enum field is part of the index to have proper ordering for chunk boundaries) is not available in pt-table-sync because it uses some other methods.

      Relevant comments are:

      https://jira.percona.com/browse/PT-1591?focusedCommentId=228116&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-228116

      and

      https://jira.percona.com/browse/PT-1591?focusedCommentId=228123&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-228123

       

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. PT-1591 [QA] Better usage of ENUM fields in keys

          • Medium - Minor loss of function, or other problem where easy workaround is present.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. PT-1572 Better usage of ENUM fields in keys

          • Medium - Minor loss of function, or other problem where easy workaround is present.
          • Done

          Activity

            People

              carlos.salguero Carlos Salguero (Inactive)
              tomislav.plavcic@percona.com Tomislav Plavcic
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist