1include/master-slave.inc 2[connection master] 3DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8; 4CREATE TABLE t1 (`bit_key` bit, `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 5CREATE TABLE t2 (`bit_key` bit(4), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 6CREATE TABLE t3 (`bit_key` bit(7), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 7CREATE TABLE t4 (`bit_key` bit(8), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 8CREATE TABLE t5 (`bit_key` bit(9), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 9CREATE TABLE t6 (`bit_key` bit(14), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 10CREATE TABLE t7 (`bit_key` bit(15), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 11CREATE TABLE t8 (`bit_key` bit(16), `bit` bit, key (`bit_key` )) ENGINE=MyISAM; 12INSERT INTO `t1` ( `bit` ) VALUES ( 0 ); 13DELETE FROM `t1` WHERE `bit` < 2 LIMIT 4; 14INSERT INTO `t2` ( `bit` ) VALUES ( 0 ); 15DELETE FROM `t2` WHERE `bit` < 2 LIMIT 4; 16INSERT INTO `t3` ( `bit` ) VALUES ( 0 ); 17DELETE FROM `t3` WHERE `bit` < 2 LIMIT 4; 18INSERT INTO `t4` ( `bit` ) VALUES ( 0 ); 19DELETE FROM `t4` WHERE `bit` < 2 LIMIT 4; 20INSERT INTO `t5` ( `bit` ) VALUES ( 0 ); 21DELETE FROM `t5` WHERE `bit` < 2 LIMIT 4; 22INSERT INTO `t6` ( `bit` ) VALUES ( 0 ); 23DELETE FROM `t6` WHERE `bit` < 2 LIMIT 4; 24INSERT INTO `t7` ( `bit` ) VALUES ( 0 ); 25DELETE FROM `t7` WHERE `bit` < 2 LIMIT 4; 26INSERT INTO `t8` ( `bit` ) VALUES ( 0 ); 27DELETE FROM `t8` WHERE `bit` < 2 LIMIT 4; 28connection slave; 29connection master; 30DROP TABLE t1, t2, t3, t4, t5, t6, t7, t8; 31connection slave; 32include/rpl_end.inc 33