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

build_table_filename() doesn't support temporary tables

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

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Assignee Alexey Botchkov [ holyfoot ]
          serg Sergei Golubchik made changes -
          Sprint 10.0.25 [ 50 ]
          holyfoot Alexey Botchkov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Sprint 10.0.25 [ 50 ] 10.0.25, 10.0.26 [ 50, 73 ]
          holyfoot Alexey Botchkov made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Sprint 10.0.25, 10.0.26 [ 50, 73 ] 10.0.25, 10.0.26, 10.1.16 [ 50, 73, 76 ]
          holyfoot Alexey Botchkov made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          holyfoot Alexey Botchkov added a comment -

          Fixing patch:
          http://lists.askmonty.org/pipermail/commits/2016-July/009541.html

          holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2016-July/009541.html
          holyfoot Alexey Botchkov made changes -
          Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          holyfoot Alexey Botchkov made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          holyfoot Alexey Botchkov made changes -
          issue.field.resolutiondate 2016-07-18 08:06:27.0 2016-07-18 08:06:27.496
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.0.27 [ 22017 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.0.25, 10.0.26, 1.0.2 [ 50, 73, 76 ] 10.0.25, 10.0.26 [ 50, 73 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 70907 ] MariaDB v4 [ 149438 ]

          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.