create database abc;
use abc;
create event ev1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR do select 1;
create event ev2 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR do select 1;
delimiter |;
CREATE EVENT `m_partitions` ON SCHEDULE EVERY 1 DAY STARTS '2011-01-01 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
    DECLARE new_partition CHAR(32) DEFAULT
      CONCAT ('p_', DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 5 DAY), '%Y%m%d'));
    DECLARE max_day INTEGER DEFAULT TO_DAYS(NOW()) +5;

    SET @s =
      CONCAT('ALTER TABLE messages ADD PARTITION (PARTITION ', new_partition,
      ' VALUES LESS THAN (', max_day, '))');
    PREPARE stmt FROM @s;
    EXECUTE stmt;
  END
|
delimiter ;|
show events;

--exec $MYSQL_DUMP --all-databases --single-transaction --events -d > $MYSQL_TEST_DIR/var/tmp/bug68650.sql

drop event ev1;
drop event ev2;
drop event m_partitions;
show events;

--exec $MYSQL < $MYSQL_TEST_DIR/var/tmp/bug68650.sql

show events;