56 lines
1.8 KiB
Plaintext
56 lines
1.8 KiB
Plaintext
drop table if exists t1;
|
|
CREATE TABLE t1 (a INT, b INT, KEY ka(a), KEY kab(a,b)) ENGINE=XENGINE;
|
|
INSERT INTO t1 (a, b) VALUES (1, 5);
|
|
INSERT INTO t1 (a, b) VALUES (2, 6);
|
|
INSERT INTO t1 (a, b) VALUES (3, 7);
|
|
# crash_during_online_index_creation
|
|
flush logs;
|
|
SET SESSION debug="+d,crash_during_online_index_creation";
|
|
ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE;
|
|
ERROR HY000: Lost connection to MySQL server during query
|
|
# restart
|
|
SET SESSION debug="-d,crash_during_online_index_creation";
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
KEY `ka` (`a`),
|
|
KEY `kab` (`a`,`b`)
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
CHECK TABLE t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (i INT DEFAULT 0, j INT, k INT, PRIMARY KEY (i), KEY(j)) ENGINE = XENGINE;
|
|
# crash_during_index_creation_partition
|
|
flush logs;
|
|
SET SESSION debug="+d,myx_simulate_index_create_rollback";
|
|
ALTER TABLE t1 ADD INDEX kij(i,j), ALGORITHM=INPLACE;
|
|
ERROR HY000: Intentional failure in inplace alter occurred.
|
|
SET SESSION debug="-d,myx_simulate_index_create_rollback";
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`i` int(11) NOT NULL DEFAULT '0',
|
|
`j` int(11) DEFAULT NULL,
|
|
`k` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`i`),
|
|
KEY `j` (`j`)
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
ALTER TABLE t1 ADD INDEX kij(i,j), ALGORITHM=INPLACE;
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`i` int(11) NOT NULL DEFAULT '0',
|
|
`j` int(11) DEFAULT NULL,
|
|
`k` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`i`),
|
|
KEY `j` (`j`),
|
|
KEY `kij` (`i`,`j`)
|
|
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
100
|
|
DROP TABLE t1;
|