Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_create_drop_temporary_in_transaction.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 transaction
8 # is not written into binlog after committing the transaction.
9 #
10 BEGIN;
11 CREATE TEMPORARY TABLE temp1 (i INT);
12 COMMIT;
13 include/show_binlog_events.inc
14 include/sync_slave_sql_with_master.inc
15 include/assert.inc [Replica_open_temp_tables shall be 0]
16 [connection master]
17 #
18 # Verify that DROP TEMPORARY TABLE in a single STMT transaction
19 # is not written into binlog after committing the transaction.
20 #
21 BEGIN;
22 DROP TEMPORARY TABLE temp1;
23 COMMIT;
24 include/show_binlog_events.inc
25 CREATE TABLE t1 (c1 INT);
26 #
27 # Verify that CREATE or DML against TEMPORARY TABLE in a MULTI STMTs
28 # transaction is not written into binlog after committing the
29 # transaction.
30 #
31 BEGIN;
32 INSERT INTO t1 VALUES (1);
33 CREATE TEMPORARY TABLE temp1 (i INT);
34 INSERT INTO temp1 VALUES (1);
35 INSERT INTO t1 VALUES (2);
36 COMMIT;
37 include/show_binlog_events.inc
38 Log_name Pos Event_type Server_id End_log_pos Info
39 master-bin.000001 # Query # # BEGIN
40 master-bin.000001 # Table_map # # table_id: # (test.t1)
41 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
42 master-bin.000001 # Table_map # # table_id: # (test.t1)
43 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
44 master-bin.000001 # Xid # # COMMIT /* XID */
45 include/sync_slave_sql_with_master.inc
46 include/assert.inc [Replica_open_temp_tables shall be 0]
47 [connection master]
48 #
49 # Verify that DROP TEMPORARY TABLE in a MULTI STMTs transaction
50 # is not written into binlog after committing the transaction.
51 #
52 BEGIN;
53 INSERT INTO t1 VALUES (3);
54 INSERT INTO temp1 VALUES (2);
55 DROP TEMPORARY TABLE temp1;
56 INSERT INTO t1 VALUES (4);
57 COMMIT;
58 include/show_binlog_events.inc
59 Log_name Pos Event_type Server_id End_log_pos Info
60 master-bin.000001 # Query # # BEGIN
61 master-bin.000001 # Table_map # # table_id: # (test.t1)
62 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
63 master-bin.000001 # Table_map # # table_id: # (test.t1)
64 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
65 master-bin.000001 # Xid # # COMMIT /* XID */
66 include/sync_slave_sql_with_master.inc
67 include/assert.inc [Replica_open_temp_tables shall be 0]
68 [connection master]
69 #
70 # Verify that CREATE TEMPORARY TABLE in a single STMT transaction
71 # is not written into binlog after rolling back the transaction.
72 #
73 BEGIN;
74 CREATE TEMPORARY TABLE temp1 (i INT);
75 ROLLBACK;
76 Warnings:
77 Warning 1751 The creation of some temporary tables could not be rolled back.
78 include/show_binlog_events.inc
79 include/sync_slave_sql_with_master.inc
80 include/assert.inc [Replica_open_temp_tables shall be 0]
81 [connection master]
82 #
83 # Verify that DROP TEMPORARY TABLE in a single STMT transaction
84 # is not written into binlog after rolling back the transaction.
85 #
86 BEGIN;
87 DROP TEMPORARY TABLE temp1;
88 ROLLBACK;
89 Warnings:
90 Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back.
91 include/show_binlog_events.inc
92 #
93 # Verify that CREATE or DML against TEMPORARY TABLE in a MULTI STMTs
94 # transaction is not written into binlog after rolling back the
95 # transaction.
96 #
97 BEGIN;
98 INSERT INTO t1 VALUES (5);
99 CREATE TEMPORARY TABLE temp1 (i INT);
100 INSERT INTO temp1 VALUES (1);
101 INSERT INTO t1 VALUES (6);
102 ROLLBACK;
103 Warnings:
104 Warning 1751 The creation of some temporary tables could not be rolled back.
105 include/show_binlog_events.inc
106 include/sync_slave_sql_with_master.inc
107 include/assert.inc [Replica_open_temp_tables shall be 0]
108 [connection master]
109 #
110 # Verify that DROP TEMPORARY TABLE in a MULTI STMTs transaction
111 # is not written into binlog after rolling back the transaction.
112 #
113 BEGIN;
114 INSERT INTO t1 VALUES (7);
115 INSERT INTO temp1 VALUES (2);
116 DROP TEMPORARY TABLE temp1;
117 INSERT INTO t1 VALUES (8);
118 ROLLBACK;
119 Warnings:
120 Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back.
121 include/show_binlog_events.inc
122 include/sync_slave_sql_with_master.inc
123 include/assert.inc [Replica_open_temp_tables shall be 0]
124 [connection master]
125 CREATE PROCEDURE sp1 ()
126 BEGIN
127 CREATE TEMPORARY TABLE temp1 (i INT);
128 END//
129 CREATE PROCEDURE sp2 ()
130 BEGIN
131 DROP TEMPORARY TABLE temp1;
132 END//
133 CREATE PROCEDURE sp3 ()
134 BEGIN
135 INSERT INTO t1 VALUES (9);
136 CREATE TEMPORARY TABLE temp1 (i INT);
137 INSERT INTO temp1 VALUES (1);
138 END//
139 CREATE PROCEDURE sp4 ()
140 BEGIN
141 INSERT INTO t1 VALUES (10);
142 INSERT INTO temp1 VALUES (2);
143 DROP TEMPORARY TABLE temp1;
144 END//
145 #
146 # Verify that CREATE TEMPORARY TABLE in a single STMT procedure
147 # is not written into binlog after committing the transaction.
148 #
149 START TRANSACTION;
150 CALL sp1();
151 COMMIT;
152 include/show_binlog_events.inc
153 include/sync_slave_sql_with_master.inc
154 include/assert.inc [Replica_open_temp_tables shall be 0]
155 [connection master]
156 #
157 # Verify that DROP TEMPORARY TABLE in a single STMT procedure
158 # is not written into binlog after committing the transaction.
159 #
160 START TRANSACTION;
161 CALL sp2();
162 COMMIT;
163 include/show_binlog_events.inc
164 #
165 # Verify that CREATE or DML against TEMPORARY TABLE in a PROCEDURE
166 # is not written into binlog after committing the transaction.
167 #
168 START TRANSACTION;
169 CALL sp3();
170 COMMIT;
171 include/show_binlog_events.inc
172 Log_name Pos Event_type Server_id End_log_pos Info
173 master-bin.000001 # Query # # BEGIN
174 master-bin.000001 # Table_map # # table_id: # (test.t1)
175 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
176 master-bin.000001 # Xid # # COMMIT /* XID */
177 include/sync_slave_sql_with_master.inc
178 include/assert.inc [Replica_open_temp_tables shall be 0]
179 [connection master]
180 #
181 # Verify that DROP or DML against TEMPORARY TABLE in a PROCEDURE
182 # is not written into binlog after committing the transaction.
183 #
184 START TRANSACTION;
185 CALL sp4();
186 COMMIT;
187 include/show_binlog_events.inc
188 Log_name Pos Event_type Server_id End_log_pos Info
189 master-bin.000001 # Query # # BEGIN
190 master-bin.000001 # Table_map # # table_id: # (test.t1)
191 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
192 master-bin.000001 # Xid # # COMMIT /* XID */
193 include/sync_slave_sql_with_master.inc
194 include/assert.inc [Replica_open_temp_tables shall be 0]
195 [connection master]
196 #
197 # Verify that CREATE TEMPORARY TABLE in a single STMT procedure
198 # is not written into binlog after rolling back the transaction.
199 #
200 START TRANSACTION;
201 CALL sp1();
202 ROLLBACK;
203 Warnings:
204 Warning 1751 The creation of some temporary tables could not be rolled back.
205 include/show_binlog_events.inc
206 include/sync_slave_sql_with_master.inc
207 include/assert.inc [Replica_open_temp_tables shall be 0]
208 [connection master]
209 #
210 # Verify that DROP TEMPORARY TABLE in a single STMT procedure
211 # is not written into binlog after rolling back the transaction.
212 #
213 START TRANSACTION;
214 CALL sp2();
215 ROLLBACK;
216 Warnings:
217 Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back.
218 include/show_binlog_events.inc
219 #
220 # Verify that CREATE or DML against TEMPORARY TABLE in a PROCEDURE
221 # is not written into binlog after rolling back the transaction.
222 #
223 START TRANSACTION;
224 CALL sp3();
225 ROLLBACK;
226 Warnings:
227 Warning 1751 The creation of some temporary tables could not be rolled back.
228 include/show_binlog_events.inc
229 include/sync_slave_sql_with_master.inc
230 include/assert.inc [Replica_open_temp_tables shall be 0]
231 [connection master]
232 #
233 # Verify that DROP or DML against TEMPORARY TABLE in a PROCEDURE
234 # is not written into binlog after rolling back the transaction.
235 #
236 START TRANSACTION;
237 CALL sp4();
238 ROLLBACK;
239 Warnings:
240 Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back.
241 include/show_binlog_events.inc
242 include/sync_slave_sql_with_master.inc
243 include/assert.inc [Replica_open_temp_tables shall be 0]
244 [connection master]
245 DROP TABLE t1;
246 DROP PROCEDURE sp1;
247 DROP PROCEDURE sp2;
248 DROP PROCEDURE sp3;
249 DROP PROCEDURE sp4;
250 include/rpl_end.inc