Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 DROP TABLE IF EXISTS `t1`;
7 ### TABLE with field_metadata_size == 290
8 CREATE TABLE `t1` (
9 `c1` int(11) NOT NULL AUTO_INCREMENT,
10 `c2` varchar(30) NOT NULL,
11 `c3` varchar(30) DEFAULT NULL,
12 `c4` varchar(30) DEFAULT NULL,
13 `c5` varchar(30) DEFAULT NULL,
14 `c6` varchar(30) DEFAULT NULL,
15 `c7` varchar(30) DEFAULT NULL,
16 `c8` varchar(30) DEFAULT NULL,
17 `c9` varchar(30) DEFAULT NULL,
18 `c10` varchar(30) DEFAULT NULL,
19 `c11` varchar(30) DEFAULT NULL,
20 `c12` varchar(30) DEFAULT NULL,
21 `c13` varchar(30) DEFAULT NULL,
22 `c14` varchar(30) DEFAULT NULL,
23 `c15` varchar(30) DEFAULT NULL,
24 `c16` varchar(30) DEFAULT NULL,
25 `c17` varchar(30) DEFAULT NULL,
26 `c18` varchar(30) DEFAULT NULL,
27 `c19` varchar(30) DEFAULT NULL,
28 `c20` varchar(30) DEFAULT NULL,
29 `c21` varchar(30) DEFAULT NULL,
30 `c22` varchar(30) DEFAULT NULL,
31 `c23` varchar(30) DEFAULT NULL,
32 `c24` varchar(30) DEFAULT NULL,
33 `c25` varchar(30) DEFAULT NULL,
34 `c26` varchar(30) DEFAULT NULL,
35 `c27` varchar(30) DEFAULT NULL,
36 `c28` varchar(30) DEFAULT NULL,
37 `c29` varchar(30) DEFAULT NULL,
38 `c30` varchar(30) DEFAULT NULL,
39 `c31` varchar(30) DEFAULT NULL,
40 `c32` varchar(30) DEFAULT NULL,
41 `c33` varchar(30) DEFAULT NULL,
42 `c34` varchar(30) DEFAULT NULL,
43 `c35` varchar(30) DEFAULT NULL,
44 `c36` varchar(30) DEFAULT NULL,
45 `c37` varchar(30) DEFAULT NULL,
46 `c38` varchar(30) DEFAULT NULL,
47 `c39` varchar(30) DEFAULT NULL,
48 `c40` varchar(30) DEFAULT NULL,
49 `c41` varchar(30) DEFAULT NULL,
50 `c42` varchar(30) DEFAULT NULL,
51 `c43` varchar(30) DEFAULT NULL,
52 `c44` varchar(30) DEFAULT NULL,
53 `c45` varchar(30) DEFAULT NULL,
54 `c46` varchar(30) DEFAULT NULL,
55 `c47` varchar(30) DEFAULT NULL,
56 `c48` varchar(30) DEFAULT NULL,
57 `c49` varchar(30) DEFAULT NULL,
58 `c50` varchar(30) DEFAULT NULL,
59 `c51` varchar(30) DEFAULT NULL,
60 `c52` varchar(30) DEFAULT NULL,
61 `c53` varchar(30) DEFAULT NULL,
62 `c54` varchar(30) DEFAULT NULL,
63 `c55` varchar(30) DEFAULT NULL,
64 `c56` varchar(30) DEFAULT NULL,
65 `c57` varchar(30) DEFAULT NULL,
66 `c58` varchar(30) DEFAULT NULL,
67 `c59` varchar(30) DEFAULT NULL,
68 `c60` varchar(30) DEFAULT NULL,
69 `c61` varchar(30) DEFAULT NULL,
70 `c62` varchar(30) DEFAULT NULL,
71 `c63` varchar(30) DEFAULT NULL,
72 `c64` varchar(30) DEFAULT NULL,
73 `c65` varchar(30) DEFAULT NULL,
74 `c66` varchar(30) DEFAULT NULL,
75 `c67` varchar(30) DEFAULT NULL,
76 `c68` varchar(30) DEFAULT NULL,
77 `c69` varchar(30) DEFAULT NULL,
78 `c70` varchar(30) DEFAULT NULL,
79 `c71` varchar(30) DEFAULT NULL,
80 `c72` varchar(30) DEFAULT NULL,
81 `c73` varchar(30) DEFAULT NULL,
82 `c74` varchar(30) DEFAULT NULL,
83 `c75` varchar(30) DEFAULT NULL,
84 `c76` varchar(30) DEFAULT NULL,
85 `c77` varchar(30) DEFAULT NULL,
86 `c78` varchar(30) DEFAULT NULL,
87 `c79` varchar(30) DEFAULT NULL,
88 `c80` varchar(30) DEFAULT NULL,
89 `c81` varchar(30) DEFAULT NULL,
90 `c82` varchar(30) DEFAULT NULL,
91 `c83` varchar(30) DEFAULT NULL,
92 `c84` varchar(30) DEFAULT NULL,
93 `c85` varchar(30) DEFAULT NULL,
94 `c86` varchar(30) DEFAULT NULL,
95 `c87` varchar(30) DEFAULT NULL,
96 `c88` varchar(30) DEFAULT NULL,
97 `c89` varchar(30) DEFAULT NULL,
98 `c90` varchar(30) DEFAULT NULL,
99 `c91` varchar(30) DEFAULT NULL,
100 `c92` varchar(30) DEFAULT NULL,
101 `c93` varchar(30) DEFAULT NULL,
102 `c94` varchar(30) DEFAULT NULL,
103 `c95` varchar(30) DEFAULT NULL,
104 `c96` varchar(30) DEFAULT NULL,
105 `c97` varchar(30) DEFAULT NULL,
106 `c98` varchar(30) DEFAULT NULL,
107 `c99` varchar(30) DEFAULT NULL,
108 `c100` varchar(30) DEFAULT NULL,
109 `c101` varchar(30) DEFAULT NULL,
110 `c102` varchar(30) DEFAULT NULL,
111 `c103` varchar(30) DEFAULT NULL,
112 `c104` varchar(30) DEFAULT NULL,
113 `c105` varchar(30) DEFAULT NULL,
114 `c106` varchar(30) DEFAULT NULL,
115 `c107` varchar(30) DEFAULT NULL,
116 `c108` varchar(30) DEFAULT NULL,
117 `c109` varchar(30) DEFAULT NULL,
118 `c110` varchar(30) DEFAULT NULL,
119 `c111` varchar(30) DEFAULT NULL,
120 `c112` varchar(30) DEFAULT NULL,
121 `c113` varchar(30) DEFAULT NULL,
122 `c114` varchar(30) DEFAULT NULL,
123 `c115` varchar(30) DEFAULT NULL,
124 `c116` varchar(30) DEFAULT NULL,
125 `c117` varchar(30) DEFAULT NULL,
126 `c118` varchar(30) DEFAULT NULL,
127 `c119` varchar(30) DEFAULT NULL,
128 `c120` varchar(30) DEFAULT NULL,
129 `c121` varchar(30) DEFAULT NULL,
130 `c122` varchar(30) DEFAULT NULL,
131 `c123` varchar(30) DEFAULT NULL,
132 `c124` varchar(30) DEFAULT NULL,
133 `c125` varchar(30) DEFAULT NULL,
134 `c126` varchar(30) DEFAULT NULL,
135 `c127` varchar(30) DEFAULT NULL,
136 `c128` varchar(30) DEFAULT NULL,
137 `c129` varchar(30) DEFAULT NULL,
138 `c130` varchar(30) DEFAULT NULL,
139 `c131` varchar(30) DEFAULT NULL,
140 `c132` varchar(30) DEFAULT NULL,
141 `c133` varchar(30) DEFAULT NULL,
142 `c134` varchar(30) DEFAULT NULL,
143 `c135` varchar(30) DEFAULT NULL,
144 `c136` varchar(30) DEFAULT NULL,
145 `c137` varchar(30) DEFAULT NULL,
146 `c138` varchar(30) DEFAULT NULL,
147 `c139` varchar(30) DEFAULT NULL,
148 `c140` varchar(30) DEFAULT NULL,
149 `c141` varchar(30) DEFAULT NULL,
150 `c142` varchar(30) DEFAULT NULL,
151 `c143` varchar(30) DEFAULT NULL,
152 `c144` varchar(30) DEFAULT NULL,
153 `c145` varchar(30) DEFAULT NULL,
154 `c146` varchar(30) DEFAULT NULL,
155 PRIMARY KEY (`c1`)
156 ) ENGINE=InnoDB CHARACTER SET latin1;
157 LOCK TABLES `t1` WRITE;
158 INSERT INTO `t1`(c2) VALUES ('1');
159 FLUSH LOGS;
160 include/sync_slave_sql_with_master.inc
161 ### assertion: the slave replicated event successfully and tables match
162 include/diff_tables.inc [master:t1, slave:t1]
163 DROP TABLE `t1`;
164 include/sync_slave_sql_with_master.inc
165 === Using mysqlbinlog to detect failure. Before the patch mysqlbinlog would find a corrupted event, thence would fail.
166 include/rpl_reset.inc
167 ### action: generating several tables with different metadata
168 ### sizes (resorting to perl)
169 ### testing table with 249 field metadata size.
170 ### testing table with 250 field metadata size.
171 ### testing table with 251 field metadata size.
172 ### testing table with 252 field metadata size.
173 ### testing table with 253 field metadata size.
174 ### testing table with 254 field metadata size.
175 ### testing table with 255 field metadata size.
176 ### testing table with 256 field metadata size.
177 ### testing table with 257 field metadata size.
178 ### testing table with 258 field metadata size.
179 include/sync_slave_sql_with_master.inc
180 FLUSH LOGS;
181 ### assertion: the slave replicated event successfully and tables match for t10
182 include/diff_tables.inc [master:t10, slave:t10]
183 include/sync_slave_sql_with_master.inc
184 ### assertion: the slave replicated event successfully and tables match for t9
185 include/diff_tables.inc [master:t9, slave:t9]
186 include/sync_slave_sql_with_master.inc
187 ### assertion: the slave replicated event successfully and tables match for t8
188 include/diff_tables.inc [master:t8, slave:t8]
189 include/sync_slave_sql_with_master.inc
190 ### assertion: the slave replicated event successfully and tables match for t7
191 include/diff_tables.inc [master:t7, slave:t7]
192 include/sync_slave_sql_with_master.inc
193 ### assertion: the slave replicated event successfully and tables match for t6
194 include/diff_tables.inc [master:t6, slave:t6]
195 include/sync_slave_sql_with_master.inc
196 ### assertion: the slave replicated event successfully and tables match for t5
197 include/diff_tables.inc [master:t5, slave:t5]
198 include/sync_slave_sql_with_master.inc
199 ### assertion: the slave replicated event successfully and tables match for t4
200 include/diff_tables.inc [master:t4, slave:t4]
201 include/sync_slave_sql_with_master.inc
202 ### assertion: the slave replicated event successfully and tables match for t3
203 include/diff_tables.inc [master:t3, slave:t3]
204 include/sync_slave_sql_with_master.inc
205 ### assertion: the slave replicated event successfully and tables match for t2
206 include/diff_tables.inc [master:t2, slave:t2]
207 include/sync_slave_sql_with_master.inc
208 ### assertion: the slave replicated event successfully and tables match for t1
209 include/diff_tables.inc [master:t1, slave:t1]
210 include/sync_slave_sql_with_master.inc
211 ### assertion: check that binlog is not corrupt. Using mysqlbinlog to
212 ### detect failure. Before the patch mysqlbinlog would find
213 ### a corrupted event, thence would fail.
214 include/rpl_end.inc