Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
4 connection node_2;
5 SET SESSION wsrep_OSU_method = "RSU";
6 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
7 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
8 COUNT(*) = 2
9 1
10 connection node_1;
11 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
12 COUNT(*) = 1
13 1
14 INSERT INTO t1 VALUES (1);
15 connection node_2;
16 SELECT COUNT(*) = 1 FROM t1;
17 COUNT(*) = 1
18 1
19 INSERT INTO t1 (f1) VALUES (2);
20 connection node_1;
21 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
22 COUNT(*) = 1
23 1
24 SELECT COUNT(*) = 2 FROM t1;
25 COUNT(*) = 2
26 1
27 DROP TABLE t1;