Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1283

LP #1100496: mixed CHAR and VARCHAR columns in foreign key definition makes parallel applying fail

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Seppo Jaakola last update 15-01-2014 18:02:12

      If foreign key column and corresponding referenced table column are of types CHAR and VARCHAR (or vice versa), then controlling of parallel applying may not work.
      Problem is that CHAR columns will be fixed length with space padding in the end and the whole column will be appended as certification key value. For VARCHAR columns only 'effective' characters are append as key value.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: