Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_aria.inc
4
5 #
6 # Test ALTER ENGINE from MyISAM to InnoDB under REPLICATE_MYISAM
7 #
8
9 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
10
11 CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM;
12 INSERT INTO t1 VALUES (1);
13
14 ALTER TABLE t1 ENGINE=InnoDB;
15
16 --connection node_2
17 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
18 SELECT COUNT(*) = 1 FROM t1;
19 DROP TABLE t1;
20
21 #
22 # Test ALTER ENGINE from Aria to InnoDB under REPLICATE_ARIA
23 #
24
25 --connection node_1
26 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
27
28 CREATE TABLE t1 (f1 INTEGER) ENGINE=ARIA;
29 INSERT INTO t1 VALUES (1);
30
31 ALTER TABLE t1 ENGINE=InnoDB;
32
33 --connection node_2
34 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
35 SELECT COUNT(*) = 1 FROM t1;
36 DROP TABLE t1;
37
38 --connection node_1
39 SET GLOBAL wsrep_mode = DEFAULT;