Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
4 CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM;
5 INSERT INTO t1 VALUES (1);
6 ALTER TABLE t1 ENGINE=InnoDB;
7 connection node_2;
8 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
9 ENGINE = 'InnoDB'
10 1
11 SELECT COUNT(*) = 1 FROM t1;
12 COUNT(*) = 1
13 1
14 DROP TABLE t1;
15 connection node_1;
16 SET GLOBAL wsrep_mode = REPLICATE_ARIA;
17 CREATE TABLE t1 (f1 INTEGER) ENGINE=ARIA;
18 INSERT INTO t1 VALUES (1);
19 ALTER TABLE t1 ENGINE=InnoDB;
20 connection node_2;
21 SELECT ENGINE = 'InnoDB' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
22 ENGINE = 'InnoDB'
23 1
24 SELECT COUNT(*) = 1 FROM t1;
25 COUNT(*) = 1
26 1
27 DROP TABLE t1;
28 connection node_1;
29 SET GLOBAL wsrep_mode = DEFAULT;