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

build_table_filename() doesn't support temporary tables

    XMLWordPrintable

Details

    • 10.0.25, 10.0.26

    Description

      build_table_filename() doesn't support temporary tables. Indeed, it always builds the path as datadir/db_name/table_name, while temporary tables are in the tmpdir. This shows up in various DDL statements that use temporary tables:

      create temporary table t1 (a int);
      rename table t1 to t2;

      This fails. Or

      create temporary table t1(a int not null primary key, b int, key(b)) engine=innodb;
      --error 1005
      alter table t1 add foreign key(b) references t1(a);
      drop table t1;
      --source include/restart_mysqld.inc

      This test case succeeds but leaves an orphant temporary frm in the tmpdir (and it causes a warning on restart).

      Note: when this is fixed, please uncomment the corresponding test in innodb-fk-warnings.test

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.