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 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES(0) 131master-bin.000001 # Table_map # # table_id: # (test.tt_1) 132master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 133master-bin.000001 # Xid # # COMMIT /* XID */ 134master-bin.000001 # Gtid # # BEGIN GTID #-#-# 135master-bin.000001 # Annotate_rows # # INSERT INTO tt_2(ddl_case) VALUES(0) 136master-bin.000001 # Table_map # # table_id: # (test.tt_2) 137master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 138master-bin.000001 # Xid # # COMMIT /* XID */ 139master-bin.000001 # Gtid # # BEGIN GTID #-#-# 140master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (43) 141master-bin.000001 # Table_map # # table_id: # (test.tt_1) 142master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 143master-bin.000001 # Xid # # COMMIT /* XID */ 144master-bin.000001 # Gtid # # GTID #-#-# 145master-bin.000001 # Query # # use `test`; CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "LIB" 146master-bin.000001 # Gtid # # BEGIN GTID #-#-# 147master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (42) 148master-bin.000001 # Table_map # # table_id: # (test.tt_1) 149master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 150master-bin.000001 # Xid # # COMMIT /* XID */ 151master-bin.000001 # Gtid # # GTID #-#-# 152master-bin.000001 # Query # # use `test`; DROP FUNCTION myfunc_int 153master-bin.000001 # Gtid # # BEGIN GTID #-#-# 154master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (41) 155master-bin.000001 # Table_map # # table_id: # (test.tt_1) 156master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 157master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (40) 158master-bin.000001 # Table_map # # table_id: # (test.tt_1) 159master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 160master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (39) 161master-bin.000001 # Table_map # # table_id: # (test.tt_1) 162master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 163master-bin.000001 # Xid # # COMMIT /* XID */ 164master-bin.000001 # Gtid # # GTID #-#-# 165master-bin.000001 # Query # # use `test`; ANALYZE TABLE nt_1 166master-bin.000001 # Gtid # # BEGIN GTID #-#-# 167master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (38) 168master-bin.000001 # Table_map # # table_id: # (test.tt_1) 169master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 170master-bin.000001 # Xid # # COMMIT /* XID */ 171master-bin.000001 # Gtid # # BEGIN GTID #-#-# 172master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (37) 173master-bin.000001 # Table_map # # table_id: # (test.tt_1) 174master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 175master-bin.000001 # Xid # # COMMIT /* XID */ 176master-bin.000001 # Gtid # # GTID #-#-# 177master-bin.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1 178master-bin.000001 # Gtid # # BEGIN GTID #-#-# 179master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (36) 180master-bin.000001 # Table_map # # table_id: # (test.tt_1) 181master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 182master-bin.000001 # Xid # # COMMIT /* XID */ 183master-bin.000001 # Gtid # # GTID #-#-# 184master-bin.000001 # Query # # use `test`; REPAIR TABLE nt_1 185master-bin.000001 # Gtid # # BEGIN GTID #-#-# 186master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (35) 187master-bin.000001 # Table_map # # table_id: # (test.tt_1) 188master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 189master-bin.000001 # Xid # # COMMIT /* XID */ 190master-bin.000001 # Gtid # # BEGIN GTID #-#-# 191master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (34) 192master-bin.000001 # Table_map # # table_id: # (test.tt_1) 193master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 194master-bin.000001 # Xid # # COMMIT /* XID */ 195master-bin.000001 # Gtid # # BEGIN GTID #-#-# 196master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (33) 197master-bin.000001 # Table_map # # table_id: # (test.tt_1) 198master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 199master-bin.000001 # Xid # # COMMIT /* XID */ 200master-bin.000001 # Gtid # # GTID #-#-# 201master-bin.000001 # Query # # use `test`; CREATE USER 'user'@'localhost' 202master-bin.000001 # Gtid # # BEGIN GTID #-#-# 203master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (32) 204master-bin.000001 # Table_map # # table_id: # (test.tt_1) 205master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 206master-bin.000001 # Xid # # COMMIT /* XID */ 207master-bin.000001 # Gtid # # GTID #-#-# 208master-bin.000001 # Query # # use `test`; GRANT ALL ON *.* TO 'user'@'localhost' 209master-bin.000001 # Gtid # # BEGIN GTID #-#-# 210master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (31) 211master-bin.000001 # Table_map # # table_id: # (test.tt_1) 212master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 213master-bin.000001 # Xid # # COMMIT /* XID */ 214master-bin.000001 # Gtid # # GTID #-#-# 215master-bin.000001 # Query # # use `test`; SET PASSWORD FOR 'user'@'localhost'='*D8DECEC305209EEFEC43008E1D420E1AA06B19E0' 216master-bin.000001 # Gtid # # BEGIN GTID #-#-# 217master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (30) 218master-bin.000001 # Table_map # # table_id: # (test.tt_1) 219master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 220master-bin.000001 # Xid # # COMMIT /* XID */ 221master-bin.000001 # Gtid # # GTID #-#-# 222master-bin.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost' 223master-bin.000001 # Gtid # # BEGIN GTID #-#-# 224master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (29) 225master-bin.000001 # Table_map # # table_id: # (test.tt_1) 226master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 227master-bin.000001 # Xid # # COMMIT /* XID */ 228master-bin.000001 # Gtid # # GTID #-#-# 229master-bin.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost' 230master-bin.000001 # Gtid # # BEGIN GTID #-#-# 231master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (28) 232master-bin.000001 # Table_map # # table_id: # (test.tt_1) 233master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 234master-bin.000001 # Xid # # COMMIT /* XID */ 235master-bin.000001 # Gtid # # GTID #-#-# 236master-bin.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost' 237master-bin.000001 # Gtid # # BEGIN GTID #-#-# 238master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (27) 239master-bin.000001 # Table_map # # table_id: # (test.tt_1) 240master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 241master-bin.000001 # Xid # # COMMIT /* XID */ 242master-bin.000001 # Gtid # # GTID #-#-# 243master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1 244master-bin.000001 # Gtid # # BEGIN GTID #-#-# 245master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (26) 246master-bin.000001 # Table_map # # table_id: # (test.tt_1) 247master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 248master-bin.000001 # Xid # # COMMIT /* XID */ 249master-bin.000001 # Gtid # # GTID #-#-# 250master-bin.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt' 251master-bin.000001 # Gtid # # BEGIN GTID #-#-# 252master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (25) 253master-bin.000001 # Table_map # # table_id: # (test.tt_1) 254master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 255master-bin.000001 # Xid # # COMMIT /* XID */ 256master-bin.000001 # Gtid # # GTID #-#-# 257master-bin.000001 # Query # # use `test`; DROP EVENT evt 258master-bin.000001 # Gtid # # BEGIN GTID #-#-# 259master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (24) 260master-bin.000001 # Table_map # # table_id: # (test.tt_1) 261master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 262master-bin.000001 # Xid # # COMMIT /* XID */ 263master-bin.000001 # Gtid # # GTID #-#-# 264master-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 265master-bin.000001 # Gtid # # BEGIN GTID #-#-# 266master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (23) 267master-bin.000001 # Table_map # # table_id: # (test.tt_1) 268master-bin.000001 # Table_map # # table_id: # (test.tt_2) 269master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 270master-bin.000001 # Xid # # COMMIT /* XID */ 271master-bin.000001 # Gtid # # GTID #-#-# 272master-bin.000001 # Query # # use `test`; DROP TRIGGER tr 273master-bin.000001 # Gtid # # BEGIN GTID #-#-# 274master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (22) 275master-bin.000001 # Table_map # # table_id: # (test.tt_1) 276master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 277master-bin.000001 # Xid # # COMMIT /* XID */ 278master-bin.000001 # Gtid # # GTID #-#-# 279master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET latin1 280RETURN "fc" 281master-bin.000001 # Gtid # # BEGIN GTID #-#-# 282master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (21) 283master-bin.000001 # Table_map # # table_id: # (test.tt_1) 284master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 285master-bin.000001 # Xid # # COMMIT /* XID */ 286master-bin.000001 # Gtid # # GTID #-#-# 287master-bin.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc' 288master-bin.000001 # Gtid # # BEGIN GTID #-#-# 289master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (20) 290master-bin.000001 # Table_map # # table_id: # (test.tt_1) 291master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 292master-bin.000001 # Xid # # COMMIT /* XID */ 293master-bin.000001 # Gtid # # GTID #-#-# 294master-bin.000001 # Query # # use `test`; DROP FUNCTION fc 295master-bin.000001 # Gtid # # BEGIN GTID #-#-# 296master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (19) 297master-bin.000001 # Table_map # # table_id: # (test.tt_1) 298master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 299master-bin.000001 # Xid # # COMMIT /* XID */ 300master-bin.000001 # Gtid # # GTID #-#-# 301master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`() 302UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case 303master-bin.000001 # Gtid # # BEGIN GTID #-#-# 304master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (18) 305master-bin.000001 # Table_map # # table_id: # (test.tt_1) 306master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 307master-bin.000001 # Xid # # COMMIT /* XID */ 308master-bin.000001 # Gtid # # GTID #-#-# 309master-bin.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc' 310master-bin.000001 # Gtid # # BEGIN GTID #-#-# 311master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (17) 312master-bin.000001 # Table_map # # table_id: # (test.tt_1) 313master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 314master-bin.000001 # Xid # # COMMIT /* XID */ 315master-bin.000001 # Gtid # # GTID #-#-# 316master-bin.000001 # Query # # use `test`; DROP PROCEDURE pc 317master-bin.000001 # Gtid # # BEGIN GTID #-#-# 318master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (16) 319master-bin.000001 # Table_map # # table_id: # (test.tt_1) 320master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 321master-bin.000001 # Xid # # COMMIT /* XID */ 322master-bin.000001 # Gtid # # GTID #-#-# 323master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1 324master-bin.000001 # Gtid # # BEGIN GTID #-#-# 325master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (15) 326master-bin.000001 # Table_map # # table_id: # (test.tt_1) 327master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 328master-bin.000001 # Xid # # COMMIT /* XID */ 329master-bin.000001 # Gtid # # GTID #-#-# 330master-bin.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1 331master-bin.000001 # Gtid # # BEGIN GTID #-#-# 332master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (14) 333master-bin.000001 # Table_map # # table_id: # (test.tt_1) 334master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 335master-bin.000001 # Xid # # COMMIT /* XID */ 336master-bin.000001 # Gtid # # GTID #-#-# 337master-bin.000001 # Query # # use `test`; DROP VIEW v 338master-bin.000001 # Gtid # # BEGIN GTID #-#-# 339master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (13) 340master-bin.000001 # Table_map # # table_id: # (test.tt_1) 341master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 342master-bin.000001 # Xid # # COMMIT /* XID */ 343master-bin.000001 # Gtid # # GTID #-#-# 344master-bin.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case) 345master-bin.000001 # Gtid # # BEGIN GTID #-#-# 346master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (12) 347master-bin.000001 # Table_map # # table_id: # (test.tt_1) 348master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 349master-bin.000001 # Xid # # COMMIT /* XID */ 350master-bin.000001 # Gtid # # GTID #-#-# 351master-bin.000001 # Query # # use `test`; DROP INDEX ix ON tt_1 352master-bin.000001 # Gtid # # BEGIN GTID #-#-# 353master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (11) 354master-bin.000001 # Table_map # # table_id: # (test.tt_1) 355master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 356master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (10) 357master-bin.000001 # Table_map # # table_id: # (test.tt_1) 358master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 359master-bin.000001 # Xid # # COMMIT /* XID */ 360master-bin.000001 # Gtid # # BEGIN GTID #-#-# 361master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (9) 362master-bin.000001 # Table_map # # table_id: # (test.tt_1) 363master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 364master-bin.000001 # Xid # # COMMIT /* XID */ 365master-bin.000001 # Gtid # # BEGIN GTID #-#-# 366master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (8) 367master-bin.000001 # Table_map # # table_id: # (test.tt_1) 368master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 369master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (7) 370master-bin.000001 # Table_map # # table_id: # (test.tt_1) 371master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 372master-bin.000001 # Xid # # COMMIT /* XID */ 373master-bin.000001 # Gtid # # GTID #-#-# 374master-bin.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int) 375master-bin.000001 # Gtid # # BEGIN GTID #-#-# 376master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (6) 377master-bin.000001 # Table_map # # table_id: # (test.tt_1) 378master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 379master-bin.000001 # Xid # # COMMIT /* XID */ 380master-bin.000001 # Gtid # # GTID #-#-# 381master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int) 382master-bin.000001 # Gtid # # BEGIN GTID #-#-# 383master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (5) 384master-bin.000001 # Table_map # # table_id: # (test.tt_1) 385master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 386master-bin.000001 # Xid # # COMMIT /* XID */ 387master-bin.000001 # Gtid # # GTID #-#-# 388master-bin.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx 389master-bin.000001 # Gtid # # BEGIN GTID #-#-# 390master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (4) 391master-bin.000001 # Table_map # # table_id: # (test.tt_1) 392master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 393master-bin.000001 # Xid # # COMMIT /* XID */ 394master-bin.000001 # Gtid # # GTID #-#-# 395master-bin.000001 # Query # # use `test`; TRUNCATE TABLE new_tt_xx 396master-bin.000001 # Gtid # # BEGIN GTID #-#-# 397master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (3) 398master-bin.000001 # Table_map # # table_id: # (test.tt_1) 399master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 400master-bin.000001 # Xid # # COMMIT /* XID */ 401master-bin.000001 # Gtid # # GTID #-#-# 402master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_xx`,`new_tt_xx` /* generated by server */ 403master-bin.000001 # Gtid # # BEGIN GTID #-#-# 404master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (2) 405master-bin.000001 # Table_map # # table_id: # (test.tt_1) 406master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 407master-bin.000001 # Xid # # COMMIT /* XID */ 408master-bin.000001 # Gtid # # GTID #-#-# 409master-bin.000001 # Query # # CREATE DATABASE db 410master-bin.000001 # Gtid # # BEGIN GTID #-#-# 411master-bin.000001 # Annotate_rows # # INSERT INTO tt_1(ddl_case) VALUES (1) 412master-bin.000001 # Table_map # # table_id: # (test.tt_1) 413master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 414master-bin.000001 # Xid # # COMMIT /* XID */ 415master-bin.000001 # Gtid # # GTID #-#-# 416master-bin.000001 # Query # # DROP DATABASE IF EXISTS db 417SET AUTOCOMMIT= 1; 418################################################################################### 419# CHECK CONSISTENCY 420################################################################################### 421connection slave; 422include/diff_tables.inc [master:tt_1,slave:tt_1] 423################################################################################### 424# CLEAN 425################################################################################### 426connection master; 427DROP TABLE tt_1; 428DROP TABLE tt_2; 429DROP TABLE nt_1; 430connection slave; 431include/rpl_end.inc 432