Debian Codegraph @

mysql-test/suite/galera/t/lp1376747-2.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 FOR EXPORT;
16
17 --connection node_1
18 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
19 INSERT INTO t1 VALUES (2,3);
20
21 --connection node_2
22 UNLOCK TABLES;
23
24 --echo ### t1 should have column f2
25 SHOW CREATE TABLE t1;
26 SELECT * from t1;
27
28 --connection node_1
29 DROP TABLE t1;