Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_colSize.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 **** Testing WL#3228 changes. ****
7 *** Create "wider" table on slave ***
8 include/sync_slave_sql_with_master.inc
9 Checking MYSQL_TYPE_NEWDECIMAL fields
10 DROP TABLE IF EXISTS t1;
11 Warnings:
12 Note 1051 Unknown table 'test.t1'
13 STOP REPLICA;
14 CREATE TABLE t1 (a DECIMAL(5,2));
15 CREATE TABLE t1 (a DECIMAL(20, 10));
16 include/rpl_reset.inc
17 INSERT INTO t1 VALUES (901251.90125);
18 include/wait_for_slave_sql_error.inc [errno=13146]
19 SELECT COUNT(*) FROM t1;
20 COUNT(*)
21 0
22 STOP REPLICA;
23 include/rpl_reset.inc
24 DROP TABLE IF EXISTS t1;
25 STOP REPLICA;
26 CREATE TABLE t1 (a DECIMAL(27, 9));
27 CREATE TABLE t1 (a DECIMAL(27, 18));
28 include/rpl_reset.inc
29 INSERT INTO t1 VALUES (901251.90125);
30 include/wait_for_slave_sql_error.inc [errno=13146]
31 SELECT COUNT(*) FROM t1;
32 COUNT(*)
33 0
34 STOP REPLICA;
35 include/rpl_reset.inc
36 DROP TABLE IF EXISTS t1;
37 STOP REPLICA;
38 CREATE TABLE t1 (a NUMERIC(5,2));
39 CREATE TABLE t1 (a NUMERIC(20, 10));
40 include/rpl_reset.inc
41 INSERT INTO t1 VALUES (901251.90125);
42 include/wait_for_slave_sql_error.inc [errno=13146]
43 SELECT COUNT(*) FROM t1;
44 COUNT(*)
45 0
46 STOP REPLICA;
47 include/rpl_reset.inc
48 Checking MYSQL_TYPE_FLOAT fields
49 DROP TABLE IF EXISTS t1;
50 STOP REPLICA;
51 CREATE TABLE t1 (a FLOAT(20));
52 CREATE TABLE t1 (a FLOAT(47));
53 include/rpl_reset.inc
54 INSERT INTO t1 VALUES (901251.90125);
55 include/wait_for_slave_sql_error.inc [errno=13146]
56 SELECT COUNT(*) FROM t1;
57 COUNT(*)
58 0
59 STOP REPLICA;
60 include/rpl_reset.inc
61 Checking MYSQL_TYPE_BIT fields
62 DROP TABLE IF EXISTS t1;
63 STOP REPLICA;
64 CREATE TABLE t1 (a BIT(5));
65 CREATE TABLE t1 (a BIT(64));
66 include/rpl_reset.inc
67 INSERT INTO t1 VALUES (B'10101');
68 include/wait_for_slave_sql_error.inc [errno=13146]
69 SELECT COUNT(*) FROM t1;
70 COUNT(*)
71 0
72 STOP REPLICA;
73 include/rpl_reset.inc
74 DROP TABLE IF EXISTS t1;
75 STOP REPLICA;
76 CREATE TABLE t1 (a BIT(11));
77 CREATE TABLE t1 (a BIT(12));
78 include/rpl_reset.inc
79 INSERT INTO t1 VALUES (B'10101');
80 include/wait_for_slave_sql_error.inc [errno=13146]
81 SELECT COUNT(*) FROM t1;
82 COUNT(*)
83 0
84 STOP REPLICA;
85 include/rpl_reset.inc
86 Checking MYSQL_TYPE_SET fields
87 DROP TABLE IF EXISTS t1;
88 STOP REPLICA;
89 CREATE TABLE t1 (a SET('4'));
90 CREATE TABLE t1 (a SET('1','2','3','4','5','6','7','8','9'));
91 include/rpl_reset.inc
92 INSERT INTO t1 VALUES ('4');
93 include/wait_for_slave_sql_error.inc [errno=13146]
94 SELECT COUNT(*) FROM t1;
95 COUNT(*)
96 0
97 STOP REPLICA;
98 include/rpl_reset.inc
99 Checking MYSQL_TYPE_STRING fields
100 DROP TABLE IF EXISTS t1;
101 STOP REPLICA;
102 CREATE TABLE t1 (a CHAR(10));
103 CREATE TABLE t1 (a CHAR(20));
104 include/rpl_reset.inc
105 INSERT INTO t1 VALUES ('This is a test.');
106 include/wait_for_slave_sql_error.inc [errno=13146]
107 SELECT COUNT(*) FROM t1;
108 COUNT(*)
109 0
110 STOP REPLICA;
111 include/rpl_reset.inc
112 Checking MYSQL_TYPE_ENUM fields
113 DROP TABLE IF EXISTS t1;
114 STOP REPLICA;
115 CREATE TABLE t1 (a ENUM('44','54'));
116 CREATE TABLE t1 (a ENUM(
117 '01','02','03','04','05','06','07','08','09',
118 '11','12','13','14','15','16','17','18','19',
119 '21','22','23','24','25','26','27','28','29',
120 '31','32','33','34','35','36','37','38','39',
121 '41','42','43','44','45','46','47','48','49',
122 '51','52','53','54','55','56','57','58','59',
123 '61','62','63','64','65','66','67','68','69',
124 '71','72','73','74','75','76','77','78','79',
125 '81','82','83','84','85','86','87','88','89',
126 '91','92','93','94','95','96','97','98','99',
127 '101','102','103','104','105','106','107','108','109',
128 '111','112','113','114','115','116','117','118','119',
129 '121','122','123','124','125','126','127','128','129',
130 '131','132','133','134','135','136','137','138','139',
131 '141','142','143','144','145','146','147','148','149',
132 '151','152','153','154','155','156','157','158','159',
133 '161','162','163','164','165','166','167','168','169',
134 '171','172','173','174','175','176','177','178','179',
135 '181','182','183','184','185','186','187','188','189',
136 '191','192','193','194','195','196','197','198','199',
137 '201','202','203','204','205','206','207','208','209',
138 '211','212','213','214','215','216','217','218','219',
139 '221','222','223','224','225','226','227','228','229',
140 '231','232','233','234','235','236','237','238','239',
141 '241','242','243','244','245','246','247','248','249',
142 '251','252','253','254','255','256','257','258','259',
143 '261','262','263','264','265','266','267','268','269',
144 '271','272','273','274','275','276','277','278','279',
145 '281','282','283','284','285','286','287','288','289',
146 '291','292','293','294','295','296','297','298','299'
147 ));
148 include/rpl_reset.inc
149 INSERT INTO t1 VALUES ('44');
150 include/wait_for_slave_sql_error.inc [errno=13146]
151 SELECT COUNT(*) FROM t1;
152 COUNT(*)
153 0
154 STOP REPLICA;
155 include/rpl_reset.inc
156 Checking MYSQL_TYPE_VARCHAR fields
157 DROP TABLE IF EXISTS t1;
158 STOP REPLICA;
159 CREATE TABLE t1 (a VARCHAR(100));
160 CREATE TABLE t1 (a VARCHAR(2000));
161 include/rpl_reset.inc
162 INSERT INTO t1 VALUES ('This is a test.');
163 include/wait_for_slave_sql_error.inc [errno=13146]
164 SELECT COUNT(*) FROM t1;
165 COUNT(*)
166 0
167 STOP REPLICA;
168 include/rpl_reset.inc
169 DROP TABLE IF EXISTS t1;
170 STOP REPLICA;
171 CREATE TABLE t1 (a VARCHAR(10));
172 CREATE TABLE t1 (a VARCHAR(200));
173 include/rpl_reset.inc
174 INSERT INTO t1 VALUES ('This is a test.');
175 include/wait_for_slave_sql_error.inc [errno=13146]
176 SELECT COUNT(*) FROM t1;
177 COUNT(*)
178 0
179 STOP REPLICA;
180 include/rpl_reset.inc
181 DROP TABLE IF EXISTS t1;
182 STOP REPLICA;
183 CREATE TABLE t1 (a VARCHAR(1000));
184 CREATE TABLE t1 (a VARCHAR(2000));
185 include/rpl_reset.inc
186 INSERT INTO t1 VALUES ('This is a test.');
187 include/wait_for_slave_sql_error.inc [errno=13146]
188 SELECT COUNT(*) FROM t1;
189 COUNT(*)
190 0
191 STOP REPLICA;
192 include/rpl_reset.inc
193 Checking MYSQL_TYPE_BLOB fields
194 DROP TABLE IF EXISTS t1;
195 STOP REPLICA;
196 CREATE TABLE t1 (a TINYBLOB);
197 CREATE TABLE t1 (a LONGBLOB);
198 include/rpl_reset.inc
199 INSERT INTO t1 VALUES ('This is a test.');
200 include/wait_for_slave_sql_error.inc [errno=13146]
201 SELECT COUNT(*) FROM t1;
202 COUNT(*)
203 0
204 STOP REPLICA;
205 include/rpl_reset.inc
206 call mtr.add_suppression("Replica SQL.*Table definition on source and replica does not match: Column 0 ...e mismatch.* Error_code: MY-001535");
207 call mtr.add_suppression("Replica SQL.*Column 0 of table .test.t1. cannot be converted from type.* Error_code: MY-013146");
208 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
209 *** Cleanup ***
210 DROP TABLE IF EXISTS t1;
211 include/sync_slave_sql_with_master.inc
212 include/rpl_end.inc