MariaDB [regressiondb]> show create table testAndSuite_status\G
|
*************************** 1. row ***************************
|
Table: testAndSuite_status
|
Create Table: CREATE TABLE `testAndSuite_status` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`topo_id` int(10) unsigned NOT NULL,
|
`vmTopo_id` int(10) unsigned NOT NULL DEFAULT 0,
|
`extraKey_id` int(10) NOT NULL DEFAULT 0,
|
`testAndSuite_id` int(10) unsigned NOT NULL,
|
`status` enum('PASSED','FAILED','SKIPPED','UNKNOWN','OUT','GHOST') COLLATE latin1_bin NOT NULL DEFAULT 'GHOST',
|
`rotten` tinyint(1) NOT NULL DEFAULT 0,
|
`duration` varchar(45) COLLATE latin1_bin DEFAULT NULL,
|
`regressRun_id_Pass` int(11) DEFAULT NULL,
|
`regressRun_id_Fail` int(11) DEFAULT NULL,
|
`origin` enum('scanResult','scanGash','admin','gui','expand') COLLATE latin1_bin NOT NULL,
|
`registered` tinyint(1) NOT NULL DEFAULT 0,
|
`changedDate` timestamp NOT NULL DEFAULT current_timestamp(),
|
`remarks` varchar(140) COLLATE latin1_bin DEFAULT NULL,
|
`passCount` int(11) NOT NULL DEFAULT 0,
|
`failCount` int(11) NOT NULL DEFAULT 0,
|
`bossKey` tinyint(1) NOT NULL,
|
`aggregate` int(2) NOT NULL DEFAULT 0 COMMENT '0=normal, 2=agg, 1=pointing to agg',
|
PRIMARY KEY (`id`),
|
KEY `testAndSuite` (`testAndSuite_id`),
|
KEY `topo` (`topo_id`),
|
KEY `regressRun_id_Fail` (`regressRun_id_Fail`),
|
KEY `regressRun_id_Pass` (`regressRun_id_Pass`),
|
KEY `rotten` (`rotten`),
|
KEY `extrakey` (`extraKey_id`),
|
KEY `vmTopo_id` (`vmTopo_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2717022889 DEFAULT CHARSET=latin1 COLLATE=latin1_bin
|
1 row in set (0.000 sec)
|
|
MariaDB [regressiondb]> alter table testAndSuite_status ADD master_tas_id INT(11) UNSIGNED NULL DEFAULT NULL, ALGORITHM=INSTANT;
|
ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
MariaDB [regressiondb]> select VERSION();
|
+--------------------+
|
| VERSION() |
|
+--------------------+
|
| 10.4.6-MariaDB-log |
|
+--------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [regressiondb]> show variables like '%row_format%';
|
+---------------------------+---------+
|
| Variable_name | Value |
|
+---------------------------+---------+
|
| innodb_default_row_format | dynamic |
|
+---------------------------+---------+
|
1 row in set (0.002 sec)
|
Bug
Major
MDEV-11424 Instant ALTER TABLE of failure-free record format changes
Page Loading...
