CREATE DATABASE db1;

CREATE TABLE db1.t1(details CHAR(30));

CREATE EVENT db1.e1 ON SCHEDULE AT CURRENT_TIMESTAMP
 ON COMPLETION PRESERVE DISABLE
 DO INSERT INTO db1.t1 VALUES('event e1 fired');

DELIMITER ||;

CREATE PROCEDURE db1.fire(a char(20))
BEGIN
 ALTER EVENT db1.e1 ENABLE;
END;||

DELIMITER ;||

SET GLOBAL EVENT_SCHEDULER=ON;

CALL db1.fire('fire1');
#let $wait_condition = SELECT LAST_EXECUTED FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'e1' AND LAST_EXECUTED IS NOT NULL;
#--source include/wait_condition.inc

#sleep 2;

SELECT * FROM db1.t1;

#
# Cleanup.
#

DROP DATABASE db1;
SET GLOBAL event_scheduler=off;
--exit