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

``pt-online-schema-change`` allowed the name of a constraint to exceed 64 characters when ``--alter-foreign-keys-method=rebuild_constraints`` was used.

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Fixed
    • 3.1.0
    • 3.2.0
    • None
    • Yes
    • 0

    Description

      The maxium possible length of a constraint name is 64. When --alter-foreign-keys-method=rebuild_constraints used, pt-online-schema-change just adds `_`-character following the below logic:

               if ($fk =~ /^__/) {
                 ($new_fk = $fk) =~ s/^__//;
               } else {
                 $new_fk = '_'.$fk;  
               }
       

      Attachments

        Activity

          People

            Unassigned Unassigned
            iwo.panowicz Iwo Panowicz
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist