Debian Codegraph @

mysql-test/suite/events/events_scheduling.result

raw
1 call mtr.add_suppression("Event Scheduler: .* Table 'events_test.t1' doesn't exist");
2 CREATE DATABASE IF NOT EXISTS events_test;
3 USE events_test;
4 SET @event_scheduler=@@global.event_scheduler;
5 SET GLOBAL event_scheduler=OFF;
6 Try again to make sure it's allowed
7 SET GLOBAL event_scheduler=OFF;
8 SHOW VARIABLES LIKE 'event_scheduler';
9 Variable_name Value
10 event_scheduler OFF
11 SET GLOBAL event_scheduler=1;
12 SHOW VARIABLES LIKE 'event_scheduler';
13 Variable_name Value
14 event_scheduler ON
15 SET GLOBAL event_scheduler=0;
16 SHOW VARIABLES LIKE 'event_scheduler';
17 Variable_name Value
18 event_scheduler OFF
19 SET GLOBAL event_scheduler=ON;
20 Try again to make sure it's allowed
21 SET GLOBAL event_scheduler=ON;
22 SHOW VARIABLES LIKE 'event_scheduler';
23 Variable_name Value
24 event_scheduler ON
25 SET GLOBAL event_scheduler=DISABLED;
26 ERROR 42000: Variable 'event_scheduler' can't be set to the value of 'DISABLED'
27 SHOW VARIABLES LIKE 'event_scheduler';
28 Variable_name Value
29 event_scheduler ON
30 SET GLOBAL event_scheduler=-1;
31 ERROR 42000: Variable 'event_scheduler' can't be set to the value of '-1'
32 SHOW VARIABLES LIKE 'event_scheduler';
33 Variable_name Value
34 event_scheduler ON
35 SET GLOBAL event_scheduler=2;
36 ERROR 42000: Variable 'event_scheduler' can't be set to the value of '2'
37 SHOW VARIABLES LIKE 'event_scheduler';
38 Variable_name Value
39 event_scheduler ON
40 SET GLOBAL event_scheduler=5;
41 ERROR 42000: Variable 'event_scheduler' can't be set to the value of '5'
42 SHOW VARIABLES LIKE 'event_scheduler';
43 Variable_name Value
44 event_scheduler ON
45 CREATE TABLE table_1(a int);
46 CREATE TABLE table_2(a int);
47 CREATE TABLE table_3(a int);
48 CREATE TABLE table_4(a int);
49 SET GLOBAL event_scheduler=ON;
50 CREATE EVENT event_1 ON SCHEDULE EVERY 2 SECOND
51 DO
52 INSERT INTO table_1 VALUES (1);
53 CREATE EVENT event_2 ON SCHEDULE EVERY 1 SECOND
54 ENDS NOW() + INTERVAL 6 SECOND
55 ON COMPLETION PRESERVE
56 DO
57 INSERT INTO table_2 VALUES (1);
58 CREATE EVENT event_3 ON SCHEDULE EVERY 2 SECOND ENDS NOW() + INTERVAL 1 SECOND
59 ON COMPLETION NOT PRESERVE
60 DO
61 INSERT INTO table_3 VALUES (1);
62 CREATE EVENT event_4 ON SCHEDULE EVERY 1 SECOND ENDS NOW() + INTERVAL 1 SECOND
63 ON COMPLETION PRESERVE
64 DO
65 INSERT INTO table_4 VALUES (1);
66 SELECT IF(TIME_TO_SEC(TIMEDIFF(ENDS,STARTS))=6, 'OK', 'ERROR')
67 FROM INFORMATION_SCHEMA.EVENTS
68 WHERE EVENT_SCHEMA=DATABASE() AND EVENT_NAME='event_2';
69 IF(TIME_TO_SEC(TIMEDIFF(ENDS,STARTS))=6, 'OK', 'ERROR')
70 OK
71 "Already dropped because ended. Therefore an error."
72 DROP EVENT event_3;
73 ERROR HY000: Unknown event 'event_3'
74 DROP EVENT event_1;
75 "Should be preserved"
76 SELECT EVENT_NAME, STATUS FROM INFORMATION_SCHEMA.EVENTS ORDER BY EVENT_NAME;
77 EVENT_NAME STATUS
78 event_2 DISABLED
79 event_4 DISABLED
80 DROP EVENT event_2;
81 DROP EVENT event_4;
82 DROP TABLE table_1;
83 DROP TABLE table_2;
84 DROP TABLE table_3;
85 DROP TABLE table_4;
86
87 Bug #50087 Interval arithmetic for Event_queue_element is not portable.
88
89 CREATE TABLE t1(a int);
90 CREATE EVENT e1 ON SCHEDULE EVERY 1 MONTH
91 STARTS NOW() - INTERVAL 1 MONTH
92 ENDS NOW() + INTERVAL 2 MONTH
93 ON COMPLETION PRESERVE
94 DO
95 INSERT INTO t1 VALUES (1);
96 CREATE EVENT e2 ON SCHEDULE EVERY 1 MONTH
97 STARTS NOW()
98 ENDS NOW() + INTERVAL 11 MONTH
99 ON COMPLETION PRESERVE
100 DO
101 INSERT INTO t1 VALUES (1);
102 DROP TABLE t1;
103 DROP EVENT e1;
104 DROP EVENT e2;
105 DROP DATABASE events_test;
106 SET GLOBAL event_scheduler=@event_scheduler;