--source include/galera_cluster.inc --source include/have_innodb.inc # enforce_storage_engine should prevent the creation of tables with # non-enforced storage engines on the master node and the command # should also not replicate to other nodes. --echo # --echo # MDEV-8831 : enforce_storage_engine doesn't block table creation on --echo # other nodes (galera cluster) --echo # --connection node_1 SET @@enforce_storage_engine=INNODB; CREATE TABLE t1(i INT) ENGINE=INNODB; --error ER_UNKNOWN_STORAGE_ENGINE CREATE TABLE t2(i INT) ENGINE=MYISAM; INSERT INTO t1 VALUES(1); --connection node_2 SHOW TABLES; SELECT COUNT(*)=1 FROM t1; CREATE TABLE t2(i INT) ENGINE=MYISAM; --connection node_1 SHOW TABLES; # Cleanup DROP TABLE t1, t2; --echo # End of tests