Debian Codegraph @

mysql-test/suite/galera/r/galera_events.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE EVENT event1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT 1;
5 Warnings:
6 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
7 connection node_2;
8 SELECT DEFINER= 'root@localhost', ORIGINATOR = 1, STATUS = 'SLAVESIDE_DISABLED', EVENT_TYPE = 'ONE TIME', ON_COMPLETION = 'NOT PRESERVE' FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
9 DEFINER= 'root@localhost' ORIGINATOR = 1 STATUS = 'SLAVESIDE_DISABLED' EVENT_TYPE = 'ONE TIME' ON_COMPLETION = 'NOT PRESERVE'
10 1 1 1 1 1
11 connection node_1;
12 ALTER EVENT event1 DISABLE;
13 connection node_2;
14 SELECT DEFINER= 'root@localhost', ORIGINATOR = 1, STATUS = 'SLAVESIDE_DISABLED', EVENT_TYPE = 'ONE TIME', ON_COMPLETION = 'NOT PRESERVE' FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
15 DEFINER= 'root@localhost' ORIGINATOR = 1 STATUS = 'SLAVESIDE_DISABLED' EVENT_TYPE = 'ONE TIME' ON_COMPLETION = 'NOT PRESERVE'
16 1 1 1 1 1
17 connection node_2;
18 SET GLOBAL event_scheduler = ON;
19 CREATE EVENT event2 ON SCHEDULE AT CURRENT_TIMESTAMP ON COMPLETION NOT PRESERVE DO SELECT 1;
20 connection node_1;
21 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event2';
22 COUNT(*) = 0
23 1
24 connection node_1;
25 DROP EVENT event1;
26 connection node_2;
27 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME = 'event1';
28 COUNT(*) = 0
29 1
30 connection node_2;
31 SET GLOBAL event_scheduler = OFF;;