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

backtick in FK names breaks SHOW CREATE TABLE

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • Q3/2026 Server Maintenance

    Description

      e.g.

      --source include/have_innodb.inc
      		 
      CREATE TABLE p (a INT PRIMARY KEY) ENGINE=InnoDB;
      		 
      CREATE TABLE t1 (a INT, CONSTRAINT `foo `` bar` FOREIGN KEY (a) REFERENCES p(a)) ENGINE=InnoDB;
      		 
      SHOW CREATE TABLE t1;
      		 
      DROP TABLE t1, p;

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39776 SHOW CREATE TABLE corrupts `-quoted table options

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40159 single quote in DATA DIRECTORY breaks SHOW CREATE TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          links to

          Web Link CVE-2026-86047

          Activity

            People

              serg Sergei Golubchik
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d 1.9h
                  1d 1.9h
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 4.5h Time Not Required
                  4.5h

                  Git Integration

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