Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1);
6
7 --connection node_2
8
9 # Wait until above DDL's are replicated
10 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
11 --source include/wait_condition.inc
12
13 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
14
15 FLUSH TABLES t1 WITH READ LOCK;
16
17 --connection node_1
18 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
19 INSERT INTO t1 VALUES (2,3);
20
21 --sleep 2
22
23 --connection node_2
24 UNLOCK TABLES;
25
26 --echo ### t1 should have column f2
27 SHOW CREATE TABLE t1;
28 SELECT * from t1;
29
30 --connection node_1
31 DROP TABLE t1;