| 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; |