Debian Codegraph @

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

raw
1 #
2 # Test Rolling Schema Upgrade
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
9
10 --connection node_2
11 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
12 --source include/wait_condition.inc
13
14 SET SESSION wsrep_OSU_method = "RSU";
15 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
16 SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
17
18 --connection node_1
19 # The ALTER above is not visible on node_1
20 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
21
22 INSERT INTO t1 VALUES (1);
23
24 --connection node_2
25 # The INSERT above is now visible on node_2
26 SELECT COUNT(*) = 1 FROM t1;
27
28 INSERT INTO t1 (f1) VALUES (2);
29
30 --connection node_1
31 # The ALTER has not replicated
32 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
33
34 # However the INSERT above has
35 SELECT COUNT(*) = 2 FROM t1;
36
37 DROP TABLE t1;