--disable_abort_on_error
--disable_abort_on_error
--disable_abort_on_error
CREATE TABLE `table0_myisam` (
 `enum_utf8_not_null_key` enum ('a',
'y',
'z') CHARACTER SET utf8 not null,
 `blob_not_null_key` blob not null,
 `char_255_latin1_key` char(255) CHARACTER SET latin1,
 `decimal_unsigned_key` decimal unsigned,
 `set_latin1_key` set ('a',
'z') CHARACTER SET latin1,
 `enum_utf8_key` enum ('a',
'z') CHARACTER SET utf8,
 key (`set_latin1_key` ),
 key (`enum_utf8_key` )) ENGINE=myisam;
CREATE TABLE `table0_myisam_int_autoinc` ( `enum_utf8_not_null_key` enum ('a',
'z') CHARACTER SET utf8 not null,
 `enum_latin1_key` enum ('a',
'z') CHARACTER SET latin1,
 `decimal_unsigned_not_null` decimal unsigned not null,
 `enum_utf8_key` enum ('a',
'z') CHARACTER SET utf8,
 `decimal_key` decimal,
 `enum_latin1_not_null` enum ('a',
'b',
'z') CHARACTER SET latin1 not null,
 `char_255_latin1_key` char(255) CHARACTER SET latin1,
 `set_latin1_not_null_key` set ('a',
'u',
'v',
'z') CHARACTER SET utf8 not null,
 `decimal_not_null_key` decimal not null,
 `char_255_latin1_not_null` char(255) CHARACTER SET latin1 not null,
 pk int auto_increment,
 `blob` blob,
 `char_255_latin1_not_null_key` char(255) CHARACTER SET latin1 not null,
 `set_utf8_not_null_key` set ('a',
'z') CHARACTER SET utf8,
 `decimal_not_null` decimal not null,
 `char_255_utf8_not_null` char(255) CHARACTER SET utf8 not null,
 `int_not_null_key` int not null,
 `float_not_null_key` float not null,
 `float_unsigned_not_null_key` float unsigned not null,
 primary key (pk),
 key (`int_not_null_key` ),
 key (`float_not_null_key` ),
 key (`float_unsigned_not_null_key` )) ENGINE=myisam;
CREATE TABLE `table0_myisam_key_pk_parts_2_int_autoinc` ( `enum_latin1_not_null` enum ('a',
'd',
'z') CHARACTER SET utf8,
 `float_unsigned_not_null_key` float unsigned not null,
 `int_unsigned_not_null` int unsigned not null,
 pk int auto_increment,
 `set_latin1_key` set ('a',
'z') CHARACTER SET utf8 not null,
 `set_utf8_key` set ('a',
'b',
'z') CHARACTER SET utf8,
 `int_key` int,
 `bit_not_null_key` bit not null,
 `char_255_utf8` char(255) CHARACTER SET utf8,
 primary key (pk),
 key (`set_latin1_key` ),
 key (`bit_not_null_key` )) ENGINE=myisam /*!50100 PARTITION BY key (pk) partitions 2 */;
CREATE TABLE `table1_myisam` ( `bit_key` bit,
 `enum_latin1_not_null_key` enum ('a',
'b',
'y',
'z') CHARACTER SET utf8,
 `int_key` int,
 `int_not_null` int not null,
 key (`int_key` )) ENGINE=myisam;
CREATE TABLE `table1_myisam_int_autoinc` ( `enum_utf8_key` enum ('a',
'b',
'z') CHARACTER SET latin1 not null,
 `set_utf8_not_null` set ('a',
'y',
'z') CHARACTER SET latin1 not null,
 `float_unsigned` float unsigned,
 `char_255_utf8_key` char(255) CHARACTER SET utf8,
 `enum_utf8` enum ('a',
'b',
'z') CHARACTER SET utf8,
 `enum_utf8_not_null` enum ('a',
'b',
'z') CHARACTER SET utf8 not null,
 `int_unsigned_not_null_key` int unsigned not null,
 pk int auto_increment,
 `float_unsigned_not_null_key` float unsigned not null,
 `int_key` int,
 `char_255_utf8_not_null_key` char(255) CHARACTER SET utf8 not null,
 	key (`enum_utf8_key` ),
 primary key (pk),
 key (`char_255_utf8_not_null_key` )) ENGINE=myisam;
