1SET @odl_sync_frm = @@global.sync_frm;
2SET @@global.sync_frm = OFF;
3connect  locker,localhost,root,,;
4connect  writer,localhost,root,,;
5connection default;
6DROP TABLE IF EXISTS t1;
7CREATE TABLE t1( a INT, b INT );
8CREATE TABLE t2( a INT, b INT );
9INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3), (4, 4);
10INSERT INTO t2 VALUES (1, 1), (2, 2), (3, 3), (4, 4);
11# 1. test regular tables
12# 1.1. test altering of columns that multiupdate doesn't use
13# 1.1.1. normal mode
14# 1.1.2. PS mode
15# 1.2. test altering of columns that multiupdate uses
16# 1.2.1. normal mode
17connection default;
18# 1.2.2. PS mode
19connection default;
20ALTER TABLE t1 ADD COLUMN a INT;
21# 2. test UNIONs
22# 2.1. test altering of columns that multiupdate doesn't use
23# 2.1.1. normal mode
24# 2.1.2. PS mode
25# 2.2. test altering of columns that multiupdate uses
26# 2.2.1. normal mode
27connection default;
28# 2.2.2. PS mode
29connection default;
30DROP TABLE t1,t2;
31disconnect locker;
32disconnect writer;
33SET @@global.sync_frm = @odl_sync_frm;
34