Debian Codegraph @

mysql-test/suite/galera/t/lp1376747-3.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 FLUSH TABLE WITH READ LOCK;
9 --echo ### This shouldn't block.
10 FLUSH TABLES t1 FOR EXPORT;
11
12 --connection node_1
13 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
14
15 --connection node_2
16 UNLOCK TABLES;
17
18 --echo ### t1 should have column f2
19 SHOW CREATE TABLE t1;
20
21 --connection node_1
22 INSERT INTO t1 VALUES (2,3);
23
24 --connection node_2
25 SELECT * from t1;
26
27 --connection node_1
28 DROP TABLE t1;