CREATE TABLE `table1_myisam_key_pk_parts_2_int_autoinc` ( `char_255_utf8_key` char(255) CHARACTER SET utf8,
 `enum_utf8` enum ('a',
'y',
'z') CHARACTER SET latin1,
 `decimal_unsigned_not_null` decimal unsigned not null,
 `decimal_unsigned_key` decimal unsigned,
 pk int auto_increment,
 `blob_key` blob,
 `enum_utf8_key` enum ('a',
'z') CHARACTER SET latin1 not null,
 `float_not_null` float not null,
 `decimal_unsigned_not_null_key` decimal unsigned not null,
 	key (`char_255_utf8_key` ),
 primary key (pk),
 key (`blob_key`  (255)),
 key (`enum_utf8_key` ),
 key (`decimal_unsigned_not_null_key` )) ENGINE=myisam /*!50100 PARTITION BY key (pk) partitions 2 */;
CREATE TABLE `table10_myisam` ( `enum_utf8` enum ('a',
'b',
'z') CHARACTER SET utf8,
 `blob_key` blob,
 `char_255_utf8_key` char(255) CHARACTER SET utf8,
 `int` int,
 `char_255_latin1_not_null` char(255) CHARACTER SET latin1 not null,
 `enum_latin1_key` enum ('a',
'b',
'z') CHARACTER SET latin1,
 `decimal_unsigned_not_null` decimal unsigned not null,
 `set_latin1_not_null` set ('a',
'z') CHARACTER SET latin1 not null,
 `decimal_not_null` decimal not null,
 `enum_utf8_key` enum ('a',
'z') CHARACTER SET latin1 not null,
 `enum_latin1_not_null_key` enum ('a',
'z') CHARACTER SET utf8,
 `float_not_null_key` float not null,
 `int_unsigned_not_null_key` int unsigned not null,
 `float_unsigned_key` float unsigned,
 	key (`blob_key`  (255)),
 key (`float_unsigned_key` )) ENGINE=myisam;
CREATE TABLE `table10_myisam_int_autoinc` ( `set_latin1_not_null_key` set ('a',
'y',
'z') CHARACTER SET utf8 not null,
 `float` float,
 `enum_latin1_not_null_key` enum ('a',
'b',
'z') CHARACTER SET latin1 not null,
 pk int auto_increment,
 `int_not_null` int not null,
 `set_latin1_key` set ('a',
'b',
'z') CHARACTER SET latin1,
 `blob_not_null` blob not null,
 `enum_latin1` enum ('a',
'y',
'z') CHARACTER SET latin1 not null,
 `blob_not_null_key` blob not null,
 `bit_key` bit,
 `int_unsigned_key` int unsigned,
 `enum_latin1_key` enum ('a',
'b',
'z') CHARACTER SET utf8 not null,
 `char_255_utf8_key` char(255) CHARACTER SET utf8,
 `float_not_null_key` float not null,
 key (`enum_latin1_not_null_key` ),
 primary key (pk),
 key (`set_latin1_key` ),
 key (`char_255_utf8_key` ),
 key (`float_not_null_key` )) ENGINE=myisam;
