Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_drop_event.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET GLOBAL event_scheduler=off;
5 CREATE TABLE t1 (a INT);
6 CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO t1 VALUES (10);
7 Warnings:
8 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
9 CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO t1 VALUES (11);
10 ERROR HY000: Event 'ev1' already exists
11 CREATE OR REPLACE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO t1 VALUES (11);
12 Warnings:
13 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
14 SELECT EVENT_NAME,STATUS,EVENT_DEFINITION FROM INFORMATION_SCHEMA.EVENTS;
15 EVENT_NAME STATUS EVENT_DEFINITION
16 ev1 ENABLED INSERT INTO t1 VALUES (11)
17 SET GLOBAL event_scheduler=on;
18 SET GLOBAL event_scheduler=off;
19 SELECT DISTINCT a FROM t1;
20 a
21 11
22 DELETE FROM t1;
23 # Syncing slave with master
24 connection slave;
25 SELECT EVENT_NAME,STATUS,EVENT_DEFINITION FROM INFORMATION_SCHEMA.EVENTS;
26 EVENT_NAME STATUS EVENT_DEFINITION
27 ev1 SLAVESIDE_DISABLED INSERT INTO t1 VALUES (11)
28 connection master;
29 DROP TABLE t1;
30 DROP EVENT ev1;
31 connection slave;
32 include/rpl_end.inc