Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set global binlog_alter_two_phase=true;
5 connection slave;
6 include/stop_slave.inc
7 SET STATEMENT sql_log_bin=0 FOR
8 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
9 set global gtid_strict_mode=1;
10 # Legacy Master Slave
11 connect master_node,127.0.0.1,root,,$db_name, $M_port;
12 set gtid_domain_id= 0;;
13 connect slave_node,127.0.0.1,root,,test, $S_port;
14 set gtid_domain_id= 0;;
15 # myisam
16 connection master_node;
17 create table t1(a int, b int) engine=myisam;;
18 insert into t1 values(1,1);
19 insert into t1 values(2,2);
20 # Normal Alter
21 alter table t1 add column c int;
22 show create table t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `a` int(11) DEFAULT NULL,
26 `b` int(11) DEFAULT NULL,
27 `c` int(11) DEFAULT NULL
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
29 # Failed Alter
30 insert into t1 values(1,1, NULL);
31 alter table t1 change a a int unique;
32 ERROR 23000: Duplicate entry '1' for key 'a'
33 set @@session.binlog_alter_two_phase = 0;
34 alter table t1 change a a int;
35 set @@session.binlog_alter_two_phase = 1;
36 alter table t1 change a a int;
37 show create table t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `a` int(11) DEFAULT NULL,
41 `b` int(11) DEFAULT NULL,
42 `c` int(11) DEFAULT NULL
43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 connection master_node;
45 drop table t1;
46 # innodb
47 connection master_node;
48 create table t1(a int, b int) engine=innodb;;
49 insert into t1 values(1,1);
50 insert into t1 values(2,2);
51 # Normal Alter
52 alter table t1 add column c int;
53 show create table t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `a` int(11) DEFAULT NULL,
57 `b` int(11) DEFAULT NULL,
58 `c` int(11) DEFAULT NULL
59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
60 # Failed Alter
61 insert into t1 values(1,1, NULL);
62 alter table t1 change a a int unique;
63 ERROR 23000: Duplicate entry '1' for key 'a'
64 set @@session.binlog_alter_two_phase = 0;
65 alter table t1 change a a int;
66 set @@session.binlog_alter_two_phase = 1;
67 alter table t1 change a a int;
68 show create table t1;
69 Table Create Table
70 t1 CREATE TABLE `t1` (
71 `a` int(11) DEFAULT NULL,
72 `b` int(11) DEFAULT NULL,
73 `c` int(11) DEFAULT NULL
74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
75 connection master_node;
76 drop table t1;
77 # aria
78 connection master_node;
79 create table t1(a int, b int) engine=aria;;
80 insert into t1 values(1,1);
81 insert into t1 values(2,2);
82 # Normal Alter
83 alter table t1 add column c int;
84 show create table t1;
85 Table Create Table
86 t1 CREATE TABLE `t1` (
87 `a` int(11) DEFAULT NULL,
88 `b` int(11) DEFAULT NULL,
89 `c` int(11) DEFAULT NULL
90 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
91 # Failed Alter
92 insert into t1 values(1,1, NULL);
93 alter table t1 change a a int unique;
94 ERROR 23000: Duplicate entry '1' for key 'a'
95 set @@session.binlog_alter_two_phase = 0;
96 alter table t1 change a a int;
97 set @@session.binlog_alter_two_phase = 1;
98 alter table t1 change a a int;
99 show create table t1;
100 Table Create Table
101 t1 CREATE TABLE `t1` (
102 `a` int(11) DEFAULT NULL,
103 `b` int(11) DEFAULT NULL,
104 `c` int(11) DEFAULT NULL
105 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
106 connection master_node;
107 drop table t1;
108 # concurrent alter Myisam
109 # Concurrent DML
110 # Rollback tests
111 ERROR 23000: Duplicate entry '2' for key 'b'
112 ERROR 23000: Duplicate entry '2' for key 'b'
113 ERROR 23000: Duplicate entry '2' for key 'b'
114 ERROR 23000: Duplicate entry '2' for key 'b'
115 ERROR 23000: Duplicate entry '2' for key 'b'
116 ERROR 23000: Duplicate entry '2' for key 'b'
117 ERROR 23000: Duplicate entry '2' for key 'b'
118 ERROR 23000: Duplicate entry '2' for key 'b'
119 ERROR 23000: Duplicate entry '2' for key 'b'
120 ERROR 23000: Duplicate entry '2' for key 'b'
121 # concurrent alter Aria
122 # Concurrent DML
123 # Rollback tests
124 ERROR 23000: Duplicate entry '2' for key 'b'
125 ERROR 23000: Duplicate entry '2' for key 'b'
126 ERROR 23000: Duplicate entry '2' for key 'b'
127 ERROR 23000: Duplicate entry '2' for key 'b'
128 ERROR 23000: Duplicate entry '2' for key 'b'
129 ERROR 23000: Duplicate entry '2' for key 'b'
130 ERROR 23000: Duplicate entry '2' for key 'b'
131 ERROR 23000: Duplicate entry '2' for key 'b'
132 ERROR 23000: Duplicate entry '2' for key 'b'
133 ERROR 23000: Duplicate entry '2' for key 'b'
134 # concurrent alter Innodb copy
135 # Concurrent DML
136 # Rollback tests
137 ERROR 23000: Duplicate entry '2' for key 'b'
138 ERROR 23000: Duplicate entry '2' for key 'b'
139 ERROR 23000: Duplicate entry '2' for key 'b'
140 ERROR 23000: Duplicate entry '2' for key 'b'
141 ERROR 23000: Duplicate entry '2' for key 'b'
142 ERROR 23000: Duplicate entry '2' for key 'b'
143 ERROR 23000: Duplicate entry '2' for key 'b'
144 ERROR 23000: Duplicate entry '2' for key 'b'
145 ERROR 23000: Duplicate entry '2' for key 'b'
146 ERROR 23000: Duplicate entry '2' for key 'b'
147 # concurrent alter Innodb Inplace
148 # Concurrent DML
149 # Rollback tests
150 ERROR 23000: Duplicate entry '2' for key 'b'
151 ERROR 23000: Duplicate entry '2' for key 'b'
152 ERROR 23000: Duplicate entry '2' for key 'b'
153 ERROR 23000: Duplicate entry '2' for key 'b'
154 ERROR 23000: Duplicate entry '2' for key 'b'
155 ERROR 23000: Duplicate entry '2' for key 'b'
156 ERROR 23000: Duplicate entry '2' for key 'b'
157 ERROR 23000: Duplicate entry '2' for key 'b'
158 ERROR 23000: Duplicate entry '2' for key 'b'
159 ERROR 23000: Duplicate entry '2' for key 'b'
160 connection master;
161 select @@gtid_binlog_state;
162 @@gtid_binlog_state
163 0-1-410
164 RESET master;
165 connection slave;
166 select @@gtid_binlog_state;
167 @@gtid_binlog_state
168 0-1-410
169 set global gtid_strict_mode=0;
170 include/start_slave.inc
171 connection master;
172 set global binlog_alter_two_phase=false;
173 include/rpl_end.inc