CREATE TABLE `table10_myisam_key_pk_parts_2_int_autoinc` ( `char_255_latin1_key` char(255) CHARACTER SET latin1,
 `enum_utf8_not_null` enum ('a',
'b',
'c',
'z') CHARACTER SET utf8,
 `set_utf8` set ('a',
'b',
'c',
'z') CHARACTER SET utf8,
 `enum_utf8_not_null_key` enum ('a',
'y',
'z') CHARACTER SET utf8 not null,
 `enum_utf8_key` enum ('a',
'b',
'c',
'y',
'z') CHARACTER SET utf8,
 `int_not_null_key` int not null,
 `int_unsigned_key` int unsigned,
 pk int auto_increment,
 `char_255_latin1` char(255) CHARACTER SET latin1,
 `enum_latin1_key` enum ('a',
'z') CHARACTER SET latin1,
 `int_unsigned` int unsigned,
 `decimal_unsigned_not_null_key` decimal unsigned not null,
 `decimal_key` decimal,
 `set_latin1` set ('a',
'b',
'c',
'y',
'z') CHARACTER SET latin1,
 `float_not_null_key` float not null,
 `enum_latin1_not_null_key` enum ('a',
'b',
'c',
'y',
'z') CHARACTER SET latin1 not null,
 `bit_key` bit,
 `decimal` decimal,
 `set_latin1_not_null_key` set ('a',
'y',
'z') CHARACTER SET latin1 not null,
 `int_key` int,
 `set_utf8_not_null` set ('a',
'b',
'z') CHARACTER SET utf8 not null,
 `set_utf8_not_null_key` set ('a',
'b',
'c',
'y',
'z') CHARACTER SET utf8 not null,
 `decimal_unsigned` decimal unsigned,
 primary key (pk),
 key (`enum_latin1_key` ),
 key (`set_utf8_not_null_key` )) ENGINE=myisam /*!50100 PARTITION BY key (pk) partitions 2 */;
CREATE TABLE `table100_myisam` ( `bit_not_null_key` bit not null,
 `set_utf8_not_null` set ('a',
'z') CHARACTER SET latin1,
 `enum_utf8_not_null_key` enum ('a',
'b',
'c',
'y',
'z') CHARACTER SET utf8 not null,
 `int_key` int,
 `set_utf8_key` set ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8,
 `decimal_unsigned_not_null` decimal unsigned not null,
 `int_unsigned_key` int unsigned,
 `enum_utf8` enum ('a',
'b',
'c',
'y',
'z') CHARACTER SET utf8 not null,
 `char_255_latin1` char(255) CHARACTER SET latin1,
 `char_255_utf8` char(255) CHARACTER SET utf8,
 `set_latin1_not_null_key` set ('a',
'z') CHARACTER SET latin1 not null,
 `char_255_latin1_key` char(255) CHARACTER SET latin1,
 `decimal_not_null` decimal not null,
 `set_latin1_key` set ('a',
'b',
'c',
'z') CHARACTER SET utf8,
 `blob_key` blob,
 `float_not_null_key` float not null,
 `decimal_unsigned` decimal unsigned,
 `set_latin1_not_null` set ('a',
'b',
'x',
'y',
'z') CHARACTER SET latin1 not null,
 `bit_key` bit,
 `int_unsigned_not_null_key` int unsigned not null,
 `char_255_latin1_not_null_key` char(255) CHARACTER SET latin1 not null,
 `float_unsigned_not_null_key` float unsigned not null,
 `char_255_utf8_not_null_key` char(255) CHARACTER SET utf8 not null,
 	key (`bit_not_null_key` ),
 key (`char_255_latin1_not_null_key` ),
 key (`float_unsigned_not_null_key` ),
 key (`char_255_utf8_not_null_key` )) ENGINE=myisam;
