1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
CALL mtr.add_suppression("default_storage_engine is set to a disabled storage engine .*");
CALL mtr.add_suppression("default_tmp_storage_engine is set to a disabled storage engine .*");
CALL mtr.add_suppression("Plugin mysqlx reported: 'All I/O interfaces are disabled");
CREATE TABLE t1(c1 int) ENGINE=HEAP;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=HEAP;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
CREATE TABLE t1 (c1 int) ENGINE=MYISAM;
INSERT INTO t1 VALUES(1);
CREATE TABLESPACE tb1 ADD DATAFILE 't1.ibd' ENGINE=INNODB;
CREATE TABLE tp1 (c1 int) PARTITION BY KEY (c1) PARTITIONS 1;
SHOW VARIABLES LIKE 'disabled_storage_engines';
Variable_name Value
disabled_storage_engines innodb,myisam,heap,example
SELECT * FROM t1;
c1
1
ALTER TABLE t1 ENGINE=MyISAM, ADD COLUMN c2 INT;
ALTER TABLE t1 ADD COLUMN c3 INT;
CREATE TABLE t2 LIKE t1;
ERROR HY000: Storage engine MyISAM is disabled (Table creation is disallowed).
CREATE TEMPORARY TABLE t2 LIKE t1;
ERROR HY000: Storage engine MyISAM is disabled (Table creation is disallowed).
CREATE TABLE t2 AS SELECT * FROM t1;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
CREATE TEMPORARY TABLE t2 AS SELECT * FROM t1;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
ALTER TABLE t1 ENGINE=InnoDB;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
ALTER TABLE t1 ENGINE=HEAP;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
CREATE TABLE t2(c1 int) ENGINE=INNODB SELECT c1 FROM t1;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
CREATE TABLE t2(c1 int) ENGINE=HEAP SELECT c1 FROM t1;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
TRUNCATE TABLE t1;
DROP TABLE t1;
CREATE TABLESPACE t1 ADD DATAFILE 't1.ibd' ENGINE=INNODB;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
CREATE TABLESPACE t1 ADD DATAFILE 't1.ibd' ENGINE=HEAP;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
ALTER TABLESPACE tb1 ADD DATAFILE 'ts.ibd' ENGINE=INNODB;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
ALTER TABLESPACE tb1 ADD DATAFILE 'ts.ibd' ENGINE=HEAP;
ERROR HY000: Engine 'HEAP' does not match stored engine 'InnoDB' for tablespace 'tb1'
ALTER TABLESPACE tb1 ADD DATAFILE 'ts.ibd';
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
DROP TABLESPACE tb1;
CREATE TEMPORARY TABLE t1 (c1 int) ENGINE=INNODB;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
CREATE TEMPORARY TABLE t1 (c1 int) ENGINE=HEAP;
ERROR HY000: Storage engine MEMORY is disabled (Table creation is disallowed).
CREATE PROCEDURE p1()
BEGIN
CREATE TABLE t1 (c1 int) ENGINE=MYISAM;
END |
CALL p1();
ERROR HY000: Storage engine MyISAM is disabled (Table creation is disallowed).
DROP PROCEDURE p1;
CREATE TABLE t1 (c1 int) PARTITION BY KEY (c1) PARTITIONS 1;
ERROR HY000: Storage engine InnoDB is disabled (Table creation is disallowed).
INSERT INTO tp1 VALUES(1);
DROP TABLE tp1;
INSTALL PLUGIN example SONAME 'ha_example.so';
CREATE TABLE t1(a int) ENGINE=EXAMPLE;
ERROR HY000: Storage engine EXAMPLE is disabled (Table creation is disallowed).
UNINSTALL PLUGIN example;
INSTALL PLUGIN example SONAME 'ha_example.so';
CREATE TABLE t1(a int) ENGINE=EXAMPLE;
ERROR HY000: Storage engine EXAMPLE is disabled (Table creation is disallowed).
UNINSTALL PLUGIN example;
SET default_storage_engine=MyISAM;
SET default_tmp_storage_engine=MyISAM;
SET default_storage_engine=default;
SET default_tmp_storage_engine=default;
CREATE TABLE t1(a int) ENGINE=MYISAM;
DROP TABLE t1;
# restart
|
