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