CREATE TABLE `table100_myisam_int_autoinc` ( `int_not_null` int not null,
 `bit_key` bit,
 `decimal_not_null_key` decimal not null,
 `set_utf8_key` set ('a',
'b',
'c',
'y',
'z') CHARACTER SET latin1 not null,
 `decimal` decimal,
 `bit_not_null_key` bit not null,
 `float_unsigned_not_null` float unsigned not null,
 `set_latin1` set ('a',
'b',
'x',
'y',
'z') CHARACTER SET latin1,
 `float_key` float,
 `char_255_utf8` char(255) CHARACTER SET utf8,
 `set_latin1_key` set ('a',
'z') CHARACTER SET latin1,
 pk int auto_increment,
 `char_255_utf8_not_null` char(255) CHARACTER SET utf8 not null,
 `bit` bit,
 `int_not_null_key` int not null,
 `enum_latin1_key` enum ('a',
'z') CHARACTER SET latin1,
 `blob_not_null` blob not null,
 `blob_not_null_key` blob not null,
 `set_utf8` set ('a',
'b',
'c',
'y',
'z') CHARACTER SET utf8,
 `bit_not_null` bit not null,
 `float_unsigned` float unsigned,
 `char_255_latin1_not_null` char(255) CHARACTER SET latin1 not null,
 `set_latin1_not_null` set ('a',
'z') CHARACTER SET latin1 not null,
 `set_utf8_not_null` set ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8 not null,
 `int_unsigned_not_null` int unsigned not null,
 `enum_utf8_not_null_key` enum ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8 not null,
 `enum_latin1_not_null_key` enum ('a',
'b',
'c',
'y',
'z') CHARACTER SET latin1 not null,
 `decimal_not_null` decimal not null,
 `decimal_unsigned_not_null` decimal unsigned not null,
 `int` int,
 `char_255_latin1` char(255) CHARACTER SET latin1,
 `enum_utf8` enum ('a',
'z') CHARACTER SET utf8,
 `char_255_latin1_key` char(255) CHARACTER SET latin1,
 `enum_utf8_key` enum ('a',
'z') CHARACTER SET utf8,
 `float_unsigned_not_null_key` float unsigned not null,
 `blob_key` blob,
 `enum_utf8_not_null` enum ('a',
'z') CHARACTER SET utf8 not null,
 `set_utf8_not_null_key` set ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8 not null,
 key (`set_latin1_key` ),
 primary key (pk),
 key (`int_not_null_key` ),
 key (`float_unsigned_not_null_key` ),
 key (`blob_key`  (255)),
 key (`set_utf8_not_null_key` )) ENGINE=myisam;
CREATE TABLE `table100_myisam_key_pk_parts_2_int_autoinc` ( `float_unsigned_key` float unsigned,
 `enum_latin1` enum ('a',
'b',
'c',
'x',
'y',
'z') CHARACTER SET latin1,
 pk int auto_increment,
 `decimal` decimal,
 `char_255_latin1_not_null` char(255) CHARACTER SET latin1 not null,
 `bit_key` bit,
 `bit_not_null_key` bit not null,
 `float_key` float,
 `enum_utf8_not_null` enum ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8 not null,
 `int` int,
 `decimal_unsigned_key` decimal unsigned,
 `char_255_utf8_key` char(255) CHARACTER SET utf8,
 `set_latin1_not_null_key` set ('a',
'z') CHARACTER SET latin1 not null,
 `blob_key` blob,
 `enum_latin1_not_null_key` enum ('a',
'b',
'x',
'y',
'z') CHARACTER SET utf8,
 `set_latin1_key` set ('a',
'z') CHARACTER SET latin1,
 `enum_latin1_key` enum ('a',
'b',
'x',
'y',
'z') CHARACTER SET latin1,
 `float_not_null_key` float not null,
 `char_255_latin1` char(255) CHARACTER SET latin1,
 `enum_utf8_key` enum ('a',
'b',
'c',
'd',
'h',
'x',
'y',
'z') CHARACTER SET latin1 not null,
 primary key (pk),
 key (`bit_key` ),
 key (`bit_not_null_key` ),
 key (`enum_latin1_key` ),
 key (`float_not_null_key` ),
 key (`enum_utf8_key` )) ENGINE=myisam /*!50100 PARTITION BY key (pk) partitions 2 */;
