Debian Codegraph @

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