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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

--source include/galera_cluster.inc
--source include/have_innodb.inc

#
# At this time, issing a FLUSH TABLES WITH READ LOCK on one node does not prevent DDLs from other nodes
# from proceeding. The locked node will apply the DDL after it has been unlocked
#

CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;

--connection node_2
FLUSH TABLES WITH READ LOCK;

--connection node_1
ALTER TABLE t1 ADD COLUMN f2 INTEGER;

--connection node_2
UNLOCK TABLES;
SHOW CREATE TABLE t1;

DROP TABLE t1;