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