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,t2,t3;
7CREATE TABLE t1 (
8a int(11) unsigned default NULL,
9b varchar(255) default NULL,
10UNIQUE KEY a (a),
11KEY b (b)
12);
13INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
14CREATE TABLE t2 SELECT * FROM t1;
15CREATE TABLE t3 SELECT * FROM t1;
16# test altering of columns that multiupdate doesn't use
17# normal mode
18# PS mode
19# test altering of columns that multiupdate uses
20# normal mode
21connection default;
22# PS mode
23connection default;
24DROP TABLE t1, t2, t3;
25disconnect locker;
26disconnect writer;
27SET @@global.sync_frm = @odl_sync_frm;
28