Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.2.3
-
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
- relates to
-
MDEV-10568 Implement support for ALTER TABLE ... {DISCARD|IMPORT} PARTITION
- Open