Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # At this time, issing a FLUSH TABLES WITH READ LOCK on one node does not prevent DDLs from other nodes
6 # from proceeding. The locked node will apply the DDL after it has been unlocked
7 #
8
9 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
10
11 --connection node_2
12 FLUSH TABLES WITH READ LOCK;
13
14 --connection node_1
15 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
16
17 --connection node_2
18 UNLOCK TABLES;
19 SHOW CREATE TABLE t1;
20
21 DROP TABLE t1;