Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4 connection slave;
5 set @saved_slave_type_conversions = @@global.slave_type_conversions;
6 CREATE TABLE type_conversions (
7 TestNo INT AUTO_INCREMENT PRIMARY KEY,
8 Source TEXT,
9 Target TEXT,
10 Flags TEXT,
11 On_Master LONGTEXT,
12 On_Slave LONGTEXT,
13 Expected LONGTEXT,
14 Compare INT,
15 Error INT2);
16 SELECT @@global.slave_type_conversions;
17 @@global.slave_type_conversions
18
19 SET GLOBAL SLAVE_TYPE_CONVERSIONS='';
20 SELECT @@global.slave_type_conversions;
21 @@global.slave_type_conversions
22
23 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY';
24 SELECT @@global.slave_type_conversions;
25 @@global.slave_type_conversions
26 ALL_NON_LOSSY
27 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY';
28 SELECT @@global.slave_type_conversions;
29 @@global.slave_type_conversions
30 ALL_LOSSY
31 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY';
32 SELECT @@global.slave_type_conversions;
33 @@global.slave_type_conversions
34 ALL_LOSSY,ALL_NON_LOSSY
35 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY,NONEXISTING_BIT';
36 ERROR 42000: Variable 'slave_type_conversions' can't be set to the value of 'NONEXISTING_BIT'
37 SELECT @@global.slave_type_conversions;
38 @@global.slave_type_conversions
39 ALL_LOSSY,ALL_NON_LOSSY
40 connection slave;
41 SET GLOBAL SLAVE_TYPE_CONVERSIONS='';
42 **** Running tests with @@SLAVE_TYPE_CONVERSIONS = '' ****
43 #
44 # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work
45 #
46 # End of MDEV-15821
47 #
48 # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values
49 #
50 # End of MDEV-15833
51 #
52 # MDEV-17098 DATE <-> DATETIME
53 #
54 # End of MDEV-17098
55 include/rpl_reset.inc
56 connection slave;
57 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY';
58 **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' ****
59 #
60 # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work
61 #
62 # End of MDEV-15821
63 #
64 # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values
65 #
66 # End of MDEV-15833
67 #
68 # MDEV-17098 DATE <-> DATETIME
69 #
70 # End of MDEV-17098
71 include/rpl_reset.inc
72 connection slave;
73 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY';
74 **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' ****
75 #
76 # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work
77 #
78 # End of MDEV-15821
79 #
80 # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values
81 #
82 # End of MDEV-15833
83 #
84 # MDEV-17098 DATE <-> DATETIME
85 #
86 # End of MDEV-17098
87 include/rpl_reset.inc
88 connection slave;
89 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY';
90 **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' ****
91 #
92 # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work
93 #
94 # End of MDEV-15821
95 #
96 # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values
97 #
98 # End of MDEV-15833
99 #
100 # MDEV-17098 DATE <-> DATETIME
101 #
102 # End of MDEV-17098
103 include/rpl_reset.inc
104 connection slave;
105 **** Result of conversions ****
106 Source_Type Target_Type All_Type_Conversion_Flags Value_On_Slave
107 TINYBLOB TINYBLOB <Correct value>
108 TINYBLOB BLOB <Correct error>
109 TINYBLOB MEDIUMBLOB <Correct error>
110 TINYBLOB LONGBLOB <Correct error>
111 BLOB TINYBLOB <Correct error>
112 BLOB BLOB <Correct value>
113 BLOB MEDIUMBLOB <Correct error>
114 BLOB LONGBLOB <Correct error>
115 MEDIUMBLOB TINYBLOB <Correct error>
116 MEDIUMBLOB BLOB <Correct error>
117 MEDIUMBLOB MEDIUMBLOB <Correct value>
118 MEDIUMBLOB LONGBLOB <Correct error>
119 LONGBLOB TINYBLOB <Correct error>
120 LONGBLOB BLOB <Correct error>
121 LONGBLOB MEDIUMBLOB <Correct error>
122 LONGBLOB LONGBLOB <Correct value>
123 GEOMETRY BLOB <Correct error>
124 BLOB GEOMETRY <Correct error>
125 GEOMETRY GEOMETRY <Correct value>
126 BIT(1) BIT(1) <Correct value>
127 DATE DATE <Correct value>
128 ENUM('master',' ENUM('master',' <Correct value>
129 CHAR(10) ENUM('master',' <Correct error>
130 CHAR(10) SET('master','s <Correct error>
131 ENUM('master',' CHAR(10) <Correct error>
132 SET('master','s CHAR(10) <Correct error>
133 SET('master','s SET('master','s <Correct value>
134 SET('master','s SET('master','s <Correct value>
135 SET('0','1','2' SET('0','1','2' <Correct value>
136 SET('0','1','2' SET('0','1','2' <Correct error>
137 SET('0','1','2' SET('0','1','2' <Correct error>
138 SET('0','1','2' SET('0','1','2' <Correct error>
139 TINYINT TINYINT <Correct value>
140 TINYINT SMALLINT <Correct error>
141 TINYINT MEDIUMINT <Correct error>
142 TINYINT INT <Correct error>
143 TINYINT BIGINT <Correct error>
144 SMALLINT TINYINT <Correct error>
145 SMALLINT TINYINT <Correct error>
146 SMALLINT TINYINT UNSIGNE <Correct error>
147 SMALLINT SMALLINT <Correct value>
148 SMALLINT MEDIUMINT <Correct error>
149 SMALLINT INT <Correct error>
150 SMALLINT BIGINT <Correct error>
151 MEDIUMINT TINYINT <Correct error>
152 MEDIUMINT TINYINT <Correct error>
153 MEDIUMINT TINYINT UNSIGNE <Correct error>
154 MEDIUMINT SMALLINT <Correct error>
155 MEDIUMINT MEDIUMINT <Correct value>
156 MEDIUMINT INT <Correct error>
157 MEDIUMINT BIGINT <Correct error>
158 INT TINYINT <Correct error>
159 INT TINYINT <Correct error>
160 INT TINYINT UNSIGNE <Correct error>
161 INT SMALLINT <Correct error>
162 INT MEDIUMINT <Correct error>
163 INT INT <Correct value>
164 INT BIGINT <Correct error>
165 BIGINT TINYINT <Correct error>
166 BIGINT SMALLINT <Correct error>
167 BIGINT MEDIUMINT <Correct error>
168 BIGINT INT <Correct error>
169 BIGINT BIGINT <Correct value>
170 CHAR(20) CHAR(20) <Correct value>
171 CHAR(20) CHAR(30) <Correct error>
172 CHAR(20) CHAR(10) <Correct error>
173 CHAR(20) VARCHAR(20) <Correct error>
174 CHAR(20) VARCHAR(30) <Correct error>
175 CHAR(20) VARCHAR(10) <Correct error>
176 CHAR(20) TINYTEXT <Correct error>
177 CHAR(20) TEXT <Correct error>
178 CHAR(20) MEDIUMTEXT <Correct error>
179 CHAR(20) LONGTEXT <Correct error>
180 VARCHAR(20) VARCHAR(20) <Correct value>
181 VARCHAR(20) VARCHAR(30) <Correct error>
182 VARCHAR(20) VARCHAR(10) <Correct error>
183 VARCHAR(20) CHAR(30) <Correct error>
184 VARCHAR(20) CHAR(10) <Correct error>
185 VARCHAR(20) TINYTEXT <Correct error>
186 VARCHAR(20) TEXT <Correct error>
187 VARCHAR(20) MEDIUMTEXT <Correct error>
188 VARCHAR(20) LONGTEXT <Correct error>
189 VARCHAR(500) VARCHAR(500) <Correct value>
190 VARCHAR(500) VARCHAR(510) <Correct error>
191 VARCHAR(500) VARCHAR(255) <Correct error>
192 VARCHAR(500) TINYTEXT <Correct error>
193 VARCHAR(500) TEXT <Correct error>
194 VARCHAR(500) MEDIUMTEXT <Correct error>
195 VARCHAR(500) LONGTEXT <Correct error>
196 TINYTEXT VARCHAR(500) <Correct error>
197 TEXT VARCHAR(500) <Correct error>
198 MEDIUMTEXT VARCHAR(500) <Correct error>
199 LONGTEXT VARCHAR(500) <Correct error>
200 TINYTEXT CHAR(255) <Correct error>
201 TINYTEXT CHAR(250) <Correct error>
202 TEXT CHAR(255) <Correct error>
203 MEDIUMTEXT CHAR(255) <Correct error>
204 LONGTEXT CHAR(255) <Correct error>
205 TINYTEXT TINYTEXT <Correct value>
206 TINYTEXT TEXT <Correct error>
207 TEXT TINYTEXT <Correct error>
208 DECIMAL(10,5) DECIMAL(10,5) <Correct value>
209 DECIMAL(10,5) DECIMAL(10,6) <Correct error>
210 DECIMAL(10,5) DECIMAL(11,5) <Correct error>
211 DECIMAL(10,5) DECIMAL(11,6) <Correct error>
212 DECIMAL(10,5) DECIMAL(10,4) <Correct error>
213 DECIMAL(10,5) DECIMAL(9,5) <Correct error>
214 DECIMAL(10,5) DECIMAL(9,4) <Correct error>
215 FLOAT DECIMAL(10,5) <Correct error>
216 DOUBLE DECIMAL(10,5) <Correct error>
217 DECIMAL(10,5) FLOAT <Correct error>
218 DECIMAL(10,5) DOUBLE <Correct error>
219 FLOAT FLOAT <Correct value>
220 DOUBLE DOUBLE <Correct value>
221 FLOAT DOUBLE <Correct error>
222 DOUBLE FLOAT <Correct error>
223 BIT(5) BIT(5) <Correct value>
224 BIT(5) BIT(6) <Correct error>
225 BIT(6) BIT(5) <Correct error>
226 BIT(5) BIT(12) <Correct error>
227 BIT(12) BIT(5) <Correct error>
228 TINYBLOB COMPRE TINYBLOB <Correct error>
229 TINYBLOB COMPRE BLOB <Correct error>
230 TINYBLOB COMPRE MEDIUMBLOB <Correct error>
231 TINYBLOB COMPRE LONGBLOB <Correct error>
232 TINYBLOB COMPRE VARBINARY(255) <Correct error>
233 BLOB COMPRESSED TINYBLOB <Correct error>
234 BLOB COMPRESSED BLOB <Correct error>
235 BLOB COMPRESSED MEDIUMBLOB <Correct error>
236 BLOB COMPRESSED LONGBLOB <Correct error>
237 BLOB COMPRESSED VARBINARY(65500 <Correct error>
238 MEDIUMBLOB COMP TINYBLOB <Correct error>
239 MEDIUMBLOB COMP BLOB <Correct error>
240 MEDIUMBLOB COMP MEDIUMBLOB <Correct error>
241 MEDIUMBLOB COMP LONGBLOB <Correct error>
242 MEDIUMBLOB COMP VARBINARY(65500 <Correct error>
243 LONGBLOB COMPRE TINYBLOB <Correct error>
244 LONGBLOB COMPRE BLOB <Correct error>
245 LONGBLOB COMPRE MEDIUMBLOB <Correct error>
246 LONGBLOB COMPRE LONGBLOB <Correct error>
247 LONGBLOB COMPRE VARBINARY(65500 <Correct error>
248 TINYBLOB BLOB <Correct error>
249 TINYBLOB MEDIUMBLOB <Correct error>
250 TINYBLOB LONGBLOB <Correct error>
251 TINYBLOB VARBINARY(255) <Correct error>
252 BLOB TINYBLOB <Correct error>
253 BLOB MEDIUMBLOB <Correct error>
254 BLOB LONGBLOB <Correct error>
255 BLOB VARBINARY(65500 <Correct error>
256 MEDIUMBLOB TINYBLOB <Correct error>
257 MEDIUMBLOB BLOB <Correct error>
258 MEDIUMBLOB LONGBLOB <Correct error>
259 MEDIUMBLOB VARBINARY(65500 <Correct error>
260 LONGBLOB TINYBLOB <Correct error>
261 LONGBLOB BLOB <Correct error>
262 LONGBLOB MEDIUMBLOB <Correct error>
263 LONGBLOB VARBINARY(65500 <Correct error>
264 DATE DATETIME(6) <Correct error>
265 DATE DATETIME(6) <Correct error>
266 DATE DATETIME(6) <Correct error>
267 DATE DATETIME(0) <Correct error>
268 DATETIME(6) DATE <Correct error>
269 DATETIME(6) DATE <Correct error>
270 DATETIME(0) DATE <Correct error>
271 TINYBLOB TINYBLOB ALL_NON_LOSSY <Correct value>
272 TINYBLOB BLOB ALL_NON_LOSSY <Correct value>
273 TINYBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value>
274 TINYBLOB LONGBLOB ALL_NON_LOSSY <Correct value>
275 BLOB TINYBLOB ALL_NON_LOSSY <Correct error>
276 BLOB BLOB ALL_NON_LOSSY <Correct value>
277 BLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value>
278 BLOB LONGBLOB ALL_NON_LOSSY <Correct value>
279 MEDIUMBLOB TINYBLOB ALL_NON_LOSSY <Correct error>
280 MEDIUMBLOB BLOB ALL_NON_LOSSY <Correct error>
281 MEDIUMBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value>
282 MEDIUMBLOB LONGBLOB ALL_NON_LOSSY <Correct value>
283 LONGBLOB TINYBLOB ALL_NON_LOSSY <Correct error>
284 LONGBLOB BLOB ALL_NON_LOSSY <Correct error>
285 LONGBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct error>
286 LONGBLOB LONGBLOB ALL_NON_LOSSY <Correct value>
287 GEOMETRY BLOB ALL_NON_LOSSY <Correct error>
288 BLOB GEOMETRY ALL_NON_LOSSY <Correct error>
289 GEOMETRY GEOMETRY ALL_NON_LOSSY <Correct value>
290 BIT(1) BIT(1) ALL_NON_LOSSY <Correct value>
291 DATE DATE ALL_NON_LOSSY <Correct value>
292 ENUM('master',' ENUM('master',' ALL_NON_LOSSY <Correct value>
293 CHAR(10) ENUM('master',' ALL_NON_LOSSY <Correct error>
294 CHAR(10) SET('master','s ALL_NON_LOSSY <Correct error>
295 ENUM('master',' CHAR(10) ALL_NON_LOSSY <Correct error>
296 SET('master','s CHAR(10) ALL_NON_LOSSY <Correct error>
297 SET('master','s SET('master','s ALL_NON_LOSSY <Correct value>
298 SET('master','s SET('master','s ALL_NON_LOSSY <Correct value>
299 SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct value>
300 SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct value>
301 SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct error>
302 SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct error>
303 TINYINT TINYINT ALL_NON_LOSSY <Correct value>
304 TINYINT SMALLINT ALL_NON_LOSSY <Correct value>
305 TINYINT MEDIUMINT ALL_NON_LOSSY <Correct value>
306 TINYINT INT ALL_NON_LOSSY <Correct value>
307 TINYINT BIGINT ALL_NON_LOSSY <Correct value>
308 SMALLINT TINYINT ALL_NON_LOSSY <Correct error>
309 SMALLINT TINYINT ALL_NON_LOSSY <Correct error>
310 SMALLINT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error>
311 SMALLINT SMALLINT ALL_NON_LOSSY <Correct value>
312 SMALLINT MEDIUMINT ALL_NON_LOSSY <Correct value>
313 SMALLINT INT ALL_NON_LOSSY <Correct value>
314 SMALLINT BIGINT ALL_NON_LOSSY <Correct value>
315 MEDIUMINT TINYINT ALL_NON_LOSSY <Correct error>
316 MEDIUMINT TINYINT ALL_NON_LOSSY <Correct error>
317 MEDIUMINT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error>
318 MEDIUMINT SMALLINT ALL_NON_LOSSY <Correct error>
319 MEDIUMINT MEDIUMINT ALL_NON_LOSSY <Correct value>
320 MEDIUMINT INT ALL_NON_LOSSY <Correct value>
321 MEDIUMINT BIGINT ALL_NON_LOSSY <Correct value>
322 INT TINYINT ALL_NON_LOSSY <Correct error>
323 INT TINYINT ALL_NON_LOSSY <Correct error>
324 INT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error>
325 INT SMALLINT ALL_NON_LOSSY <Correct error>
326 INT MEDIUMINT ALL_NON_LOSSY <Correct error>
327 INT INT ALL_NON_LOSSY <Correct value>
328 INT BIGINT ALL_NON_LOSSY <Correct value>
329 BIGINT TINYINT ALL_NON_LOSSY <Correct error>
330 BIGINT SMALLINT ALL_NON_LOSSY <Correct error>
331 BIGINT MEDIUMINT ALL_NON_LOSSY <Correct error>
332 BIGINT INT ALL_NON_LOSSY <Correct error>
333 BIGINT BIGINT ALL_NON_LOSSY <Correct value>
334 CHAR(20) CHAR(20) ALL_NON_LOSSY <Correct value>
335 CHAR(20) CHAR(30) ALL_NON_LOSSY <Correct value>
336 CHAR(20) CHAR(10) ALL_NON_LOSSY <Correct error>
337 CHAR(20) VARCHAR(20) ALL_NON_LOSSY <Correct value>
338 CHAR(20) VARCHAR(30) ALL_NON_LOSSY <Correct value>
339 CHAR(20) VARCHAR(10) ALL_NON_LOSSY <Correct error>
340 CHAR(20) TINYTEXT ALL_NON_LOSSY <Correct value>
341 CHAR(20) TEXT ALL_NON_LOSSY <Correct value>
342 CHAR(20) MEDIUMTEXT ALL_NON_LOSSY <Correct value>
343 CHAR(20) LONGTEXT ALL_NON_LOSSY <Correct value>
344 VARCHAR(20) VARCHAR(20) ALL_NON_LOSSY <Correct value>
345 VARCHAR(20) VARCHAR(30) ALL_NON_LOSSY <Correct value>
346 VARCHAR(20) VARCHAR(10) ALL_NON_LOSSY <Correct error>
347 VARCHAR(20) CHAR(30) ALL_NON_LOSSY <Correct value>
348 VARCHAR(20) CHAR(10) ALL_NON_LOSSY <Correct error>
349 VARCHAR(20) TINYTEXT ALL_NON_LOSSY <Correct value>
350 VARCHAR(20) TEXT ALL_NON_LOSSY <Correct value>
351 VARCHAR(20) MEDIUMTEXT ALL_NON_LOSSY <Correct value>
352 VARCHAR(20) LONGTEXT ALL_NON_LOSSY <Correct value>
353 VARCHAR(500) VARCHAR(500) ALL_NON_LOSSY <Correct value>
354 VARCHAR(500) VARCHAR(510) ALL_NON_LOSSY <Correct value>
355 VARCHAR(500) VARCHAR(255) ALL_NON_LOSSY <Correct error>
356 VARCHAR(500) TINYTEXT ALL_NON_LOSSY <Correct error>
357 VARCHAR(500) TEXT ALL_NON_LOSSY <Correct value>
358 VARCHAR(500) MEDIUMTEXT ALL_NON_LOSSY <Correct value>
359 VARCHAR(500) LONGTEXT ALL_NON_LOSSY <Correct value>
360 TINYTEXT VARCHAR(500) ALL_NON_LOSSY <Correct value>
361 TEXT VARCHAR(500) ALL_NON_LOSSY <Correct error>
362 MEDIUMTEXT VARCHAR(500) ALL_NON_LOSSY <Correct error>
363 LONGTEXT VARCHAR(500) ALL_NON_LOSSY <Correct error>
364 TINYTEXT CHAR(255) ALL_NON_LOSSY <Correct value>
365 TINYTEXT CHAR(250) ALL_NON_LOSSY <Correct error>
366 TEXT CHAR(255) ALL_NON_LOSSY <Correct error>
367 MEDIUMTEXT CHAR(255) ALL_NON_LOSSY <Correct error>
368 LONGTEXT CHAR(255) ALL_NON_LOSSY <Correct error>
369 TINYTEXT TINYTEXT ALL_NON_LOSSY <Correct value>
370 TINYTEXT TEXT ALL_NON_LOSSY <Correct value>
371 TEXT TINYTEXT ALL_NON_LOSSY <Correct error>
372 DECIMAL(10,5) DECIMAL(10,5) ALL_NON_LOSSY <Correct value>
373 DECIMAL(10,5) DECIMAL(10,6) ALL_NON_LOSSY <Correct value>
374 DECIMAL(10,5) DECIMAL(11,5) ALL_NON_LOSSY <Correct value>
375 DECIMAL(10,5) DECIMAL(11,6) ALL_NON_LOSSY <Correct value>
376 DECIMAL(10,5) DECIMAL(10,4) ALL_NON_LOSSY <Correct error>
377 DECIMAL(10,5) DECIMAL(9,5) ALL_NON_LOSSY <Correct error>
378 DECIMAL(10,5) DECIMAL(9,4) ALL_NON_LOSSY <Correct error>
379 FLOAT DECIMAL(10,5) ALL_NON_LOSSY <Correct error>
380 DOUBLE DECIMAL(10,5) ALL_NON_LOSSY <Correct error>
381 DECIMAL(10,5) FLOAT ALL_NON_LOSSY <Correct error>
382 DECIMAL(10,5) DOUBLE ALL_NON_LOSSY <Correct error>
383 FLOAT FLOAT ALL_NON_LOSSY <Correct value>
384 DOUBLE DOUBLE ALL_NON_LOSSY <Correct value>
385 FLOAT DOUBLE ALL_NON_LOSSY <Correct value>
386 DOUBLE FLOAT ALL_NON_LOSSY <Correct error>
387 BIT(5) BIT(5) ALL_NON_LOSSY <Correct value>
388 BIT(5) BIT(6) ALL_NON_LOSSY <Correct value>
389 BIT(6) BIT(5) ALL_NON_LOSSY <Correct error>
390 BIT(5) BIT(12) ALL_NON_LOSSY <Correct value>
391 BIT(12) BIT(5) ALL_NON_LOSSY <Correct error>
392 TINYBLOB COMPRE TINYBLOB ALL_NON_LOSSY <Correct value>
393 TINYBLOB COMPRE BLOB ALL_NON_LOSSY <Correct value>
394 TINYBLOB COMPRE MEDIUMBLOB ALL_NON_LOSSY <Correct value>
395 TINYBLOB COMPRE LONGBLOB ALL_NON_LOSSY <Correct value>
396 TINYBLOB COMPRE VARBINARY(255) ALL_NON_LOSSY <Correct value>
397 BLOB COMPRESSED TINYBLOB ALL_NON_LOSSY <Correct error>
398 BLOB COMPRESSED BLOB ALL_NON_LOSSY <Correct value>
399 BLOB COMPRESSED MEDIUMBLOB ALL_NON_LOSSY <Correct value>
400 BLOB COMPRESSED LONGBLOB ALL_NON_LOSSY <Correct value>
401 BLOB COMPRESSED VARBINARY(65500 ALL_NON_LOSSY <Correct error>
402 MEDIUMBLOB COMP TINYBLOB ALL_NON_LOSSY <Correct error>
403 MEDIUMBLOB COMP BLOB ALL_NON_LOSSY <Correct error>
404 MEDIUMBLOB COMP MEDIUMBLOB ALL_NON_LOSSY <Correct value>
405 MEDIUMBLOB COMP LONGBLOB ALL_NON_LOSSY <Correct value>
406 MEDIUMBLOB COMP VARBINARY(65500 ALL_NON_LOSSY <Correct error>
407 LONGBLOB COMPRE TINYBLOB ALL_NON_LOSSY <Correct error>
408 LONGBLOB COMPRE BLOB ALL_NON_LOSSY <Correct error>
409 LONGBLOB COMPRE MEDIUMBLOB ALL_NON_LOSSY <Correct error>
410 LONGBLOB COMPRE LONGBLOB ALL_NON_LOSSY <Correct value>
411 LONGBLOB COMPRE VARBINARY(65500 ALL_NON_LOSSY <Correct error>
412 TINYBLOB BLOB ALL_NON_LOSSY <Correct value>
413 TINYBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value>
414 TINYBLOB LONGBLOB ALL_NON_LOSSY <Correct value>
415 TINYBLOB VARBINARY(255) ALL_NON_LOSSY <Correct value>
416 BLOB TINYBLOB ALL_NON_LOSSY <Correct error>
417 BLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value>
418 BLOB LONGBLOB ALL_NON_LOSSY <Correct value>
419 BLOB VARBINARY(65500 ALL_NON_LOSSY <Correct error>
420 MEDIUMBLOB TINYBLOB ALL_NON_LOSSY <Correct error>
421 MEDIUMBLOB BLOB ALL_NON_LOSSY <Correct error>
422 MEDIUMBLOB LONGBLOB ALL_NON_LOSSY <Correct value>
423 MEDIUMBLOB VARBINARY(65500 ALL_NON_LOSSY <Correct error>
424 LONGBLOB TINYBLOB ALL_NON_LOSSY <Correct error>
425 LONGBLOB BLOB ALL_NON_LOSSY <Correct error>
426 LONGBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct error>
427 LONGBLOB VARBINARY(65500 ALL_NON_LOSSY <Correct error>
428 DATE DATETIME(6) ALL_NON_LOSSY <Correct value>
429 DATE DATETIME(6) ALL_NON_LOSSY <Correct value>
430 DATE DATETIME(6) ALL_NON_LOSSY <Correct value>
431 DATE DATETIME(0) ALL_NON_LOSSY <Correct value>
432 DATETIME(6) DATE ALL_NON_LOSSY <Correct error>
433 DATETIME(6) DATE ALL_NON_LOSSY <Correct error>
434 DATETIME(0) DATE ALL_NON_LOSSY <Correct error>
435 TINYBLOB TINYBLOB ALL_LOSSY <Correct value>
436 TINYBLOB BLOB ALL_LOSSY <Correct error>
437 TINYBLOB MEDIUMBLOB ALL_LOSSY <Correct error>
438 TINYBLOB LONGBLOB ALL_LOSSY <Correct error>
439 BLOB TINYBLOB ALL_LOSSY <Correct value>
440 BLOB BLOB ALL_LOSSY <Correct value>
441 BLOB MEDIUMBLOB ALL_LOSSY <Correct error>
442 BLOB LONGBLOB ALL_LOSSY <Correct error>
443 MEDIUMBLOB TINYBLOB ALL_LOSSY <Correct value>
444 MEDIUMBLOB BLOB ALL_LOSSY <Correct value>
445 MEDIUMBLOB MEDIUMBLOB ALL_LOSSY <Correct value>
446 MEDIUMBLOB LONGBLOB ALL_LOSSY <Correct error>
447 LONGBLOB TINYBLOB ALL_LOSSY <Correct value>
448 LONGBLOB BLOB ALL_LOSSY <Correct value>
449 LONGBLOB MEDIUMBLOB ALL_LOSSY <Correct value>
450 LONGBLOB LONGBLOB ALL_LOSSY <Correct value>
451 GEOMETRY BLOB ALL_LOSSY <Correct error>
452 BLOB GEOMETRY ALL_LOSSY <Correct error>
453 GEOMETRY GEOMETRY ALL_LOSSY <Correct value>
454 BIT(1) BIT(1) ALL_LOSSY <Correct value>
455 DATE DATE ALL_LOSSY <Correct value>
456 ENUM('master',' ENUM('master',' ALL_LOSSY <Correct value>
457 CHAR(10) ENUM('master',' ALL_LOSSY <Correct error>
458 CHAR(10) SET('master','s ALL_LOSSY <Correct error>
459 ENUM('master',' CHAR(10) ALL_LOSSY <Correct error>
460 SET('master','s CHAR(10) ALL_LOSSY <Correct error>
461 SET('master','s SET('master','s ALL_LOSSY <Correct value>
462 SET('master','s SET('master','s ALL_LOSSY <Correct value>
463 SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value>
464 SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct error>
465 SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value>
466 SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value>
467 TINYINT TINYINT ALL_LOSSY <Correct value>
468 TINYINT SMALLINT ALL_LOSSY <Correct error>
469 TINYINT MEDIUMINT ALL_LOSSY <Correct error>
470 TINYINT INT ALL_LOSSY <Correct error>
471 TINYINT BIGINT ALL_LOSSY <Correct error>
472 SMALLINT TINYINT ALL_LOSSY <Correct value>
473 SMALLINT TINYINT ALL_LOSSY <Correct value>
474 SMALLINT TINYINT UNSIGNE ALL_LOSSY <Correct value>
475 SMALLINT SMALLINT ALL_LOSSY <Correct value>
476 SMALLINT MEDIUMINT ALL_LOSSY <Correct error>
477 SMALLINT INT ALL_LOSSY <Correct error>
478 SMALLINT BIGINT ALL_LOSSY <Correct error>
479 MEDIUMINT TINYINT ALL_LOSSY <Correct value>
480 MEDIUMINT TINYINT ALL_LOSSY <Correct value>
481 MEDIUMINT TINYINT UNSIGNE ALL_LOSSY <Correct value>
482 MEDIUMINT SMALLINT ALL_LOSSY <Correct value>
483 MEDIUMINT MEDIUMINT ALL_LOSSY <Correct value>
484 MEDIUMINT INT ALL_LOSSY <Correct error>
485 MEDIUMINT BIGINT ALL_LOSSY <Correct error>
486 INT TINYINT ALL_LOSSY <Correct value>
487 INT TINYINT ALL_LOSSY <Correct value>
488 INT TINYINT UNSIGNE ALL_LOSSY <Correct value>
489 INT SMALLINT ALL_LOSSY <Correct value>
490 INT MEDIUMINT ALL_LOSSY <Correct value>
491 INT INT ALL_LOSSY <Correct value>
492 INT BIGINT ALL_LOSSY <Correct error>
493 BIGINT TINYINT ALL_LOSSY <Correct value>
494 BIGINT SMALLINT ALL_LOSSY <Correct value>
495 BIGINT MEDIUMINT ALL_LOSSY <Correct value>
496 BIGINT INT ALL_LOSSY <Correct value>
497 BIGINT BIGINT ALL_LOSSY <Correct value>
498 CHAR(20) CHAR(20) ALL_LOSSY <Correct value>
499 CHAR(20) CHAR(30) ALL_LOSSY <Correct error>
500 CHAR(20) CHAR(10) ALL_LOSSY <Correct value>
501 CHAR(20) VARCHAR(20) ALL_LOSSY <Correct error>
502 CHAR(20) VARCHAR(30) ALL_LOSSY <Correct error>
503 CHAR(20) VARCHAR(10) ALL_LOSSY <Correct value>
504 CHAR(20) TINYTEXT ALL_LOSSY <Correct error>
505 CHAR(20) TEXT ALL_LOSSY <Correct error>
506 CHAR(20) MEDIUMTEXT ALL_LOSSY <Correct error>
507 CHAR(20) LONGTEXT ALL_LOSSY <Correct error>
508 VARCHAR(20) VARCHAR(20) ALL_LOSSY <Correct value>
509 VARCHAR(20) VARCHAR(30) ALL_LOSSY <Correct error>
510 VARCHAR(20) VARCHAR(10) ALL_LOSSY <Correct value>
511 VARCHAR(20) CHAR(30) ALL_LOSSY <Correct error>
512 VARCHAR(20) CHAR(10) ALL_LOSSY <Correct value>
513 VARCHAR(20) TINYTEXT ALL_LOSSY <Correct error>
514 VARCHAR(20) TEXT ALL_LOSSY <Correct error>
515 VARCHAR(20) MEDIUMTEXT ALL_LOSSY <Correct error>
516 VARCHAR(20) LONGTEXT ALL_LOSSY <Correct error>
517 VARCHAR(500) VARCHAR(500) ALL_LOSSY <Correct value>
518 VARCHAR(500) VARCHAR(510) ALL_LOSSY <Correct error>
519 VARCHAR(500) VARCHAR(255) ALL_LOSSY <Correct value>
520 VARCHAR(500) TINYTEXT ALL_LOSSY <Correct value>
521 VARCHAR(500) TEXT ALL_LOSSY <Correct error>
522 VARCHAR(500) MEDIUMTEXT ALL_LOSSY <Correct error>
523 VARCHAR(500) LONGTEXT ALL_LOSSY <Correct error>
524 TINYTEXT VARCHAR(500) ALL_LOSSY <Correct error>
525 TEXT VARCHAR(500) ALL_LOSSY <Correct value>
526 MEDIUMTEXT VARCHAR(500) ALL_LOSSY <Correct value>
527 LONGTEXT VARCHAR(500) ALL_LOSSY <Correct value>
528 TINYTEXT CHAR(255) ALL_LOSSY <Correct error>
529 TINYTEXT CHAR(250) ALL_LOSSY <Correct value>
530 TEXT CHAR(255) ALL_LOSSY <Correct value>
531 MEDIUMTEXT CHAR(255) ALL_LOSSY <Correct value>
532 LONGTEXT CHAR(255) ALL_LOSSY <Correct value>
533 TINYTEXT TINYTEXT ALL_LOSSY <Correct value>
534 TINYTEXT TEXT ALL_LOSSY <Correct error>
535 TEXT TINYTEXT ALL_LOSSY <Correct value>
536 DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY <Correct value>
537 DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY <Correct error>
538 DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY <Correct error>
539 DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY <Correct error>
540 DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY <Correct value>
541 DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY <Correct value>
542 DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY <Correct value>
543 FLOAT DECIMAL(10,5) ALL_LOSSY <Correct value>
544 DOUBLE DECIMAL(10,5) ALL_LOSSY <Correct value>
545 DECIMAL(10,5) FLOAT ALL_LOSSY <Correct value>
546 DECIMAL(10,5) DOUBLE ALL_LOSSY <Correct value>
547 FLOAT FLOAT ALL_LOSSY <Correct value>
548 DOUBLE DOUBLE ALL_LOSSY <Correct value>
549 FLOAT DOUBLE ALL_LOSSY <Correct error>
550 DOUBLE FLOAT ALL_LOSSY <Correct value>
551 BIT(5) BIT(5) ALL_LOSSY <Correct value>
552 BIT(5) BIT(6) ALL_LOSSY <Correct error>
553 BIT(6) BIT(5) ALL_LOSSY <Correct value>
554 BIT(5) BIT(12) ALL_LOSSY <Correct error>
555 BIT(12) BIT(5) ALL_LOSSY <Correct value>
556 TINYBLOB COMPRE TINYBLOB ALL_LOSSY <Correct error>
557 TINYBLOB COMPRE BLOB ALL_LOSSY <Correct error>
558 TINYBLOB COMPRE MEDIUMBLOB ALL_LOSSY <Correct error>
559 TINYBLOB COMPRE LONGBLOB ALL_LOSSY <Correct error>
560 TINYBLOB COMPRE VARBINARY(255) ALL_LOSSY <Correct error>
561 BLOB COMPRESSED TINYBLOB ALL_LOSSY <Correct value>
562 BLOB COMPRESSED BLOB ALL_LOSSY <Correct error>
563 BLOB COMPRESSED MEDIUMBLOB ALL_LOSSY <Correct error>
564 BLOB COMPRESSED LONGBLOB ALL_LOSSY <Correct error>
565 BLOB COMPRESSED VARBINARY(65500 ALL_LOSSY <Correct value>
566 MEDIUMBLOB COMP TINYBLOB ALL_LOSSY <Correct value>
567 MEDIUMBLOB COMP BLOB ALL_LOSSY <Correct value>
568 MEDIUMBLOB COMP MEDIUMBLOB ALL_LOSSY <Correct error>
569 MEDIUMBLOB COMP LONGBLOB ALL_LOSSY <Correct error>
570 MEDIUMBLOB COMP VARBINARY(65500 ALL_LOSSY <Correct value>
571 LONGBLOB COMPRE TINYBLOB ALL_LOSSY <Correct value>
572 LONGBLOB COMPRE BLOB ALL_LOSSY <Correct value>
573 LONGBLOB COMPRE MEDIUMBLOB ALL_LOSSY <Correct value>
574 LONGBLOB COMPRE LONGBLOB ALL_LOSSY <Correct error>
575 LONGBLOB COMPRE VARBINARY(65500 ALL_LOSSY <Correct value>
576 TINYBLOB BLOB ALL_LOSSY <Correct error>
577 TINYBLOB MEDIUMBLOB ALL_LOSSY <Correct error>
578 TINYBLOB LONGBLOB ALL_LOSSY <Correct error>
579 TINYBLOB VARBINARY(255) ALL_LOSSY <Correct error>
580 BLOB TINYBLOB ALL_LOSSY <Correct value>
581 BLOB MEDIUMBLOB ALL_LOSSY <Correct error>
582 BLOB LONGBLOB ALL_LOSSY <Correct error>
583 BLOB VARBINARY(65500 ALL_LOSSY <Correct value>
584 MEDIUMBLOB TINYBLOB ALL_LOSSY <Correct value>
585 MEDIUMBLOB BLOB ALL_LOSSY <Correct value>
586 MEDIUMBLOB LONGBLOB ALL_LOSSY <Correct error>
587 MEDIUMBLOB VARBINARY(65500 ALL_LOSSY <Correct value>
588 LONGBLOB TINYBLOB ALL_LOSSY <Correct value>
589 LONGBLOB BLOB ALL_LOSSY <Correct value>
590 LONGBLOB MEDIUMBLOB ALL_LOSSY <Correct value>
591 LONGBLOB VARBINARY(65500 ALL_LOSSY <Correct value>
592 DATE DATETIME(6) ALL_LOSSY <Correct error>
593 DATE DATETIME(6) ALL_LOSSY <Correct error>
594 DATE DATETIME(6) ALL_LOSSY <Correct error>
595 DATE DATETIME(0) ALL_LOSSY <Correct error>
596 DATETIME(6) DATE ALL_LOSSY <Correct value>
597 DATETIME(6) DATE ALL_LOSSY <Correct value>
598 DATETIME(0) DATE ALL_LOSSY <Correct value>
599 TINYBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
600 TINYBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
601 TINYBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
602 TINYBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
603 BLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
604 BLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
605 BLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
606 BLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
607 MEDIUMBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
608 MEDIUMBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
609 MEDIUMBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
610 MEDIUMBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
611 LONGBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
612 LONGBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
613 LONGBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
614 LONGBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
615 GEOMETRY BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct error>
616 BLOB GEOMETRY ALL_LOSSY,ALL_NON_LOSSY <Correct error>
617 GEOMETRY GEOMETRY ALL_LOSSY,ALL_NON_LOSSY <Correct value>
618 BIT(1) BIT(1) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
619 DATE DATE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
620 ENUM('master',' ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY <Correct value>
621 CHAR(10) ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY <Correct error>
622 CHAR(10) SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct error>
623 ENUM('master',' CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct error>
624 SET('master','s CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct error>
625 SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct value>
626 SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct value>
627 SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value>
628 SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value>
629 SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value>
630 SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value>
631 TINYINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
632 TINYINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
633 TINYINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
634 TINYINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
635 TINYINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
636 SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
637 SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
638 SMALLINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
639 SMALLINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
640 SMALLINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
641 SMALLINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
642 SMALLINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
643 MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
644 MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
645 MEDIUMINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
646 MEDIUMINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
647 MEDIUMINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
648 MEDIUMINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
649 MEDIUMINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
650 INT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
651 INT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
652 INT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
653 INT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
654 INT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
655 INT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
656 INT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
657 BIGINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
658 BIGINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
659 BIGINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
660 BIGINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
661 BIGINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
662 CHAR(20) CHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
663 CHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
664 CHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
665 CHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
666 CHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
667 CHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
668 CHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
669 CHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
670 CHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
671 CHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
672 VARCHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
673 VARCHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
674 VARCHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
675 VARCHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
676 VARCHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
677 VARCHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
678 VARCHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
679 VARCHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
680 VARCHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
681 VARCHAR(500) VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
682 VARCHAR(500) VARCHAR(510) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
683 VARCHAR(500) VARCHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
684 VARCHAR(500) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
685 VARCHAR(500) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
686 VARCHAR(500) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
687 VARCHAR(500) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
688 TINYTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
689 TEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
690 MEDIUMTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
691 LONGTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
692 TINYTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
693 TINYTEXT CHAR(250) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
694 TEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
695 MEDIUMTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
696 LONGTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
697 TINYTEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
698 TINYTEXT TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
699 TEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
700 DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
701 DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
702 DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
703 DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
704 DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
705 DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
706 DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
707 FLOAT DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
708 DOUBLE DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
709 DECIMAL(10,5) FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
710 DECIMAL(10,5) DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
711 FLOAT FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
712 DOUBLE DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
713 FLOAT DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
714 DOUBLE FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value>
715 BIT(5) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
716 BIT(5) BIT(6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
717 BIT(6) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
718 BIT(5) BIT(12) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
719 BIT(12) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
720 TINYBLOB COMPRE TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
721 TINYBLOB COMPRE BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
722 TINYBLOB COMPRE MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
723 TINYBLOB COMPRE LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
724 TINYBLOB COMPRE VARBINARY(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
725 BLOB COMPRESSED TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
726 BLOB COMPRESSED BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
727 BLOB COMPRESSED MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
728 BLOB COMPRESSED LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
729 BLOB COMPRESSED VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
730 MEDIUMBLOB COMP TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
731 MEDIUMBLOB COMP BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
732 MEDIUMBLOB COMP MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
733 MEDIUMBLOB COMP LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
734 MEDIUMBLOB COMP VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
735 LONGBLOB COMPRE TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
736 LONGBLOB COMPRE BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
737 LONGBLOB COMPRE MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
738 LONGBLOB COMPRE LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
739 LONGBLOB COMPRE VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
740 TINYBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
741 TINYBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
742 TINYBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
743 TINYBLOB VARBINARY(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
744 BLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
745 BLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
746 BLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
747 BLOB VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
748 MEDIUMBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
749 MEDIUMBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
750 MEDIUMBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
751 MEDIUMBLOB VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
752 LONGBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
753 LONGBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
754 LONGBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value>
755 LONGBLOB VARBINARY(65500 ALL_LOSSY,ALL_NON_LOSSY <Correct value>
756 DATE DATETIME(6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
757 DATE DATETIME(6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
758 DATE DATETIME(6) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
759 DATE DATETIME(0) ALL_LOSSY,ALL_NON_LOSSY <Correct value>
760 DATETIME(6) DATE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
761 DATETIME(6) DATE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
762 DATETIME(0) DATE ALL_LOSSY,ALL_NON_LOSSY <Correct value>
763 DROP TABLE type_conversions;
764 call mtr.add_suppression("Slave SQL.*Column 1 of table .test.t1. cannot be converted from type.* error.* 1677");
765 connection master;
766 DROP TABLE t1;
767 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
768 connection slave;
769 set global slave_type_conversions = @saved_slave_type_conversions;
770 include/rpl_end.inc