/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#110818 15:41:04 server id 1  end_log_pos 107 	Start: binlog v 4, server v 5.5.15-log created 110818 15:41:04 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
cBZNTg8BAAAAZwAAAGsAAAABAAQANS41LjE1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAABwFk1OEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 107
#110818 15:41:12 server id 1  end_log_pos 198 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674872/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE DATABASE `test123`
/*!*/;
# at 198
#110818 15:41:12 server id 1  end_log_pos 310 	Query	thread_id=1	exec_time=0	error_code=0
use test123/*!*/;
SET TIMESTAMP=1313674872/*!*/;
CREATE TABLE `table1` ( `field1` VARCHAR(10) )
/*!*/;
# at 310
#110818 15:41:12 server id 1  end_log_pos 422 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674872/*!*/;
CREATE TABLE `table2` ( `field2` VARCHAR(10) )
/*!*/;
# at 422
#110818 15:41:12 server id 1  end_log_pos 821 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674872/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `break_verbose_binlog_with_me`( `new_value` VARCHAR(10) ) RETURNS varchar(10) CHARSET latin1
BEGIN

	UPDATE `table1`
	SET `field1` = CONCAT( `field1`, `new_value` )
	WHERE `field1` = `new_value`;
	
	RETURN (SELECT `field1` FROM `table1` LIMIT 1);
	
END
/*!*/;
# at 821
#110818 15:41:13 server id 1  end_log_pos 892 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674873/*!*/;
BEGIN
/*!*/;
# at 892
#110818 15:41:13 server id 1  end_log_pos 1007 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674873/*!*/;
INSERT INTO `table1` ( `field1` ) VALUES( 'abc' )
/*!*/;
# at 1007
#110818 15:41:13 server id 1  end_log_pos 1034 	Xid = 11
COMMIT/*!*/;
# at 1034
#110818 15:41:13 server id 1  end_log_pos 1105 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1313674873/*!*/;
BEGIN
/*!*/;
# at 1105
# at 1155
# at 1205
# at 1248
#110818 15:41:13 server id 1  end_log_pos 1155 	Table_map: `test123`.`table2` mapped to number 35
#110818 15:41:13 server id 1  end_log_pos 1205 	Table_map: `test123`.`table1` mapped to number 34
#110818 15:41:13 server id 1  end_log_pos 1248 	Update_rows: table id 34
#110818 15:41:13 server id 1  end_log_pos 1285 	Write_rows: table id 35 flags: STMT_END_F

BINLOG '
eRZNThMBAAAAMgAAAIMEAAAAACMAAAAAAAEAB3Rlc3QxMjMABnRhYmxlMgABDwIKAAE=
eRZNThMBAAAAMgAAALUEAAAAACIAAAAAAAEAB3Rlc3QxMjMABnRhYmxlMQABDwIKAAE=
eRZNThgBAAAAKwAAAOAEAAAAACIAAAAAAAAAAf///gNhYmP+BmFiY2FiYw==
### UPDATE test123.table1
### WHERE
###   @1='abc'
### SET
###   @1='abcabc'
eRZNThcBAAAAJQAAAAUFAAAAACMAAAAAAAEAAf/+BmFiY2FiYw==
'/*!*/;
### INSERT INTO test123.table2
### SET
###   @1='abcabc'
# at 1285
#110818 15:41:13 server id 1  end_log_pos 1312 	Xid = 12
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;