Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET @old_event_scheduler = @@global.event_scheduler;
7 set global event_scheduler=1;
8 CREATE TABLE t28953 (a INT);
9 CREATE EVENT event1 ON SCHEDULE EVERY 1 YEAR
10 DO BEGIN
11 select * from t28953;
12 END;|
13 ALTER EVENT event1 RENAME TO event2;
14 include/sync_slave_sql_with_master.inc
15 DROP EVENT event2;
16 CREATE TABLE test.t1(details CHAR(30));
17 CREATE EVENT /*!50000 event44331_1 */
18 ON SCHEDULE AT CURRENT_TIMESTAMP
19 ON COMPLETION PRESERVE DISABLE
20 DO INSERT INTO test.t1 VALUES('event event44331_1 fired - no definer');
21 CREATE DEFINER=CURRENT_USER /*!50000 EVENT event44331_2 */
22 ON SCHEDULE AT CURRENT_TIMESTAMP
23 ON COMPLETION PRESERVE DISABLE
24 DO INSERT INTO test.t1 VALUES('event event44331_2 fired - DEFINER=CURRENT_USER');
25 CREATE DEFINER=CURRENT_USER() EVENT event44331_3
26 ON SCHEDULE AT CURRENT_TIMESTAMP
27 ON COMPLETION PRESERVE DISABLE
28 DO INSERT INTO test.t1 VALUES('event event44331_3 fired - DEFINER=CURRENT_USER() function');
29 CREATE /*!50000 DEFINER='user44331' */ EVENT event44331_4
30 ON SCHEDULE AT CURRENT_TIMESTAMP
31 ON COMPLETION PRESERVE DISABLE
32 DO INSERT INTO test.t1 VALUES('event event44331_4 fired - DEFINER=user1');
33 # Test for bug#50095 Multi-statement including CREATE EVENT causes rotten
34 # binlog entry
35 SELECT 'ABC';
36 SELECT '123'|
37 ABC
38 ABC
39 123
40 123
41 #on master
42 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
43 where EVENT_NAME='event44331_1';
44 EVENT_SCHEMA EVENT_NAME DEFINER
45 test event44331_1 root@localhost
46 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
47 where EVENT_NAME='event44331_2';
48 EVENT_SCHEMA EVENT_NAME DEFINER
49 test event44331_2 root@localhost
50 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
51 where EVENT_NAME='event44331_3';
52 EVENT_SCHEMA EVENT_NAME DEFINER
53 test event44331_3 root@localhost
54 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
55 where EVENT_NAME='event44331_4';
56 EVENT_SCHEMA EVENT_NAME DEFINER
57 test event44331_4 user44331@%
58 include/sync_slave_sql_with_master.inc
59 #on slave
60 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
61 where EVENT_NAME='event44331_1';
62 EVENT_SCHEMA EVENT_NAME DEFINER
63 test event44331_1 root@localhost
64 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
65 where EVENT_NAME='event44331_2';
66 EVENT_SCHEMA EVENT_NAME DEFINER
67 test event44331_2 root@localhost
68 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
69 where EVENT_NAME='event44331_3';
70 EVENT_SCHEMA EVENT_NAME DEFINER
71 test event44331_3 root@localhost
72 select EVENT_SCHEMA, EVENT_NAME, DEFINER from information_schema.events
73 where EVENT_NAME='event44331_4';
74 EVENT_SCHEMA EVENT_NAME DEFINER
75 test event44331_4 user44331@%
76 SET @@global.event_scheduler= @old_event_scheduler;
77 DROP TABLE t28953;
78 DROP TABLE t1;
79 DROP EVENT event44331_1;
80 DROP EVENT event44331_2;
81 DROP EVENT event44331_3;
82 DROP EVENT event44331_4;
83 include/sync_slave_sql_with_master.inc
84 CREATE EVENT event1 ON SCHEDULE EVERY 100 SECOND STARTS '2000-01-01 00:00:00'
85 ON COMPLETION PRESERVE ENABLE DO
86 BEGIN
87 SET @dummy = 100;
88 END\\
89 CREATE PROCEDURE proc1()
90 BEGIN
91 DECLARE dummy INT UNSIGNED;
92 SET dummy = 100;
93 ALTER EVENT EVENT1 ON SCHEDULE EVERY dummy SECOND
94 STARTS '2000-01-01 00:00:00' ENABLE;
95 END \\
96 CALL proc1();
97 include/sync_slave_sql_with_master.inc
98 DROP EVENT event1;
99 DROP PROCEDURE proc1;
100 call mtr.add_suppression("Unsafe statement written to the binary log");
101 set @secs=100;
102 CREATE EVENT EVENT_WITH_SYSDATE_AND_VARIABLES
103 ON SCHEDULE EVERY @secs MINUTE STARTS sysdate()
104 ON COMPLETION PRESERVE
105 DO BEGIN
106 DECLARE EXIT HANDLER FOR SQLEXCEPTION
107 SELECT CONCAT('SAMPLE MSG');
108 END |
109 ALTER EVENT EVENT_WITH_SYSDATE_AND_VARIABLES
110 ON SCHEDULE
111 EVERY @secs HOUR
112 STARTS sysdate() |
113 DROP EVENT EVENT_WITH_SYSDATE_AND_VARIABLES |
114 include/rpl_end.inc