Bug #30601 Event does not execute as scheduled

Description:
A scheduled event does not execute, and the debug output shows next execution time of never. Have attempted restarting the server after event creation.

How to repeat:
USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY);
DROP EVENT IF EXISTS e;
CREATE EVENT e ON SCHEDULE EVERY 5 SECOND DO INSERT INTO test.t1 VALUES (NULL);

-- Wait 5 seconds

SELECT * FROM t1; -- Empty set. Should be populated.

Run mysqladmin debug, and view error log.

Events status:
LLA = Last Locked At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked

Event scheduler status:
State      : INITIALIZED
Thread id  : 0
LLA        : n/a:0
LUA        : n/a:0
WOC        : NO
Workers    : 0
Executed   : 0
Data locked: NO

Event queue status:
Element count   : 1
Data locked     : NO
Attempting lock : NO
LLA             : <unknown>:240
LUA             : <unknown>:252
WOC             : NO
Next activation : never

Suggested fix:
Fix event scheduler - the event shown should insert a new row into test.t1 every 5 seconds.

Thank you for the report.

Please provide output of show variables like 'event_scheduler';

Aha, it was off by default. Turned it on, and it runs as expected. Sorry, I should have checked that first.

So, this problem was not a result of bug in MySQL's code.