Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set binlog_alter_two_phase=true;
5 CREATE OR REPLACE TABLE tab (
6 a int PRIMARY KEY,
7 b varchar(50),
8 c varchar(50)
9 ) CHARACTER SET=latin1 engine=innodb;
10 ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant;
11 ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy;
12 SHOW CREATE TABLE tab;
13 Table Create Table
14 tab CREATE TABLE `tab` (
15 `a` int(11) NOT NULL,
16 `b` varchar(100) DEFAULT NULL,
17 `c` varchar(100) DEFAULT NULL,
18 PRIMARY KEY (`a`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Gtid # # GTID #-#-#
23 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE tab (
24 a int PRIMARY KEY,
25 b varchar(50),
26 c varchar(50)
27 ) CHARACTER SET=latin1 engine=innodb
28 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
29 master-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant
30 master-bin.000001 # Gtid # # GTID #-#-# COMMIT ALTER id=#
31 master-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant
32 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
33 master-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy
34 master-bin.000001 # Gtid # # GTID #-#-# COMMIT ALTER id=#
35 master-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy
36 connection slave;
37 SHOW CREATE TABLE tab;
38 Table Create Table
39 tab CREATE TABLE `tab` (
40 `a` int(11) NOT NULL,
41 `b` varchar(100) DEFAULT NULL,
42 `c` varchar(100) DEFAULT NULL,
43 PRIMARY KEY (`a`)
44 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
45 include/show_binlog_events.inc
46 Log_name Pos Event_type Server_id End_log_pos Info
47 slave-bin.000001 # Gtid # # GTID #-#-#
48 slave-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE tab (
49 a int PRIMARY KEY,
50 b varchar(50),
51 c varchar(50)
52 ) CHARACTER SET=latin1 engine=innodb
53 slave-bin.000001 # Gtid # # GTID #-#-# START ALTER
54 slave-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant
55 slave-bin.000001 # Gtid # # GTID #-#-# COMMIT ALTER id=#
56 slave-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN b varchar(100), algorithm=instant
57 slave-bin.000001 # Gtid # # GTID #-#-# START ALTER
58 slave-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy
59 slave-bin.000001 # Gtid # # GTID #-#-# COMMIT ALTER id=#
60 slave-bin.000001 # Query # # use `test`; ALTER TABLE tab MODIFY COLUMN c varchar(100), algorithm=nocopy
61 connection master;
62 DROP TABLE tab;
63 connection slave;
64 include/rpl_end.inc