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

discard tablespace doesn't work for partitioned tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 11.2.3
    • N/A
    • Partitioning
    • rhel 8

    Description

      MariaDB [dummy2]> CREATE TABLE `test1` (
      -> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      -> `column_var` char(254) DEFAULT NULL,
      -> `column_string` varchar(254) DEFAULT NULL,
      -> `column_tinytext` tinytext NOT NULL,
      -> `column_text` text NOT NULL,
      -> `column_mediumtext` mediumtext NOT NULL,
      -> `column_longtext` longtext NOT NULL,
      -> PRIMARY KEY (`id`)
      -> ) ENGINE=InnoDB
      -> PARTITION BY RANGE (`id`)
      -> (PARTITION `p0` VALUES LESS THAN (10) ENGINE = InnoDB,
      -> PARTITION `p1` VALUES LESS THAN (30) ENGINE = InnoDB,
      -> PARTITION `p2` VALUES LESS THAN (45) ENGINE = InnoDB,
      -> PARTITION `p3` VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
      Query OK, 0 rows affected (0.018 sec)

      MariaDB [dummy2]> alter table `test1` discard tablespace;
      ERROR 1031 (HY000): Storage engine InnoDB of the table `dummy2`.`test1` doesn't have this option

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sudheer43 Sudheer
              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.