Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_column_zerofill.result

raw
1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
3 Warnings:
4 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
5 SHOW TABLES;
6 Tables_in_test
7 t4
8 SHOW CREATE TABLE t4;
9 Table Create Table
10 t4 CREATE TABLE `t4` (
11 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 DROP TABLE t4;
14 SHOW TABLES;
15 Tables_in_test
16 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
17 Warnings:
18 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
19 SHOW TABLES;
20 Tables_in_test
21 t4
22 SHOW CREATE TABLE t4;
23 Table Create Table
24 t4 CREATE TABLE `t4` (
25 `c1` smallint(5) unsigned zerofill DEFAULT NULL
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t4;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
31 Warnings:
32 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
33 SHOW TABLES;
34 Tables_in_test
35 t4
36 SHOW CREATE TABLE t4;
37 Table Create Table
38 t4 CREATE TABLE `t4` (
39 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t4;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t4(c1 INT ZEROFILL NULL);
45 Warnings:
46 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
47 SHOW TABLES;
48 Tables_in_test
49 t4
50 SHOW CREATE TABLE t4;
51 Table Create Table
52 t4 CREATE TABLE `t4` (
53 `c1` int(10) unsigned zerofill DEFAULT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t4;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
59 Warnings:
60 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
61 SHOW TABLES;
62 Tables_in_test
63 t4
64 SHOW CREATE TABLE t4;
65 Table Create Table
66 t4 CREATE TABLE `t4` (
67 `c1` int(10) unsigned zerofill DEFAULT NULL
68 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
69 DROP TABLE t4;
70 SHOW TABLES;
71 Tables_in_test
72 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
73 Warnings:
74 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
75 SHOW TABLES;
76 Tables_in_test
77 t4
78 SHOW CREATE TABLE t4;
79 Table Create Table
80 t4 CREATE TABLE `t4` (
81 `c1` bigint(20) unsigned zerofill DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t4;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
87 Warnings:
88 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
89 SHOW TABLES;
90 Tables_in_test
91 t4
92 SHOW CREATE TABLE t4;
93 Table Create Table
94 t4 CREATE TABLE `t4` (
95 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
96 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
97 DROP TABLE t4;
98 SHOW TABLES;
99 Tables_in_test
100 CREATE TABLE t4(c1 DEC ZEROFILL NULL);
101 Warnings:
102 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
103 SHOW TABLES;
104 Tables_in_test
105 t4
106 SHOW CREATE TABLE t4;
107 Table Create Table
108 t4 CREATE TABLE `t4` (
109 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t4;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t4(c1 FIXED ZEROFILL NULL);
115 Warnings:
116 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
117 SHOW TABLES;
118 Tables_in_test
119 t4
120 SHOW CREATE TABLE t4;
121 Table Create Table
122 t4 CREATE TABLE `t4` (
123 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t4;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
129 Warnings:
130 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
131 SHOW TABLES;
132 Tables_in_test
133 t4
134 SHOW CREATE TABLE t4;
135 Table Create Table
136 t4 CREATE TABLE `t4` (
137 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t4;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
143 Warnings:
144 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
145 SHOW TABLES;
146 Tables_in_test
147 t4
148 SHOW CREATE TABLE t4;
149 Table Create Table
150 t4 CREATE TABLE `t4` (
151 `c1` double unsigned zerofill DEFAULT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t4;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
157 Warnings:
158 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
159 SHOW TABLES;
160 Tables_in_test
161 t4
162 SHOW CREATE TABLE t4;
163 Table Create Table
164 t4 CREATE TABLE `t4` (
165 `c1` double unsigned zerofill DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t4;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL);
171 Warnings:
172 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
173 SHOW TABLES;
174 Tables_in_test
175 t4
176 SHOW CREATE TABLE t4;
177 Table Create Table
178 t4 CREATE TABLE `t4` (
179 `c1` double unsigned zerofill DEFAULT NULL
180 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
181 DROP TABLE t4;
182 SHOW TABLES;
183 Tables_in_test
184 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
185 Warnings:
186 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
187 SHOW TABLES;
188 Tables_in_test
189 t4
190 SHOW CREATE TABLE t4;
191 Table Create Table
192 t4 CREATE TABLE `t4` (
193 `c1` float unsigned zerofill DEFAULT NULL
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t4;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
199 Warnings:
200 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
201 SHOW TABLES;
202 Tables_in_test
203 t4
204 SHOW CREATE TABLE t4;
205 Table Create Table
206 t4 CREATE TABLE `t4` (
207 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 DROP TABLE t4;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
213 Warnings:
214 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
215 SHOW TABLES;
216 Tables_in_test
217 t4
218 SHOW CREATE TABLE t4;
219 Table Create Table
220 t4 CREATE TABLE `t4` (
221 `c1` smallint(5) unsigned zerofill DEFAULT NULL
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t4;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
227 Warnings:
228 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
229 SHOW TABLES;
230 Tables_in_test
231 t4
232 SHOW CREATE TABLE t4;
233 Table Create Table
234 t4 CREATE TABLE `t4` (
235 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
237 DROP TABLE t4;
238 SHOW TABLES;
239 Tables_in_test
240 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
241 Warnings:
242 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
243 SHOW TABLES;
244 Tables_in_test
245 t4
246 SHOW CREATE TABLE t4;
247 Table Create Table
248 t4 CREATE TABLE `t4` (
249 `c1` int(10) unsigned zerofill DEFAULT NULL
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t4;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
255 Warnings:
256 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
257 SHOW TABLES;
258 Tables_in_test
259 t4
260 SHOW CREATE TABLE t4;
261 Table Create Table
262 t4 CREATE TABLE `t4` (
263 `c1` int(10) unsigned zerofill DEFAULT NULL
264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
265 DROP TABLE t4;
266 SHOW TABLES;
267 Tables_in_test
268 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
269 Warnings:
270 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
271 SHOW TABLES;
272 Tables_in_test
273 t4
274 SHOW CREATE TABLE t4;
275 Table Create Table
276 t4 CREATE TABLE `t4` (
277 `c1` bigint(20) unsigned zerofill DEFAULT NULL
278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 DROP TABLE t4;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
283 Warnings:
284 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
285 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
286 SHOW TABLES;
287 Tables_in_test
288 t4
289 SHOW CREATE TABLE t4;
290 Table Create Table
291 t4 CREATE TABLE `t4` (
292 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 DROP TABLE t4;
295 SHOW TABLES;
296 Tables_in_test
297 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
298 Warnings:
299 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
300 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
301 SHOW TABLES;
302 Tables_in_test
303 t4
304 SHOW CREATE TABLE t4;
305 Table Create Table
306 t4 CREATE TABLE `t4` (
307 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
308 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
309 DROP TABLE t4;
310 SHOW TABLES;
311 Tables_in_test
312 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
313 Warnings:
314 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
315 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
316 SHOW TABLES;
317 Tables_in_test
318 t4
319 SHOW CREATE TABLE t4;
320 Table Create Table
321 t4 CREATE TABLE `t4` (
322 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
323 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
324 DROP TABLE t4;
325 SHOW TABLES;
326 Tables_in_test
327 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
328 Warnings:
329 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
330 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
331 SHOW TABLES;
332 Tables_in_test
333 t4
334 SHOW CREATE TABLE t4;
335 Table Create Table
336 t4 CREATE TABLE `t4` (
337 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
339 DROP TABLE t4;
340 SHOW TABLES;
341 Tables_in_test
342 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
343 Warnings:
344 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
345 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
346 SHOW TABLES;
347 Tables_in_test
348 t4
349 SHOW CREATE TABLE t4;
350 Table Create Table
351 t4 CREATE TABLE `t4` (
352 `c1` double unsigned zerofill DEFAULT NULL
353 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
354 DROP TABLE t4;
355 SHOW TABLES;
356 Tables_in_test
357 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
358 Warnings:
359 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
360 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
361 SHOW TABLES;
362 Tables_in_test
363 t4
364 SHOW CREATE TABLE t4;
365 Table Create Table
366 t4 CREATE TABLE `t4` (
367 `c1` double unsigned zerofill DEFAULT NULL
368 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
369 DROP TABLE t4;
370 SHOW TABLES;
371 Tables_in_test
372 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
373 Warnings:
374 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
375 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
376 SHOW TABLES;
377 Tables_in_test
378 t4
379 SHOW CREATE TABLE t4;
380 Table Create Table
381 t4 CREATE TABLE `t4` (
382 `c1` double unsigned zerofill DEFAULT NULL
383 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
384 DROP TABLE t4;
385 SHOW TABLES;
386 Tables_in_test
387 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
388 Warnings:
389 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
390 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
391 SHOW TABLES;
392 Tables_in_test
393 t4
394 SHOW CREATE TABLE t4;
395 Table Create Table
396 t4 CREATE TABLE `t4` (
397 `c1` float unsigned zerofill DEFAULT NULL
398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
399 DROP TABLE t4;
400 SHOW TABLES;
401 Tables_in_test
402 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
403 Warnings:
404 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
405 SHOW TABLES;
406 Tables_in_test
407 t4
408 SHOW CREATE TABLE t4;
409 Table Create Table
410 t4 CREATE TABLE `t4` (
411 `c1` tinyint(3) unsigned zerofill NOT NULL
412 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
413 DROP TABLE t4;
414 SHOW TABLES;
415 Tables_in_test
416 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
417 Warnings:
418 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
419 SHOW TABLES;
420 Tables_in_test
421 t4
422 SHOW CREATE TABLE t4;
423 Table Create Table
424 t4 CREATE TABLE `t4` (
425 `c1` smallint(5) unsigned zerofill NOT NULL
426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
427 DROP TABLE t4;
428 SHOW TABLES;
429 Tables_in_test
430 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
431 Warnings:
432 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
433 SHOW TABLES;
434 Tables_in_test
435 t4
436 SHOW CREATE TABLE t4;
437 Table Create Table
438 t4 CREATE TABLE `t4` (
439 `c1` mediumint(8) unsigned zerofill NOT NULL
440 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
441 DROP TABLE t4;
442 SHOW TABLES;
443 Tables_in_test
444 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
445 Warnings:
446 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
447 SHOW TABLES;
448 Tables_in_test
449 t4
450 SHOW CREATE TABLE t4;
451 Table Create Table
452 t4 CREATE TABLE `t4` (
453 `c1` int(10) unsigned zerofill NOT NULL
454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
455 DROP TABLE t4;
456 SHOW TABLES;
457 Tables_in_test
458 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
459 Warnings:
460 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
461 SHOW TABLES;
462 Tables_in_test
463 t4
464 SHOW CREATE TABLE t4;
465 Table Create Table
466 t4 CREATE TABLE `t4` (
467 `c1` int(10) unsigned zerofill NOT NULL
468 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
469 DROP TABLE t4;
470 SHOW TABLES;
471 Tables_in_test
472 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
473 Warnings:
474 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
475 SHOW TABLES;
476 Tables_in_test
477 t4
478 SHOW CREATE TABLE t4;
479 Table Create Table
480 t4 CREATE TABLE `t4` (
481 `c1` bigint(20) unsigned zerofill NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t4;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
487 Warnings:
488 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
489 SHOW TABLES;
490 Tables_in_test
491 t4
492 SHOW CREATE TABLE t4;
493 Table Create Table
494 t4 CREATE TABLE `t4` (
495 `c1` decimal(10,0) unsigned zerofill NOT NULL
496 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
497 DROP TABLE t4;
498 SHOW TABLES;
499 Tables_in_test
500 CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL);
501 Warnings:
502 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
503 SHOW TABLES;
504 Tables_in_test
505 t4
506 SHOW CREATE TABLE t4;
507 Table Create Table
508 t4 CREATE TABLE `t4` (
509 `c1` decimal(10,0) unsigned zerofill NOT NULL
510 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
511 DROP TABLE t4;
512 SHOW TABLES;
513 Tables_in_test
514 CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL);
515 Warnings:
516 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
517 SHOW TABLES;
518 Tables_in_test
519 t4
520 SHOW CREATE TABLE t4;
521 Table Create Table
522 t4 CREATE TABLE `t4` (
523 `c1` decimal(10,0) unsigned zerofill NOT NULL
524 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
525 DROP TABLE t4;
526 SHOW TABLES;
527 Tables_in_test
528 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
529 Warnings:
530 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
531 SHOW TABLES;
532 Tables_in_test
533 t4
534 SHOW CREATE TABLE t4;
535 Table Create Table
536 t4 CREATE TABLE `t4` (
537 `c1` decimal(10,0) unsigned zerofill NOT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
539 DROP TABLE t4;
540 SHOW TABLES;
541 Tables_in_test
542 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
543 Warnings:
544 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
545 SHOW TABLES;
546 Tables_in_test
547 t4
548 SHOW CREATE TABLE t4;
549 Table Create Table
550 t4 CREATE TABLE `t4` (
551 `c1` double unsigned zerofill NOT NULL
552 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
553 DROP TABLE t4;
554 SHOW TABLES;
555 Tables_in_test
556 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
557 Warnings:
558 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
559 SHOW TABLES;
560 Tables_in_test
561 t4
562 SHOW CREATE TABLE t4;
563 Table Create Table
564 t4 CREATE TABLE `t4` (
565 `c1` double unsigned zerofill NOT NULL
566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
567 DROP TABLE t4;
568 SHOW TABLES;
569 Tables_in_test
570 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL);
571 Warnings:
572 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
573 SHOW TABLES;
574 Tables_in_test
575 t4
576 SHOW CREATE TABLE t4;
577 Table Create Table
578 t4 CREATE TABLE `t4` (
579 `c1` double unsigned zerofill NOT NULL
580 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
581 DROP TABLE t4;
582 SHOW TABLES;
583 Tables_in_test
584 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
585 Warnings:
586 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
587 SHOW TABLES;
588 Tables_in_test
589 t4
590 SHOW CREATE TABLE t4;
591 Table Create Table
592 t4 CREATE TABLE `t4` (
593 `c1` float unsigned zerofill NOT NULL
594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
595 DROP TABLE t4;
596 SHOW TABLES;
597 Tables_in_test
598 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
599 Warnings:
600 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
601 SHOW TABLES;
602 Tables_in_test
603 t4
604 SHOW CREATE TABLE t4;
605 Table Create Table
606 t4 CREATE TABLE `t4` (
607 `c1` tinyint(3) unsigned zerofill NOT NULL
608 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 DROP TABLE t4;
610 SHOW TABLES;
611 Tables_in_test
612 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
613 Warnings:
614 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
615 SHOW TABLES;
616 Tables_in_test
617 t4
618 SHOW CREATE TABLE t4;
619 Table Create Table
620 t4 CREATE TABLE `t4` (
621 `c1` smallint(5) unsigned zerofill NOT NULL
622 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
623 DROP TABLE t4;
624 SHOW TABLES;
625 Tables_in_test
626 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
627 Warnings:
628 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
629 SHOW TABLES;
630 Tables_in_test
631 t4
632 SHOW CREATE TABLE t4;
633 Table Create Table
634 t4 CREATE TABLE `t4` (
635 `c1` mediumint(8) unsigned zerofill NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
637 DROP TABLE t4;
638 SHOW TABLES;
639 Tables_in_test
640 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
641 Warnings:
642 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
643 SHOW TABLES;
644 Tables_in_test
645 t4
646 SHOW CREATE TABLE t4;
647 Table Create Table
648 t4 CREATE TABLE `t4` (
649 `c1` int(10) unsigned zerofill NOT NULL
650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
651 DROP TABLE t4;
652 SHOW TABLES;
653 Tables_in_test
654 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
655 Warnings:
656 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
657 SHOW TABLES;
658 Tables_in_test
659 t4
660 SHOW CREATE TABLE t4;
661 Table Create Table
662 t4 CREATE TABLE `t4` (
663 `c1` int(10) unsigned zerofill NOT NULL
664 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
665 DROP TABLE t4;
666 SHOW TABLES;
667 Tables_in_test
668 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
669 Warnings:
670 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
671 SHOW TABLES;
672 Tables_in_test
673 t4
674 SHOW CREATE TABLE t4;
675 Table Create Table
676 t4 CREATE TABLE `t4` (
677 `c1` bigint(20) unsigned zerofill NOT NULL
678 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
679 DROP TABLE t4;
680 SHOW TABLES;
681 Tables_in_test
682 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
683 Warnings:
684 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
685 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
686 SHOW TABLES;
687 Tables_in_test
688 t4
689 SHOW CREATE TABLE t4;
690 Table Create Table
691 t4 CREATE TABLE `t4` (
692 `c1` decimal(10,0) unsigned zerofill NOT NULL
693 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
694 DROP TABLE t4;
695 SHOW TABLES;
696 Tables_in_test
697 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
698 Warnings:
699 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
700 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
701 SHOW TABLES;
702 Tables_in_test
703 t4
704 SHOW CREATE TABLE t4;
705 Table Create Table
706 t4 CREATE TABLE `t4` (
707 `c1` decimal(10,0) unsigned zerofill NOT NULL
708 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
709 DROP TABLE t4;
710 SHOW TABLES;
711 Tables_in_test
712 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
713 Warnings:
714 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
715 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
716 SHOW TABLES;
717 Tables_in_test
718 t4
719 SHOW CREATE TABLE t4;
720 Table Create Table
721 t4 CREATE TABLE `t4` (
722 `c1` decimal(10,0) unsigned zerofill NOT NULL
723 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
724 DROP TABLE t4;
725 SHOW TABLES;
726 Tables_in_test
727 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
728 Warnings:
729 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
730 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
731 SHOW TABLES;
732 Tables_in_test
733 t4
734 SHOW CREATE TABLE t4;
735 Table Create Table
736 t4 CREATE TABLE `t4` (
737 `c1` decimal(10,0) unsigned zerofill NOT NULL
738 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
739 DROP TABLE t4;
740 SHOW TABLES;
741 Tables_in_test
742 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
743 Warnings:
744 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
745 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
746 SHOW TABLES;
747 Tables_in_test
748 t4
749 SHOW CREATE TABLE t4;
750 Table Create Table
751 t4 CREATE TABLE `t4` (
752 `c1` double unsigned zerofill NOT NULL
753 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
754 DROP TABLE t4;
755 SHOW TABLES;
756 Tables_in_test
757 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
758 Warnings:
759 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
760 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
761 SHOW TABLES;
762 Tables_in_test
763 t4
764 SHOW CREATE TABLE t4;
765 Table Create Table
766 t4 CREATE TABLE `t4` (
767 `c1` double unsigned zerofill NOT NULL
768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
769 DROP TABLE t4;
770 SHOW TABLES;
771 Tables_in_test
772 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
773 Warnings:
774 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
775 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
776 SHOW TABLES;
777 Tables_in_test
778 t4
779 SHOW CREATE TABLE t4;
780 Table Create Table
781 t4 CREATE TABLE `t4` (
782 `c1` double unsigned zerofill NOT NULL
783 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
784 DROP TABLE t4;
785 SHOW TABLES;
786 Tables_in_test
787 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
788 Warnings:
789 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
790 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
791 SHOW TABLES;
792 Tables_in_test
793 t4
794 SHOW CREATE TABLE t4;
795 Table Create Table
796 t4 CREATE TABLE `t4` (
797 `c1` float unsigned zerofill NOT NULL
798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
799 DROP TABLE t4;
800 SHOW TABLES;
801 Tables_in_test