--source include/galera_cluster.inc --source include/have_aria.inc # # Test ALTER ENGINE from MyISAM to InnoDB under REPLICATE_MYISAM # SET GLOBAL wsrep_mode = REPLICATE_MYISAM; CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM; INSERT INTO t1 VALUES (1); ALTER TABLE t1 ENGINE=InnoDB; --connection node_2 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; SELECT COUNT(*) = 1 FROM t1; DROP TABLE t1; # # Test ALTER ENGINE from Aria to InnoDB under REPLICATE_ARIA # --connection node_1 SET GLOBAL wsrep_mode = REPLICATE_ARIA; CREATE TABLE t1 (f1 INTEGER) ENGINE=ARIA; INSERT INTO t1 VALUES (1); ALTER TABLE t1 ENGINE=InnoDB; --connection node_2 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; SELECT COUNT(*) = 1 FROM t1; DROP TABLE t1; --connection node_1 --disable_query_log SET GLOBAL wsrep_mode = DEFAULT; --enable_query_log