Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11412 Ensure that table is truly dropped when using DROP TABLE
  3. MDEV-22826

Presence of Spider prevents tables from being force-deleted from other engines

    XMLWordPrintable

    Details

      Description

      If Spider engine is loaded into the server (even if it's not used), tables from other engines fail to be force-deleted – DELETE works without errors, but orphan files, e.g. .MYD/.MYI or .ibd, remain on the disk.

      --let $datadir= `select @@datadir`
       
      install soname 'ha_spider';
       
      create table t1 (a int);
       
      --remove_file $datadir/test/t1.frm
       
      drop table t1;
      --echo # Files in <datadir>/test:
      --list_files $datadir/test
      

      bb-10.5-monty 645f37e49c

      drop table t1;
      # Files in datadir/test:
      db.opt
      t1.MYD
      t1.MYI
      

        Attachments

          Activity

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration