Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 set session default_storage_engine=innodb;
4 #########################################################################
5 # CONFIGURATION
6 #########################################################################
7 connection master;
8 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb;
9 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb;
10 CREATE TABLE nt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = MyIsam;
11 INSERT INTO tt_1(ddl_case) VALUES(0);
12 INSERT INTO tt_2(ddl_case) VALUES(0);
13 #########################################################################
14 # CHECK IMPLICT COMMIT
15 #########################################################################
16 SET AUTOCOMMIT= 0;
17 INSERT INTO tt_1(ddl_case) VALUES (43);
18 CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "UDF_EXAMPLE_LIB";
19 INSERT INTO tt_1(ddl_case) VALUES (42);
20 DROP FUNCTION myfunc_int;
21 INSERT INTO tt_1(ddl_case) VALUES (41);
22 LOAD INDEX INTO CACHE nt_1 IGNORE LEAVES;
23 Table Op Msg_type Msg_text
24 test.nt_1 preload_keys status OK
25 INSERT INTO tt_1(ddl_case) VALUES (40);
26 LOAD INDEX INTO CACHE tt_1, tt_2 IGNORE LEAVES;
27 Table Op Msg_type Msg_text
28 test.tt_1 preload_keys note The storage engine for the table doesn't support preload_keys
29 test.tt_2 preload_keys note The storage engine for the table doesn't support preload_keys
30 INSERT INTO tt_1(ddl_case) VALUES (39);
31 ANALYZE TABLE nt_1;
32 Table Op Msg_type Msg_text
33 test.nt_1 analyze status Engine-independent statistics collected
34 test.nt_1 analyze status Table is already up to date
35 INSERT INTO tt_1(ddl_case) VALUES (38);
36 CHECK TABLE nt_1;
37 Table Op Msg_type Msg_text
38 test.nt_1 check status OK
39 INSERT INTO tt_1(ddl_case) VALUES (37);
40 OPTIMIZE TABLE nt_1;
41 Table Op Msg_type Msg_text
42 test.nt_1 optimize status Table is already up to date
43 INSERT INTO tt_1(ddl_case) VALUES (36);
44 REPAIR TABLE nt_1;
45 Table Op Msg_type Msg_text
46 test.nt_1 repair status OK
47 INSERT INTO tt_1(ddl_case) VALUES (35);
48 LOCK TABLES tt_1 WRITE;
49 INSERT INTO tt_1(ddl_case) VALUES (34);
50 UNLOCK TABLES;
51 INSERT INTO tt_1(ddl_case) VALUES (33);
52 CREATE USER 'user'@'localhost';
53 INSERT INTO tt_1(ddl_case) VALUES (32);
54 GRANT ALL ON *.* TO 'user'@'localhost';
55 INSERT INTO tt_1(ddl_case) VALUES (31);
56 SET PASSWORD FOR 'user'@'localhost' = PASSWORD('newpass');
57 INSERT INTO tt_1(ddl_case) VALUES (30);
58 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost';
59 INSERT INTO tt_1(ddl_case) VALUES (29);
60 RENAME USER 'user'@'localhost' TO 'user_new'@'localhost';
61 INSERT INTO tt_1(ddl_case) VALUES (28);
62 DROP USER 'user_new'@'localhost';
63 INSERT INTO tt_1(ddl_case) VALUES (27);
64 CREATE EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1;
65 Warnings:
66 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
67 INSERT INTO tt_1(ddl_case) VALUES (26);
68 ALTER EVENT evt COMMENT 'evt';
69 INSERT INTO tt_1(ddl_case) VALUES (25);
70 DROP EVENT evt;
71 INSERT INTO tt_1(ddl_case) VALUES (24);
72 CREATE TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
73 INSERT INTO tt_1(ddl_case) VALUES (23);
74 DROP TRIGGER tr;
75 INSERT INTO tt_1(ddl_case) VALUES (22);
76 CREATE FUNCTION fc () RETURNS VARCHAR(64) RETURN "fc";
77 INSERT INTO tt_1(ddl_case) VALUES (21);
78 ALTER FUNCTION fc COMMENT 'fc';
79 INSERT INTO tt_1(ddl_case) VALUES (20);
80 DROP FUNCTION fc;
81 INSERT INTO tt_1(ddl_case) VALUES (19);
82 CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
83 INSERT INTO tt_1(ddl_case) VALUES (18);
84 ALTER PROCEDURE pc COMMENT 'pc';
85 INSERT INTO tt_1(ddl_case) VALUES (17);
86 DROP PROCEDURE pc;
87 INSERT INTO tt_1(ddl_case) VALUES (16);
88 CREATE VIEW v AS SELECT * FROM tt_1;
89 INSERT INTO tt_1(ddl_case) VALUES (15);
90 ALTER VIEW v AS SELECT * FROM tt_1;
91 INSERT INTO tt_1(ddl_case) VALUES (14);
92 DROP VIEW v;
93 INSERT INTO tt_1(ddl_case) VALUES (13);
94 CREATE INDEX ix ON tt_1(ddl_case);
95 INSERT INTO tt_1(ddl_case) VALUES (12);
96 DROP INDEX ix ON tt_1;
97 INSERT INTO tt_1(ddl_case) VALUES (11);
98 CREATE TEMPORARY TABLE tt_xx (a int);
99 INSERT INTO tt_1(ddl_case) VALUES (10);
100 ALTER TABLE tt_xx ADD COLUMN (b int);
101 INSERT INTO tt_1(ddl_case) VALUES (9);
102 ALTER TABLE tt_xx RENAME new_tt_xx;
103 INSERT INTO tt_1(ddl_case) VALUES (8);
104 DROP TEMPORARY TABLE IF EXISTS new_tt_xx;
105 INSERT INTO tt_1(ddl_case) VALUES (7);
106 CREATE TABLE tt_xx (a int);
107 INSERT INTO tt_1(ddl_case) VALUES (6);
108 ALTER TABLE tt_xx ADD COLUMN (b int);
109 INSERT INTO tt_1(ddl_case) VALUES (5);
110 RENAME TABLE tt_xx TO new_tt_xx;
111 INSERT INTO tt_1(ddl_case) VALUES (4);
112 TRUNCATE TABLE new_tt_xx;
113 INSERT INTO tt_1(ddl_case) VALUES (3);
114 DROP TABLE IF EXISTS tt_xx, new_tt_xx;
115 Warnings:
116 Note 1051 Unknown table 'test.tt_xx'
117 INSERT INTO tt_1(ddl_case) VALUES (2);
118 CREATE DATABASE db;
119 INSERT INTO tt_1(ddl_case) VALUES (1);
120 DROP DATABASE IF EXISTS db;
121 include/show_binlog_events.inc
122 Log_name Pos Event_type Server_id End_log_pos Info
123 master-bin.000001 # Gtid # # GTID #-#-#
124 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb
125 master-bin.000001 # Gtid # # GTID #-#-#
126 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = Innodb
127 master-bin.000001 # Gtid # # GTID #-#-#
128 master-bin.000001 # Query # # use `test`; CREATE TABLE nt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = MyIsam
129 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
130 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES(0)
131 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
132 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
133 master-bin.000001 # Xid # # COMMIT /* XID */
134 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
135 master-bin.000001 # Annotate_rows # # INSERT INTO tt_2(ddl_case) VALUES(0)
136 master-bin.000001 # Table_map # # table_id: # (test.tt_2)
137 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
138 master-bin.000001 # Xid # # COMMIT /* XID */
139 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
140 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (43)
141 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
142 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
143 master-bin.000001 # Xid # # COMMIT /* XID */
144 master-bin.000001 # Gtid # # GTID #-#-#
145 master-bin.000001 # Query # # use `test`; CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "LIB"
146 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
147 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (42)
148 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
149 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
150 master-bin.000001 # Xid # # COMMIT /* XID */
151 master-bin.000001 # Gtid # # GTID #-#-#
152 master-bin.000001 # Query # # use `test`; DROP FUNCTION myfunc_int
153 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
154 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (41)
155 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
156 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
157 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (40)
158 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
159 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
160 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (39)
161 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
162 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
163 master-bin.000001 # Xid # # COMMIT /* XID */
164 master-bin.000001 # Gtid # # GTID #-#-#
165 master-bin.000001 # Query # # use `test`; ANALYZE TABLE nt_1
166 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
167 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (38)
168 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
169 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
170 master-bin.000001 # Xid # # COMMIT /* XID */
171 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
172 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (37)
173 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
174 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
175 master-bin.000001 # Xid # # COMMIT /* XID */
176 master-bin.000001 # Gtid # # GTID #-#-#
177 master-bin.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1
178 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
179 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (36)
180 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
181 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
182 master-bin.000001 # Xid # # COMMIT /* XID */
183 master-bin.000001 # Gtid # # GTID #-#-#
184 master-bin.000001 # Query # # use `test`; REPAIR TABLE nt_1
185 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
186 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (35)
187 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
188 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
189 master-bin.000001 # Xid # # COMMIT /* XID */
190 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
191 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (34)
192 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
193 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
194 master-bin.000001 # Xid # # COMMIT /* XID */
195 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
196 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (33)
197 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
198 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
199 master-bin.000001 # Xid # # COMMIT /* XID */
200 master-bin.000001 # Gtid # # GTID #-#-#
201 master-bin.000001 # Query # # use `test`; CREATE USER 'user'@'localhost'
202 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
203 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (32)
204 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
205 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
206 master-bin.000001 # Xid # # COMMIT /* XID */
207 master-bin.000001 # Gtid # # GTID #-#-#
208 master-bin.000001 # Query # # use `test`; GRANT ALL ON *.* TO 'user'@'localhost'
209 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
210 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (31)
211 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
212 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
213 master-bin.000001 # Xid # # COMMIT /* XID */
214 master-bin.000001 # Gtid # # GTID #-#-#
215 master-bin.000001 # Query # # use `test`; SET PASSWORD FOR 'user'@'localhost'='*D8DECEC305209EEFEC43008E1D420E1AA06B19E0'
216 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
217 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (30)
218 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
219 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
220 master-bin.000001 # Xid # # COMMIT /* XID */
221 master-bin.000001 # Gtid # # GTID #-#-#
222 master-bin.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost'
223 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
224 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (29)
225 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
226 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
227 master-bin.000001 # Xid # # COMMIT /* XID */
228 master-bin.000001 # Gtid # # GTID #-#-#
229 master-bin.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost'
230 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
231 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (28)
232 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
233 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
234 master-bin.000001 # Xid # # COMMIT /* XID */
235 master-bin.000001 # Gtid # # GTID #-#-#
236 master-bin.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost'
237 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
238 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (27)
239 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
240 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
241 master-bin.000001 # Xid # # COMMIT /* XID */
242 master-bin.000001 # Gtid # # GTID #-#-#
243 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1
244 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
245 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (26)
246 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
247 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
248 master-bin.000001 # Xid # # COMMIT /* XID */
249 master-bin.000001 # Gtid # # GTID #-#-#
250 master-bin.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt'
251 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
252 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (25)
253 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
254 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
255 master-bin.000001 # Xid # # COMMIT /* XID */
256 master-bin.000001 # Gtid # # GTID #-#-#
257 master-bin.000001 # Query # # use `test`; DROP EVENT evt
258 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
259 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (24)
260 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
261 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
262 master-bin.000001 # Xid # # COMMIT /* XID */
263 master-bin.000001 # Gtid # # GTID #-#-#
264 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
265 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
266 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (23)
267 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
268 master-bin.000001 # Table_map # # table_id: # (test.tt_2)
269 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
270 master-bin.000001 # Xid # # COMMIT /* XID */
271 master-bin.000001 # Gtid # # GTID #-#-#
272 master-bin.000001 # Query # # use `test`; DROP TRIGGER tr
273 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
274 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (22)
275 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
276 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
277 master-bin.000001 # Xid # # COMMIT /* XID */
278 master-bin.000001 # Gtid # # GTID #-#-#
279 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci
280 RETURN "fc"
281 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
282 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (21)
283 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
284 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
285 master-bin.000001 # Xid # # COMMIT /* XID */
286 master-bin.000001 # Gtid # # GTID #-#-#
287 master-bin.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc'
288 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
289 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (20)
290 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
291 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
292 master-bin.000001 # Xid # # COMMIT /* XID */
293 master-bin.000001 # Gtid # # GTID #-#-#
294 master-bin.000001 # Query # # use `test`; DROP FUNCTION fc
295 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
296 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (19)
297 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
298 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
299 master-bin.000001 # Xid # # COMMIT /* XID */
300 master-bin.000001 # Gtid # # GTID #-#-#
301 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`()
302 UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
303 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
304 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (18)
305 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
306 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
307 master-bin.000001 # Xid # # COMMIT /* XID */
308 master-bin.000001 # Gtid # # GTID #-#-#
309 master-bin.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc'
310 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
311 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (17)
312 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
313 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
314 master-bin.000001 # Xid # # COMMIT /* XID */
315 master-bin.000001 # Gtid # # GTID #-#-#
316 master-bin.000001 # Query # # use `test`; DROP PROCEDURE pc
317 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
318 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (16)
319 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
320 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
321 master-bin.000001 # Xid # # COMMIT /* XID */
322 master-bin.000001 # Gtid # # GTID #-#-#
323 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
324 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
325 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (15)
326 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
327 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
328 master-bin.000001 # Xid # # COMMIT /* XID */
329 master-bin.000001 # Gtid # # GTID #-#-#
330 master-bin.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
331 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
332 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (14)
333 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
334 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
335 master-bin.000001 # Xid # # COMMIT /* XID */
336 master-bin.000001 # Gtid # # GTID #-#-#
337 master-bin.000001 # Query # # use `test`; DROP VIEW v
338 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
339 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (13)
340 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
341 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
342 master-bin.000001 # Xid # # COMMIT /* XID */
343 master-bin.000001 # Gtid # # GTID #-#-#
344 master-bin.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
345 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
346 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (12)
347 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
348 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
349 master-bin.000001 # Xid # # COMMIT /* XID */
350 master-bin.000001 # Gtid # # GTID #-#-#
351 master-bin.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
352 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
353 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (11)
354 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
355 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
356 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (10)
357 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
358 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
359 master-bin.000001 # Xid # # COMMIT /* XID */
360 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
361 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (9)
362 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
363 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
364 master-bin.000001 # Xid # # COMMIT /* XID */
365 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
366 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (8)
367 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
368 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
369 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (7)
370 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
371 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
372 master-bin.000001 # Xid # # COMMIT /* XID */
373 master-bin.000001 # Gtid # # GTID #-#-#
374 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int)
375 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
376 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (6)
377 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
378 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
379 master-bin.000001 # Xid # # COMMIT /* XID */
380 master-bin.000001 # Gtid # # GTID #-#-#
381 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int)
382 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
383 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (5)
384 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
385 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
386 master-bin.000001 # Xid # # COMMIT /* XID */
387 master-bin.000001 # Gtid # # GTID #-#-#
388 master-bin.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx
389 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
390 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (4)
391 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
392 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
393 master-bin.000001 # Xid # # COMMIT /* XID */
394 master-bin.000001 # Gtid # # GTID #-#-#
395 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE new_tt_xx
396 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
397 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (3)
398 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
399 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
400 master-bin.000001 # Xid # # COMMIT /* XID */
401 master-bin.000001 # Gtid # # GTID #-#-#
402 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_xx`,`new_tt_xx` /* generated by server */
403 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
404 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (2)
405 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
406 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
407 master-bin.000001 # Xid # # COMMIT /* XID */
408 master-bin.000001 # Gtid # # GTID #-#-#
409 master-bin.000001 # Query # # CREATE DATABASE db
410 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
411 master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (1)
412 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
413 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
414 master-bin.000001 # Xid # # COMMIT /* XID */
415 master-bin.000001 # Gtid # # GTID #-#-#
416 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db
417 SET AUTOCOMMIT= 1;
418 ###################################################################################
419 # CHECK CONSISTENCY
420 ###################################################################################
421 connection slave;
422 include/diff_tables.inc [master:tt_1,slave:tt_1]
423 ###################################################################################
424 # CLEAN
425 ###################################################################################
426 connection master;
427 DROP TABLE tt_1;
428 DROP TABLE tt_2;
429 DROP TABLE nt_1;
430 connection slave;
431 include/rpl_end.inc