DELIMITER |;
CREATE TRIGGER s AFTER UPDATE ON `table1_myisam_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table1_myisam_key_pk_parts_2_int_autoinc` ( `pk` ) VALUES ( NULL ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table10_myisam_key_pk_parts_2_int_autoinc` SET `char_255_latin1_not_null_key` = 1 WHERE `enum_utf8_not_null` = 7 ORDER BY `enum_utf8` LIMIT 1 ;
 SET @a = 'some' ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `set_latin1_key` = @a ORDER BY `float_key` LIMIT 8 ;
 INSERT INTO `table1_myisam_int_autoinc` ( `pk` ) VALUES ( NULL ) ;
 INSERT INTO `table10_myisam` ( `blob_not_null_key` ) VALUES ( 'there' ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL c () ;
 END|
CREATE TRIGGER b BEFORE UPDATE ON `table1_myisam_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 DELETE FROM `table0_myisam_int_autoinc` WHERE `enum_latin1_not_null_key` < 'see' LIMIT 1 ;
 DELETE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `int_unsigned_key` < NULL LIMIT 1 ;
 DELETE FROM `table0_myisam_key_pk_parts_2_int_autoinc` WHERE `set_latin1` > NULL LIMIT 1 ;
 UPDATE `table10_myisam` SET `char_255_latin1_not_null_key` = 2 WHERE `float_unsigned_key` = 'he' ORDER BY `set_utf8_not_null_key`  ;
 INSERT INTO `table1_myisam_int_autoinc` ( `char_255_latin1_not_null` ) VALUES ( NULL ) ;
 DELETE FROM `table100_myisam` WHERE `set_utf8_not_null` = 'that' LIMIT 1 ;
 UPDATE `table0_myisam` SET `blob_not_null_key` = 4 WHERE `char_255_utf8_not_null_key` < 0   ;
 UPDATE `table0_myisam_int_autoinc` SET `set_latin1_key` = 'do' WHERE `bit_key` = 7 ORDER BY `float_unsigned_not_null`  ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `decimal_key` = 'did' WHERE `int_not_null` = NULL  LIMIT 7 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL s () ;
 END|
CREATE TRIGGER r BEFORE INSERT ON `table10_myisam_key_pk_parts_2_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table100_myisam_int_autoinc` SET `float_not_null_key` = NULL WHERE `float_unsigned_not_null` > 6  LIMIT 3 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table1_myisam_key_pk_parts_2_int_autoinc` SET `float_unsigned` = RAND() WHERE `set_latin1_not_null` < NULL ORDER BY RAND ()  ;
 UPDATE `table10_myisam_int_autoinc` SET `decimal_not_null` = 0 WHERE `int` < NULL ORDER BY `int_unsigned_not_null` LIMIT 4 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL z () ;
 END|
CREATE TRIGGER o BEFORE INSERT ON `table100_myisam_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table10_myisam_int_autoinc` SET `bit_not_null` = 1 WHERE `int_unsigned_key` = 'her' ORDER BY `int_unsigned`  ;
 DELETE FROM `table0_myisam_key_pk_parts_2_int_autoinc` WHERE `int` > NULL LIMIT 1 ;
 UPDATE `table1_myisam_int_autoinc` SET `enum_utf8_not_null` = 6 WHERE `enum_latin1_key` = NULL ORDER BY `bit_key`  ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 DELETE FROM `table0_myisam` WHERE `bit` > 'with' LIMIT 1 ;
 UPDATE `table1_myisam` SET `set_latin1_key` = 'up' WHERE `int_key` > NULL  LIMIT 3 ;
 DELETE FROM `table0_myisam_int_autoinc` WHERE `char_255_utf8` > NULL LIMIT 1 ;
 DELETE FROM `table0_myisam_key_pk_parts_2_int_autoinc` WHERE `bit` < 1 LIMIT 1 ;
 UPDATE `table10_myisam_key_pk_parts_2_int_autoinc` SET `enum_utf8_key` = NULL WHERE `set_latin1` = 2 ORDER BY `float`  ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL b () ;
 END|
CREATE TRIGGER l BEFORE INSERT ON `table0_myisam_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table100_myisam` ( `char_255_latin1_not_null_key` ) VALUES ( LAST_INSERT_ID() ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `enum_utf8` = NULL WHERE `enum_utf8_not_null_key` < NULL ORDER BY `float_key`  ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table10_myisam_int_autoinc` SET `set_utf8_not_null_key` = NULL WHERE `char_255_latin1_not_null_key` < NULL  LIMIT 7 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL p () ;
 END|
CREATE TRIGGER v BEFORE INSERT ON `table100_myisam_key_pk_parts_2_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table0_myisam_int_autoinc` ( `pk` ) VALUES ( NULL ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 INSERT INTO `table100_myisam` ( `char_255_utf8_key` ) VALUES ( 'not' ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 DELETE FROM `table100_myisam_key_pk_parts_2_int_autoinc` WHERE `enum_latin1` < NULL LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL c () ;
 END|
CREATE TRIGGER f BEFORE INSERT ON `table0_myisam` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `char_255_latin1` = 9 WHERE `blob_key` = 'mean'  LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 SET @a = 'will' ;
 INSERT INTO `table100_myisam` ( `float_not_null` ) VALUES ( @a ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table0_myisam_key_pk_parts_2_int_autoinc` ( `bit_key` ) VALUES ( LAST_INSERT_ID() ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL h () ;
 END|
CREATE TRIGGER p BEFORE INSERT ON `table1_myisam_key_pk_parts_2_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `float_key` = NULL WHERE `decimal_unsigned_not_null` > 'like'  LIMIT 0 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table10_myisam_int_autoinc` ( `pk` ) VALUES ( LAST_INSERT_ID() ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL x () ;
 END|
CREATE TRIGGER w AFTER INSERT ON `table10_myisam` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 DELETE FROM `table100_myisam_int_autoinc` WHERE `bit_not_null` < 'will' LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table1_myisam_int_autoinc` SET `enum_latin1_key` = RAND() WHERE `pk` > NULL ORDER BY RAND () LIMIT 7 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table100_myisam_key_pk_parts_2_int_autoinc` SET `decimal_unsigned` = 1 WHERE `decimal_not_null_key` = 'just'   ;
 DELETE FROM `table10_myisam_int_autoinc` WHERE `bit_not_null_key` > 7 LIMIT 1 ;
 DELETE FROM `table1_myisam` WHERE `decimal_not_null` < NULL LIMIT 1 ;
 DELETE FROM `table0_myisam_int_autoinc` WHERE `float_not_null` > NULL LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL g () ;
 END|
CREATE TRIGGER a BEFORE INSERT ON `table10_myisam` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table100_myisam` ( `pk` ) VALUES ( NULL ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table1_myisam_int_autoinc` SET `pk` = 'can' WHERE `set_utf8` > 8 ORDER BY `enum_utf8_key`  ;
 INSERT INTO `table100_myisam_int_autoinc` ( `char_255_latin1` ) VALUES ( 'well' ) ;
 DELETE FROM `table10_myisam` WHERE `blob_not_null_key` < 'were' LIMIT 1 ;
 UPDATE `table0_myisam_key_pk_parts_2_int_autoinc` SET `decimal_key` = 'can' WHERE `bit_not_null_key` > 'going' ORDER BY `bit` LIMIT 8 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 RELEASE SAVEPOINT A ;
 CALL f () ;
 END|
CREATE TRIGGER n BEFORE UPDATE ON `table1_myisam_key_pk_parts_2_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 DELETE FROM `table1_myisam` WHERE `char_255_latin1_not_null` = NULL LIMIT 1 ;
 DELETE FROM `table100_myisam_int_autoinc` WHERE `set_latin1` = NULL LIMIT 1 ;
 UPDATE `table1_myisam_key_pk_parts_2_int_autoinc` SET `int_not_null_key` = 4 WHERE `enum_latin1` < 0 ORDER BY `char_255_utf8_key`  ;
 DELETE FROM `table100_myisam_key_pk_parts_2_int_autoinc` WHERE `float_unsigned` = 3 LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table0_myisam` ( `float` ) VALUES ( 'got' ) ;
 UPDATE `table0_myisam` SET `decimal_not_null_key` = 'we' WHERE `blob_not_null` < 'just' ORDER BY `set_latin1_not_null_key` LIMIT 8 ;
 DELETE FROM `table0_myisam` WHERE `decimal_unsigned_key` > NULL LIMIT 1 ;
 UPDATE `table1_myisam_key_pk_parts_2_int_autoinc` SET `enum_utf8` = 2 WHERE `bit_key` > NULL ORDER BY `pk`  ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 DELETE FROM `table10_myisam_int_autoinc` WHERE `int` = 4 LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL n () ;
 END|
CREATE TRIGGER t BEFORE INSERT ON `table0_myisam_key_pk_parts_2_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table10_myisam` ( `enum_utf8` ) VALUES ( RAND () ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 DELETE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `enum_latin1_not_null_key` < RAND() LIMIT 6 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table100_myisam` SET `blob_key` = 1 WHERE `enum_utf8_key` > 'for' ORDER BY `char_255_utf8_not_null_key` LIMIT 3 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL d () ;
 END|
DELIMITER ;|
DELIMITER |;
CREATE TRIGGER j BEFORE UPDATE ON `table10_myisam` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 SET @a = 'your' ;
 INSERT INTO `table0_myisam` ( `bit_key` ) VALUES ( @a ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 SET @a = NULL ;
 INSERT INTO `table100_myisam_key_pk_parts_2_int_autoinc` ( `bit_not_null_key` ) VALUES ( @a ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 INSERT INTO `table0_myisam_int_autoinc` ( `bit_not_null_key` ) VALUES ( "I'll" ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL d () ;
 END|
DELIMITER ;
|
DELIMITER |;
CREATE TRIGGER x AFTER INSERT ON `table0_myisam` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 UPDATE `table10_myisam` SET `char_255_latin1_not_null_key` = NULL WHERE `float_unsigned_not_null_key` = 3  LIMIT 8 ;
 UPDATE `table10_myisam_int_autoinc` SET `float_unsigned_not_null` = NULL WHERE `enum_latin1_not_null` > 5   ;
 INSERT INTO `table10_myisam_int_autoinc` ( `set_utf8` ) VALUES ( NULL ) ;
 UPDATE `table100_myisam_int_autoinc` SET `enum_utf8_not_null` = NULL WHERE `char_255_latin1_not_null` > 5   ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 DELETE FROM `table0_myisam` WHERE `float_unsigned_not_null` = "don't" LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 DELETE FROM `table10_myisam_int_autoinc` WHERE `bit_not_null_key` > NULL LIMIT 1 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL n () ;
 END|
CREATE TRIGGER m AFTER UPDATE ON `table10_myisam_int_autoinc` FOR EACH ROW BEGIN SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 INSERT INTO `table0_myisam_key_pk_parts_2_int_autoinc` ( `char_255_utf8_key` ) VALUES ( RAND () ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'ROW' ;
 UPDATE `table0_myisam` SET `set_utf8` = 4 WHERE `int_unsigned` < NULL ORDER BY `decimal` LIMIT 8 ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 SET @binlog_format_saved = @@binlog_format ;
 SET BINLOG_FORMAT = 'STATEMENT' ;
 SET @a = 0 ;
 INSERT INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `blob` ) VALUES ( @a ) ;
 SET BINLOG_FORMAT = @binlog_format_saved ;
 CALL y () ;
 END|
DELIMITER ;|
INSERT INTO `table0_myisam` ( `enum_latin1` ) VALUES ( 7 );
INSERT INTO `table0_myisam_key_pk_parts_2_int_autoinc` ( `pk` ) VALUES ( NULL );