##################################################################
# Author: Giuseppe                                               #
# Date: 2006-12-20                                               #
# Purpose: To test that event effects are replicated             #
# in both row based and statement based format                   #
##################################################################

set global event_scheduler=1;

--source include/not_embedded.inc
--source include/master-slave.inc

let $engine_type= MyISAM;

set binlog_format=row;

# Embedded server doesn't support binlogging
--source include/rpl_events.inc

set binlog_format=statement;

# Embedded server doesn't support binlogging
--source include/rpl_events.inc

#
# Bug #28953  	Using events in a replication let the slave crash.
#

connection master;

DELIMITER |;
CREATE EVENT event1 ON SCHEDULE EVERY 1 YEAR
DO BEGIN
	select * from t1;
END;|
DELIMITER ;|

ALTER EVENT event1 RENAME TO event2;

sync_slave_with_master;

connection master;

DROP EVENT event2;

sync_slave_with_master;