Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_create_drop_temporary_in_event.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 #
7 # Verify that CREATE TEMPORARY TABLE in a single STMT EVENT
8 # is written into binlog after executing the event when
9 # @@session.binlog_format=STATEMENT.
10 #
11 CREATE EVENT event1
12 ON SCHEDULE EVERY 2 SECOND
13 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
14 ON COMPLETION NOT PRESERVE
15 DO BEGIN
16 CREATE TEMPORARY TABLE temp1 (i INT);
17 END;|
18 include/show_binlog_events.inc
19 Log_name Pos Event_type Server_id End_log_pos Info
20 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1
21 ON SCHEDULE EVERY 2 SECOND
22 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
23 ON COMPLETION NOT PRESERVE
24 DO BEGIN
25 CREATE TEMPORARY TABLE temp1 (i INT);
26 END
27 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT)
28 include/sync_slave_sql_with_master.inc
29 include/assert.inc [Replica_open_temp_tables shall be 0]
30 [connection master]
31 #
32 # Verify that DROP TEMPORARY TABLE in a single STMT EVENT
33 # is written into binlog after executing the event when
34 # @@session.binlog_format=STATEMENT.
35 #
36 CREATE EVENT event1
37 ON SCHEDULE EVERY 2 SECOND
38 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
39 ON COMPLETION NOT PRESERVE
40 DO BEGIN
41 CREATE TEMPORARY TABLE temp1 (i INT);
42 DROP TEMPORARY TABLE temp1;
43 END;|
44 include/show_binlog_events.inc
45 Log_name Pos Event_type Server_id End_log_pos Info
46 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1
47 ON SCHEDULE EVERY 2 SECOND
48 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
49 ON COMPLETION NOT PRESERVE
50 DO BEGIN
51 CREATE TEMPORARY TABLE temp1 (i INT);
52 DROP TEMPORARY TABLE temp1;
53 END
54 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT)
55 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `temp1` /* generated by server */
56 CREATE TABLE t1 (i INT);
57 #
58 # Verify that CREATE TEMPORARY TABLE in a MULTI STMTs EVENT
59 # is written into binlog after executing the event when
60 # @@session.binlog_format=STATEMENT.
61 #
62 CREATE EVENT event1
63 ON SCHEDULE EVERY 2 SECOND
64 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
65 ON COMPLETION NOT PRESERVE
66 DO BEGIN
67 CREATE TEMPORARY TABLE temp1 (i INT);
68 INSERT INTO temp1 VALUES (1);
69 INSERT INTO t1 VALUES (2);
70 END;|
71 include/show_binlog_events.inc
72 Log_name Pos Event_type Server_id End_log_pos Info
73 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1
74 ON SCHEDULE EVERY 2 SECOND
75 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
76 ON COMPLETION NOT PRESERVE
77 DO BEGIN
78 CREATE TEMPORARY TABLE temp1 (i INT);
79 INSERT INTO temp1 VALUES (1);
80 INSERT INTO t1 VALUES (2);
81 END
82 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT)
83 master-bin.000001 # Query # # BEGIN
84 master-bin.000001 # Query # # use `test`; INSERT INTO temp1 VALUES (1)
85 master-bin.000001 # Query # # COMMIT
86 master-bin.000001 # Query # # BEGIN
87 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
88 master-bin.000001 # Xid # # COMMIT /* XID */
89 include/sync_slave_sql_with_master.inc
90 include/assert.inc [Replica_open_temp_tables shall be 0]
91 [connection master]
92 #
93 # Verify that DROP TEMPORARY TABLE in a MULTI STMTs EVENT
94 # is written into binlog after executing the event when
95 # @@session.binlog_format=STATEMENT.
96 #
97 CREATE EVENT event1
98 ON SCHEDULE EVERY 2 SECOND
99 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
100 ON COMPLETION NOT PRESERVE
101 DO BEGIN
102 CREATE TEMPORARY TABLE temp1 (i INT);
103 INSERT INTO temp1 VALUES (1);
104 DROP TEMPORARY TABLE temp1;
105 INSERT INTO t1 VALUES (4);
106 END;|
107 include/show_binlog_events.inc
108 Log_name Pos Event_type Server_id End_log_pos Info
109 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1
110 ON SCHEDULE EVERY 2 SECOND
111 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
112 ON COMPLETION NOT PRESERVE
113 DO BEGIN
114 CREATE TEMPORARY TABLE temp1 (i INT);
115 INSERT INTO temp1 VALUES (1);
116 DROP TEMPORARY TABLE temp1;
117 INSERT INTO t1 VALUES (4);
118 END
119 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT)
120 master-bin.000001 # Query # # BEGIN
121 master-bin.000001 # Query # # use `test`; INSERT INTO temp1 VALUES (1)
122 master-bin.000001 # Query # # COMMIT
123 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `temp1` /* generated by server */
124 master-bin.000001 # Query # # BEGIN
125 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4)
126 master-bin.000001 # Xid # # COMMIT /* XID */
127 include/sync_slave_sql_with_master.inc
128 include/assert.inc [Replica_open_temp_tables shall be 0]
129 [connection master]
130 DROP TABLE t1;
131 include/rpl_end.inc