Debian Codegraph @

mysql-test/suite/galera/r/enforce_storage_engine.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-8831 : enforce_storage_engine doesn't block table creation on
5 # other nodes (galera cluster)
6 #
7 connection node_1;
8 SET @@enforce_storage_engine=INNODB;
9 CREATE TABLE t1(i INT) ENGINE=INNODB;
10 CREATE TABLE t2(i INT) ENGINE=MYISAM;
11 ERROR HY000: The MariaDB server is running with the NO_ENGINE_SUBSTITUTION option so it cannot execute this statement
12 INSERT INTO t1 VALUES(1);
13 connection node_2;
14 SHOW TABLES;
15 Tables_in_test
16 t1
17 SELECT COUNT(*)=1 FROM t1;
18 COUNT(*)=1
19 1
20 CREATE TABLE t2(i INT) ENGINE=MYISAM;
21 connection node_1;
22 SHOW TABLES;
23 Tables_in_test
24 t1
25 t2
26 DROP TABLE t1, t2;
27 # End of tests