Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2696

LP:1014750 - InnoDB weird Forgein Key Name handling

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      The followring DML is always processed right by Percona-XtraDB

      ALTER TABLE `t1` ADD CONSTRAINT FOREIGN KEY (`col1`) REFERENCES `t2` (`col1`),
        ADD CONSTRAINT FOREIGN KEY (`col2`) REFERENCES `t3` (`col1`),
        ADD CONSTRAINT FOREIGN KEY (`col3`) REFERENCES `t4` (`col1`);

      The same behaviour could be reproduced using a DDL.

      But this engine becomes very strange when i like to give the f-keys custom-names like fk_col1 and so on.
      Sometimes it helps to remove the underscore sometimes it helps to rename the f-key and so on.

      So after about 2 hours i messed up finding any pattern so by now no f-key has a custom-name.

      I think some kind of stristr is running an the aliases

      Attachments

        1. LPexportBug1014750_my.cnf
          5 kB
          Rasmus Johansson
        2. LPexportBug1014750.xml
          32 kB
          Rasmus Johansson

        Activity

          People

            Unassigned Unassigned
            konstantinstephan Konstantin Stephan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.