BEGIN
/*!*/;
# at 586
#131111 19:38:58 server id 1 end_log_pos 723 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1384178938/*!*/;
DROP TEMPORARY TABLE IF EXISTS `test`.`test_bug` /* generated by server */
/*!*/;
# at 723
#131111 19:39:00 server id 1 end_log_pos 750 Xid = 9
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
The difference in this case being a 'COMMIT' instead of
'ROLLBACK'.
Few more things:
a) Tested with PS, works fine there.
b) Binlog for that:
BEGIN 1384178938/ *!*/; TYPE=@OLD_ COMPLETION_ TYPE*/; PSEUDO_ SLAVE_MODE= 0*/;
/*!*/;
# at 586
#131111 19:38:58 server id 1 end_log_pos 723 Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=
DROP TEMPORARY TABLE IF EXISTS `test`.`test_bug` /* generated by server */
/*!*/;
# at 723
#131111 19:39:00 server id 1 end_log_pos 750 Xid = 9
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_
/*!50530 SET @@SESSION.
The difference in this case being a 'COMMIT' instead of
'ROLLBACK'.