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

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

SET @old_event_scheduler = @@global.event_scheduler;
set global event_scheduler=1;

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;

CREATE TABLE t28953 (a INT);

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

ALTER EVENT event1 RENAME TO event2;

sync_slave_with_master;

connection master;

DROP EVENT event2;

sync_slave_with_master;

# Doing cleanup of the table referred to in the event to guarantee
# that there is no bad timing cauing it to try to access the table.

connection master;
SET @@global.event_scheduler= @old_event_scheduler;
DROP TABLE t28953;
sync_slave_with_master;