1
CREATE DATABASE IF NOT EXISTS events_test;
3
SET @event_scheduler=@@global.event_scheduler;
4
SET GLOBAL event_scheduler=OFF;
5
Try again to make sure it's allowed
6
SET GLOBAL event_scheduler=OFF;
7
SHOW VARIABLES LIKE 'event_scheduler';
10
SET GLOBAL event_scheduler=1;
11
SHOW VARIABLES LIKE 'event_scheduler';
14
SET GLOBAL event_scheduler=0;
15
SHOW VARIABLES LIKE 'event_scheduler';
18
SET GLOBAL event_scheduler=ON;
19
Try again to make sure it's allowed
20
SET GLOBAL event_scheduler=ON;
21
SHOW VARIABLES LIKE 'event_scheduler';
24
SET GLOBAL event_scheduler=DISABLED;
25
ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'DISABLED'
26
SHOW VARIABLES LIKE 'event_scheduler';
29
SET GLOBAL event_scheduler=-1;
30
ERROR 42000: Variable 'event_scheduler' can't be set to the value of '-1'
31
SHOW VARIABLES LIKE 'event_scheduler';
34
SET GLOBAL event_scheduler=2;
35
ERROR 42000: Variable 'event_scheduler' can't be set to the value of '2'
36
SHOW VARIABLES LIKE 'event_scheduler';
39
SET GLOBAL event_scheduler=5;
40
ERROR 42000: Variable 'event_scheduler' can't be set to the value of '5'
41
SHOW VARIABLES LIKE 'event_scheduler';
44
CREATE TABLE table_1(a int);
45
CREATE TABLE table_2(a int);
46
CREATE TABLE table_3(a int);
47
CREATE TABLE table_4(a int);
48
SET GLOBAL event_scheduler=ON;
49
CREATE EVENT event_1 ON SCHEDULE EVERY 2 SECOND
51
INSERT INTO table_1 VALUES (1);
52
CREATE EVENT event_2 ON SCHEDULE EVERY 1 SECOND
53
ENDS NOW() + INTERVAL 6 SECOND
54
ON COMPLETION PRESERVE
56
INSERT INTO table_2 VALUES (1);
57
CREATE EVENT event_3 ON SCHEDULE EVERY 2 SECOND ENDS NOW() + INTERVAL 1 SECOND
58
ON COMPLETION NOT PRESERVE
60
INSERT INTO table_3 VALUES (1);
61
CREATE EVENT event_4 ON SCHEDULE EVERY 1 SECOND ENDS NOW() + INTERVAL 1 SECOND
62
ON COMPLETION PRESERVE
64
INSERT INTO table_4 VALUES (1);
65
SELECT IF(TIME_TO_SEC(TIMEDIFF(ENDS,STARTS))=6, 'OK', 'ERROR')
66
FROM INFORMATION_SCHEMA.EVENTS
67
WHERE EVENT_SCHEMA=DATABASE() AND EVENT_NAME='event_2';
68
IF(TIME_TO_SEC(TIMEDIFF(ENDS,STARTS))=6, 'OK', 'ERROR')
70
"Already dropped because ended. Therefore an error."
72
ERROR HY000: Unknown event 'event_3'
75
SELECT EVENT_NAME, STATUS FROM INFORMATION_SCHEMA.EVENTS ORDER BY EVENT_NAME;
85
DROP DATABASE events_test;
86
SET GLOBAL event_scheduler=@event_scheduler;