Debian Codegraph @

mysql-test/suite/galera/t/enforce_storage_engine2.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_aria.inc
4
5 --echo #
6 --echo # MDEV-9312: storage engine not enforced during galera cluster
7 --echo # replication
8 --echo #
9 --connection node_1
10 CREATE TABLE t1(i INT) ENGINE=INNODB;
11 #
12 # This is not anymore supported because enforce_storage_engine
13 # is local setting and final used storage engine
14 # on other members of cluster depend on their configuration.
15 # Currently, there is no way to query remote node
16 # configuration.
17 #
18 --error ER_OPTION_PREVENTS_STATEMENT
19 CREATE TABLE t2(i INT) ENGINE=MYISAM;
20
21 --connection node_2
22 SHOW TABLES;
23 SHOW CREATE TABLE t1;
24
25 # Cleanup
26 DROP TABLE t1;
27
28 --echo # End of tests