MySQL patches by Codership

  1. Bug #1240098
  2. Comment #21

Comment 21 for bug 1240098

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: CTAS fails with explicit TEMPORARY tables | binlogging enabled

Few more things:

a) Tested with PS, works fine there.

b) Binlog for that:

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'.