Debian Codegraph @

mysql-test/suite/galera/r/mysql-wsrep#90.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
4 connection node_1;
5 SET GLOBAL wsrep_OSU_method = "RSU";
6 SET DEBUG_SYNC = 'alter_table_before_open_tables WAIT_FOR continue';
7 ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
8 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
9 connection node_1a;
10 SET SESSION wsrep_sync_wait = 0;
11 SET GLOBAL wsrep_OSU_method = "TOI";
12 SET DEBUG_SYNC= 'now SIGNAL continue';
13 connection node_1;
14 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
15 COUNT(*) = 2
16 1
17 connection node_2;
18 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
19 COUNT(*) = 2
20 1
21 connection node_1;
22 DROP TABLE t1;
23 SET DEBUG_SYNC = 'RESET';
24 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
25 connection node_1;
26 SET GLOBAL wsrep_OSU_method = "TOI";
27 SET DEBUG_SYNC = 'alter_table_before_open_tables WAIT_FOR continue';
28 ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
29 connection node_1a;
30 SET SESSION wsrep_sync_wait = 0;
31 SET GLOBAL wsrep_OSU_method = "RSU";
32 SET DEBUG_SYNC= 'now SIGNAL continue';
33 connection node_1;
34 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
35 COUNT(*) = 2
36 1
37 INSERT INTO t1 VALUES (1,2);
38 connection node_2;
39 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
40 COUNT(*) = 2
41 1
42 INSERT INTO t1 VALUES (3,4);
43 connection node_1;
44 DROP TABLE t1;
45 SET GLOBAL WSREP_OSU_METHOD = TOI;
46 SET DEBUG_SYNC = 'RESET';