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