Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` bit(1) NOT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t1 ADD KEY (c1);
12 SHOW TABLES;
13 Tables_in_test
14 t1
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `c1` bit(1) NOT NULL,
19 KEY `c1` (`c1`)
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1(c1 TINYINT NOT NULL);
25 SHOW TABLES;
26 Tables_in_test
27 t1
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` tinyint NOT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t1 ADD KEY (c1);
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` tinyint NOT NULL,
41 KEY `c1` (`c1`)
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1(c1 SMALLINT NOT NULL);
47 SHOW TABLES;
48 Tables_in_test
49 t1
50 SHOW CREATE TABLE t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `c1` smallint NOT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t1 ADD KEY (c1);
56 SHOW TABLES;
57 Tables_in_test
58 t1
59 SHOW CREATE TABLE t1;
60 Table Create Table
61 t1 CREATE TABLE `t1` (
62 `c1` smallint NOT NULL,
63 KEY `c1` (`c1`)
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
69 SHOW TABLES;
70 Tables_in_test
71 t1
72 SHOW CREATE TABLE t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `c1` mediumint NOT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t1 ADD KEY (c1);
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` mediumint NOT NULL,
85 KEY `c1` (`c1`)
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t1(c1 INT NOT NULL);
91 SHOW TABLES;
92 Tables_in_test
93 t1
94 SHOW CREATE TABLE t1;
95 Table Create Table
96 t1 CREATE TABLE `t1` (
97 `c1` int NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t1 ADD KEY (c1);
100 SHOW TABLES;
101 Tables_in_test
102 t1
103 SHOW CREATE TABLE t1;
104 Table Create Table
105 t1 CREATE TABLE `t1` (
106 `c1` int NOT NULL,
107 KEY `c1` (`c1`)
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t1(c1 INTEGER NOT NULL);
113 SHOW TABLES;
114 Tables_in_test
115 t1
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `c1` int NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t1 ADD KEY (c1);
122 SHOW TABLES;
123 Tables_in_test
124 t1
125 SHOW CREATE TABLE t1;
126 Table Create Table
127 t1 CREATE TABLE `t1` (
128 `c1` int NOT NULL,
129 KEY `c1` (`c1`)
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t1;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t1(c1 BIGINT NOT NULL);
135 SHOW TABLES;
136 Tables_in_test
137 t1
138 SHOW CREATE TABLE t1;
139 Table Create Table
140 t1 CREATE TABLE `t1` (
141 `c1` bigint NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t1 ADD KEY (c1);
144 SHOW TABLES;
145 Tables_in_test
146 t1
147 SHOW CREATE TABLE t1;
148 Table Create Table
149 t1 CREATE TABLE `t1` (
150 `c1` bigint NOT NULL,
151 KEY `c1` (`c1`)
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t1;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t1(c1 REAL NOT NULL);
157 SHOW TABLES;
158 Tables_in_test
159 t1
160 SHOW CREATE TABLE t1;
161 Table Create Table
162 t1 CREATE TABLE `t1` (
163 `c1` double NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t1 ADD KEY (c1);
166 SHOW TABLES;
167 Tables_in_test
168 t1
169 SHOW CREATE TABLE t1;
170 Table Create Table
171 t1 CREATE TABLE `t1` (
172 `c1` double NOT NULL,
173 KEY `c1` (`c1`)
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t1;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t1(c1 DOUBLE NOT NULL);
179 SHOW TABLES;
180 Tables_in_test
181 t1
182 SHOW CREATE TABLE t1;
183 Table Create Table
184 t1 CREATE TABLE `t1` (
185 `c1` double NOT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t1 ADD KEY (c1);
188 SHOW TABLES;
189 Tables_in_test
190 t1
191 SHOW CREATE TABLE t1;
192 Table Create Table
193 t1 CREATE TABLE `t1` (
194 `c1` double NOT NULL,
195 KEY `c1` (`c1`)
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t1;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t1(c1 FLOAT NOT NULL);
201 SHOW TABLES;
202 Tables_in_test
203 t1
204 SHOW CREATE TABLE t1;
205 Table Create Table
206 t1 CREATE TABLE `t1` (
207 `c1` float NOT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 ALTER TABLE t1 ADD KEY (c1);
210 SHOW TABLES;
211 Tables_in_test
212 t1
213 SHOW CREATE TABLE t1;
214 Table Create Table
215 t1 CREATE TABLE `t1` (
216 `c1` float NOT NULL,
217 KEY `c1` (`c1`)
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t1;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t1(c1 DECIMAL NOT NULL);
223 SHOW TABLES;
224 Tables_in_test
225 t1
226 SHOW CREATE TABLE t1;
227 Table Create Table
228 t1 CREATE TABLE `t1` (
229 `c1` decimal(10,0) NOT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 ALTER TABLE t1 ADD KEY (c1);
232 SHOW TABLES;
233 Tables_in_test
234 t1
235 SHOW CREATE TABLE t1;
236 Table Create Table
237 t1 CREATE TABLE `t1` (
238 `c1` decimal(10,0) NOT NULL,
239 KEY `c1` (`c1`)
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t1;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t1(c1 NUMERIC NOT NULL);
245 SHOW TABLES;
246 Tables_in_test
247 t1
248 SHOW CREATE TABLE t1;
249 Table Create Table
250 t1 CREATE TABLE `t1` (
251 `c1` decimal(10,0) NOT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 ALTER TABLE t1 ADD KEY (c1);
254 SHOW TABLES;
255 Tables_in_test
256 t1
257 SHOW CREATE TABLE t1;
258 Table Create Table
259 t1 CREATE TABLE `t1` (
260 `c1` decimal(10,0) NOT NULL,
261 KEY `c1` (`c1`)
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t1;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t1(c1 DATE NOT NULL);
267 SHOW TABLES;
268 Tables_in_test
269 t1
270 SHOW CREATE TABLE t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `c1` date NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 ALTER TABLE t1 ADD KEY (c1);
276 SHOW TABLES;
277 Tables_in_test
278 t1
279 SHOW CREATE TABLE t1;
280 Table Create Table
281 t1 CREATE TABLE `t1` (
282 `c1` date NOT NULL,
283 KEY `c1` (`c1`)
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t1;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t1(c1 TIME NOT NULL);
289 SHOW TABLES;
290 Tables_in_test
291 t1
292 SHOW CREATE TABLE t1;
293 Table Create Table
294 t1 CREATE TABLE `t1` (
295 `c1` time NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 ALTER TABLE t1 ADD KEY (c1);
298 SHOW TABLES;
299 Tables_in_test
300 t1
301 SHOW CREATE TABLE t1;
302 Table Create Table
303 t1 CREATE TABLE `t1` (
304 `c1` time NOT NULL,
305 KEY `c1` (`c1`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` timestamp NOT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 ALTER TABLE t1 ADD KEY (c1);
320 SHOW TABLES;
321 Tables_in_test
322 t1
323 SHOW CREATE TABLE t1;
324 Table Create Table
325 t1 CREATE TABLE `t1` (
326 `c1` timestamp NOT NULL,
327 KEY `c1` (`c1`)
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t1(c1 YEAR NOT NULL);
333 SHOW TABLES;
334 Tables_in_test
335 t1
336 SHOW CREATE TABLE t1;
337 Table Create Table
338 t1 CREATE TABLE `t1` (
339 `c1` year NOT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 ALTER TABLE t1 ADD KEY (c1);
342 SHOW TABLES;
343 Tables_in_test
344 t1
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `c1` year NOT NULL,
349 KEY `c1` (`c1`)
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t1;
352 SHOW TABLES;
353 Tables_in_test
354 CREATE TABLE t1(c1 BIT NOT NULL);
355 SHOW TABLES;
356 Tables_in_test
357 t1
358 SHOW CREATE TABLE t1;
359 Table Create Table
360 t1 CREATE TABLE `t1` (
361 `c1` bit(1) NOT NULL
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 ALTER TABLE t1 ADD KEY USING BTREE (c1);
364 SHOW TABLES;
365 Tables_in_test
366 t1
367 SHOW CREATE TABLE t1;
368 Table Create Table
369 t1 CREATE TABLE `t1` (
370 `c1` bit(1) NOT NULL,
371 KEY `c1` (`c1`) USING BTREE
372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 DROP TABLE t1;
374 SHOW TABLES;
375 Tables_in_test
376 CREATE TABLE t1(c1 TINYINT NOT NULL);
377 SHOW TABLES;
378 Tables_in_test
379 t1
380 SHOW CREATE TABLE t1;
381 Table Create Table
382 t1 CREATE TABLE `t1` (
383 `c1` tinyint NOT NULL
384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
385 ALTER TABLE t1 ADD KEY USING BTREE (c1);
386 SHOW TABLES;
387 Tables_in_test
388 t1
389 SHOW CREATE TABLE t1;
390 Table Create Table
391 t1 CREATE TABLE `t1` (
392 `c1` tinyint NOT NULL,
393 KEY `c1` (`c1`) USING BTREE
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
395 DROP TABLE t1;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TABLE t1(c1 SMALLINT NOT NULL);
399 SHOW TABLES;
400 Tables_in_test
401 t1
402 SHOW CREATE TABLE t1;
403 Table Create Table
404 t1 CREATE TABLE `t1` (
405 `c1` smallint NOT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 ALTER TABLE t1 ADD KEY USING BTREE (c1);
408 SHOW TABLES;
409 Tables_in_test
410 t1
411 SHOW CREATE TABLE t1;
412 Table Create Table
413 t1 CREATE TABLE `t1` (
414 `c1` smallint NOT NULL,
415 KEY `c1` (`c1`) USING BTREE
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 DROP TABLE t1;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
421 SHOW TABLES;
422 Tables_in_test
423 t1
424 SHOW CREATE TABLE t1;
425 Table Create Table
426 t1 CREATE TABLE `t1` (
427 `c1` mediumint NOT NULL
428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 ALTER TABLE t1 ADD KEY USING BTREE (c1);
430 SHOW TABLES;
431 Tables_in_test
432 t1
433 SHOW CREATE TABLE t1;
434 Table Create Table
435 t1 CREATE TABLE `t1` (
436 `c1` mediumint NOT NULL,
437 KEY `c1` (`c1`) USING BTREE
438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE t1;
440 SHOW TABLES;
441 Tables_in_test
442 CREATE TABLE t1(c1 INT NOT NULL);
443 SHOW TABLES;
444 Tables_in_test
445 t1
446 SHOW CREATE TABLE t1;
447 Table Create Table
448 t1 CREATE TABLE `t1` (
449 `c1` int NOT NULL
450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
451 ALTER TABLE t1 ADD KEY USING BTREE (c1);
452 SHOW TABLES;
453 Tables_in_test
454 t1
455 SHOW CREATE TABLE t1;
456 Table Create Table
457 t1 CREATE TABLE `t1` (
458 `c1` int NOT NULL,
459 KEY `c1` (`c1`) USING BTREE
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
461 DROP TABLE t1;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t1(c1 INTEGER NOT NULL);
465 SHOW TABLES;
466 Tables_in_test
467 t1
468 SHOW CREATE TABLE t1;
469 Table Create Table
470 t1 CREATE TABLE `t1` (
471 `c1` int NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 ALTER TABLE t1 ADD KEY USING BTREE (c1);
474 SHOW TABLES;
475 Tables_in_test
476 t1
477 SHOW CREATE TABLE t1;
478 Table Create Table
479 t1 CREATE TABLE `t1` (
480 `c1` int NOT NULL,
481 KEY `c1` (`c1`) USING BTREE
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t1;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t1(c1 BIGINT NOT NULL);
487 SHOW TABLES;
488 Tables_in_test
489 t1
490 SHOW CREATE TABLE t1;
491 Table Create Table
492 t1 CREATE TABLE `t1` (
493 `c1` bigint NOT NULL
494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495 ALTER TABLE t1 ADD KEY USING BTREE (c1);
496 SHOW TABLES;
497 Tables_in_test
498 t1
499 SHOW CREATE TABLE t1;
500 Table Create Table
501 t1 CREATE TABLE `t1` (
502 `c1` bigint NOT NULL,
503 KEY `c1` (`c1`) USING BTREE
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t1;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TABLE t1(c1 REAL NOT NULL);
509 SHOW TABLES;
510 Tables_in_test
511 t1
512 SHOW CREATE TABLE t1;
513 Table Create Table
514 t1 CREATE TABLE `t1` (
515 `c1` double NOT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t1 ADD KEY USING BTREE (c1);
518 SHOW TABLES;
519 Tables_in_test
520 t1
521 SHOW CREATE TABLE t1;
522 Table Create Table
523 t1 CREATE TABLE `t1` (
524 `c1` double NOT NULL,
525 KEY `c1` (`c1`) USING BTREE
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t1;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TABLE t1(c1 DOUBLE NOT NULL);
531 SHOW TABLES;
532 Tables_in_test
533 t1
534 SHOW CREATE TABLE t1;
535 Table Create Table
536 t1 CREATE TABLE `t1` (
537 `c1` double NOT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
539 ALTER TABLE t1 ADD KEY USING BTREE (c1);
540 SHOW TABLES;
541 Tables_in_test
542 t1
543 SHOW CREATE TABLE t1;
544 Table Create Table
545 t1 CREATE TABLE `t1` (
546 `c1` double NOT NULL,
547 KEY `c1` (`c1`) USING BTREE
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549 DROP TABLE t1;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TABLE t1(c1 FLOAT NOT NULL);
553 SHOW TABLES;
554 Tables_in_test
555 t1
556 SHOW CREATE TABLE t1;
557 Table Create Table
558 t1 CREATE TABLE `t1` (
559 `c1` float NOT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
561 ALTER TABLE t1 ADD KEY USING BTREE (c1);
562 SHOW TABLES;
563 Tables_in_test
564 t1
565 SHOW CREATE TABLE t1;
566 Table Create Table
567 t1 CREATE TABLE `t1` (
568 `c1` float NOT NULL,
569 KEY `c1` (`c1`) USING BTREE
570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
571 DROP TABLE t1;
572 SHOW TABLES;
573 Tables_in_test
574 CREATE TABLE t1(c1 DECIMAL NOT NULL);
575 SHOW TABLES;
576 Tables_in_test
577 t1
578 SHOW CREATE TABLE t1;
579 Table Create Table
580 t1 CREATE TABLE `t1` (
581 `c1` decimal(10,0) NOT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
583 ALTER TABLE t1 ADD KEY USING BTREE (c1);
584 SHOW TABLES;
585 Tables_in_test
586 t1
587 SHOW CREATE TABLE t1;
588 Table Create Table
589 t1 CREATE TABLE `t1` (
590 `c1` decimal(10,0) NOT NULL,
591 KEY `c1` (`c1`) USING BTREE
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE t1;
594 SHOW TABLES;
595 Tables_in_test
596 CREATE TABLE t1(c1 NUMERIC NOT NULL);
597 SHOW TABLES;
598 Tables_in_test
599 t1
600 SHOW CREATE TABLE t1;
601 Table Create Table
602 t1 CREATE TABLE `t1` (
603 `c1` decimal(10,0) NOT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
605 ALTER TABLE t1 ADD KEY USING BTREE (c1);
606 SHOW TABLES;
607 Tables_in_test
608 t1
609 SHOW CREATE TABLE t1;
610 Table Create Table
611 t1 CREATE TABLE `t1` (
612 `c1` decimal(10,0) NOT NULL,
613 KEY `c1` (`c1`) USING BTREE
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t1;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t1(c1 DATE NOT NULL);
619 SHOW TABLES;
620 Tables_in_test
621 t1
622 SHOW CREATE TABLE t1;
623 Table Create Table
624 t1 CREATE TABLE `t1` (
625 `c1` date NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 ALTER TABLE t1 ADD KEY USING BTREE (c1);
628 SHOW TABLES;
629 Tables_in_test
630 t1
631 SHOW CREATE TABLE t1;
632 Table Create Table
633 t1 CREATE TABLE `t1` (
634 `c1` date NOT NULL,
635 KEY `c1` (`c1`) USING BTREE
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
637 DROP TABLE t1;
638 SHOW TABLES;
639 Tables_in_test
640 CREATE TABLE t1(c1 TIME NOT NULL);
641 SHOW TABLES;
642 Tables_in_test
643 t1
644 SHOW CREATE TABLE t1;
645 Table Create Table
646 t1 CREATE TABLE `t1` (
647 `c1` time NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
649 ALTER TABLE t1 ADD KEY USING BTREE (c1);
650 SHOW TABLES;
651 Tables_in_test
652 t1
653 SHOW CREATE TABLE t1;
654 Table Create Table
655 t1 CREATE TABLE `t1` (
656 `c1` time NOT NULL,
657 KEY `c1` (`c1`) USING BTREE
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 DROP TABLE t1;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
663 SHOW TABLES;
664 Tables_in_test
665 t1
666 SHOW CREATE TABLE t1;
667 Table Create Table
668 t1 CREATE TABLE `t1` (
669 `c1` timestamp NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 ALTER TABLE t1 ADD KEY USING BTREE (c1);
672 SHOW TABLES;
673 Tables_in_test
674 t1
675 SHOW CREATE TABLE t1;
676 Table Create Table
677 t1 CREATE TABLE `t1` (
678 `c1` timestamp NOT NULL,
679 KEY `c1` (`c1`) USING BTREE
680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
681 DROP TABLE t1;
682 SHOW TABLES;
683 Tables_in_test
684 CREATE TABLE t1(c1 YEAR NOT NULL);
685 SHOW TABLES;
686 Tables_in_test
687 t1
688 SHOW CREATE TABLE t1;
689 Table Create Table
690 t1 CREATE TABLE `t1` (
691 `c1` year NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693 ALTER TABLE t1 ADD KEY USING BTREE (c1);
694 SHOW TABLES;
695 Tables_in_test
696 t1
697 SHOW CREATE TABLE t1;
698 Table Create Table
699 t1 CREATE TABLE `t1` (
700 `c1` year NOT NULL,
701 KEY `c1` (`c1`) USING BTREE
702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
703 DROP TABLE t1;
704 SHOW TABLES;
705 Tables_in_test
706 CREATE TABLE t1(c1 BIT NOT NULL);
707 SHOW TABLES;
708 Tables_in_test
709 t1
710 SHOW CREATE TABLE t1;
711 Table Create Table
712 t1 CREATE TABLE `t1` (
713 `c1` bit(1) NOT NULL
714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
715 ALTER TABLE t1 ADD KEY USING HASH (c1);
716 Warnings:
717 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
718 SHOW TABLES;
719 Tables_in_test
720 t1
721 SHOW CREATE TABLE t1;
722 Table Create Table
723 t1 CREATE TABLE `t1` (
724 `c1` bit(1) NOT NULL,
725 KEY `c1` (`c1`)
726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
727 DROP TABLE t1;
728 SHOW TABLES;
729 Tables_in_test
730 CREATE TABLE t1(c1 TINYINT NOT NULL);
731 SHOW TABLES;
732 Tables_in_test
733 t1
734 SHOW CREATE TABLE t1;
735 Table Create Table
736 t1 CREATE TABLE `t1` (
737 `c1` tinyint NOT NULL
738 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
739 ALTER TABLE t1 ADD KEY USING HASH (c1);
740 Warnings:
741 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
742 SHOW TABLES;
743 Tables_in_test
744 t1
745 SHOW CREATE TABLE t1;
746 Table Create Table
747 t1 CREATE TABLE `t1` (
748 `c1` tinyint NOT NULL,
749 KEY `c1` (`c1`)
750 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
751 DROP TABLE t1;
752 SHOW TABLES;
753 Tables_in_test
754 CREATE TABLE t1(c1 SMALLINT NOT NULL);
755 SHOW TABLES;
756 Tables_in_test
757 t1
758 SHOW CREATE TABLE t1;
759 Table Create Table
760 t1 CREATE TABLE `t1` (
761 `c1` smallint NOT NULL
762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
763 ALTER TABLE t1 ADD KEY USING HASH (c1);
764 Warnings:
765 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
766 SHOW TABLES;
767 Tables_in_test
768 t1
769 SHOW CREATE TABLE t1;
770 Table Create Table
771 t1 CREATE TABLE `t1` (
772 `c1` smallint NOT NULL,
773 KEY `c1` (`c1`)
774 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
775 DROP TABLE t1;
776 SHOW TABLES;
777 Tables_in_test
778 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
779 SHOW TABLES;
780 Tables_in_test
781 t1
782 SHOW CREATE TABLE t1;
783 Table Create Table
784 t1 CREATE TABLE `t1` (
785 `c1` mediumint NOT NULL
786 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
787 ALTER TABLE t1 ADD KEY USING HASH (c1);
788 Warnings:
789 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
790 SHOW TABLES;
791 Tables_in_test
792 t1
793 SHOW CREATE TABLE t1;
794 Table Create Table
795 t1 CREATE TABLE `t1` (
796 `c1` mediumint NOT NULL,
797 KEY `c1` (`c1`)
798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
799 DROP TABLE t1;
800 SHOW TABLES;
801 Tables_in_test
802 CREATE TABLE t1(c1 INT NOT NULL);
803 SHOW TABLES;
804 Tables_in_test
805 t1
806 SHOW CREATE TABLE t1;
807 Table Create Table
808 t1 CREATE TABLE `t1` (
809 `c1` int NOT NULL
810 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
811 ALTER TABLE t1 ADD KEY USING HASH (c1);
812 Warnings:
813 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
814 SHOW TABLES;
815 Tables_in_test
816 t1
817 SHOW CREATE TABLE t1;
818 Table Create Table
819 t1 CREATE TABLE `t1` (
820 `c1` int NOT NULL,
821 KEY `c1` (`c1`)
822 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
823 DROP TABLE t1;
824 SHOW TABLES;
825 Tables_in_test
826 CREATE TABLE t1(c1 INTEGER NOT NULL);
827 SHOW TABLES;
828 Tables_in_test
829 t1
830 SHOW CREATE TABLE t1;
831 Table Create Table
832 t1 CREATE TABLE `t1` (
833 `c1` int NOT NULL
834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
835 ALTER TABLE t1 ADD KEY USING HASH (c1);
836 Warnings:
837 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
838 SHOW TABLES;
839 Tables_in_test
840 t1
841 SHOW CREATE TABLE t1;
842 Table Create Table
843 t1 CREATE TABLE `t1` (
844 `c1` int NOT NULL,
845 KEY `c1` (`c1`)
846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
847 DROP TABLE t1;
848 SHOW TABLES;
849 Tables_in_test
850 CREATE TABLE t1(c1 BIGINT NOT NULL);
851 SHOW TABLES;
852 Tables_in_test
853 t1
854 SHOW CREATE TABLE t1;
855 Table Create Table
856 t1 CREATE TABLE `t1` (
857 `c1` bigint NOT NULL
858 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
859 ALTER TABLE t1 ADD KEY USING HASH (c1);
860 Warnings:
861 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
862 SHOW TABLES;
863 Tables_in_test
864 t1
865 SHOW CREATE TABLE t1;
866 Table Create Table
867 t1 CREATE TABLE `t1` (
868 `c1` bigint NOT NULL,
869 KEY `c1` (`c1`)
870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
871 DROP TABLE t1;
872 SHOW TABLES;
873 Tables_in_test
874 CREATE TABLE t1(c1 REAL NOT NULL);
875 SHOW TABLES;
876 Tables_in_test
877 t1
878 SHOW CREATE TABLE t1;
879 Table Create Table
880 t1 CREATE TABLE `t1` (
881 `c1` double NOT NULL
882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
883 ALTER TABLE t1 ADD KEY USING HASH (c1);
884 Warnings:
885 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
886 SHOW TABLES;
887 Tables_in_test
888 t1
889 SHOW CREATE TABLE t1;
890 Table Create Table
891 t1 CREATE TABLE `t1` (
892 `c1` double NOT NULL,
893 KEY `c1` (`c1`)
894 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
895 DROP TABLE t1;
896 SHOW TABLES;
897 Tables_in_test
898 CREATE TABLE t1(c1 DOUBLE NOT NULL);
899 SHOW TABLES;
900 Tables_in_test
901 t1
902 SHOW CREATE TABLE t1;
903 Table Create Table
904 t1 CREATE TABLE `t1` (
905 `c1` double NOT NULL
906 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
907 ALTER TABLE t1 ADD KEY USING HASH (c1);
908 Warnings:
909 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
910 SHOW TABLES;
911 Tables_in_test
912 t1
913 SHOW CREATE TABLE t1;
914 Table Create Table
915 t1 CREATE TABLE `t1` (
916 `c1` double NOT NULL,
917 KEY `c1` (`c1`)
918 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
919 DROP TABLE t1;
920 SHOW TABLES;
921 Tables_in_test
922 CREATE TABLE t1(c1 FLOAT NOT NULL);
923 SHOW TABLES;
924 Tables_in_test
925 t1
926 SHOW CREATE TABLE t1;
927 Table Create Table
928 t1 CREATE TABLE `t1` (
929 `c1` float NOT NULL
930 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
931 ALTER TABLE t1 ADD KEY USING HASH (c1);
932 Warnings:
933 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
934 SHOW TABLES;
935 Tables_in_test
936 t1
937 SHOW CREATE TABLE t1;
938 Table Create Table
939 t1 CREATE TABLE `t1` (
940 `c1` float NOT NULL,
941 KEY `c1` (`c1`)
942 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
943 DROP TABLE t1;
944 SHOW TABLES;
945 Tables_in_test
946 CREATE TABLE t1(c1 DECIMAL NOT NULL);
947 SHOW TABLES;
948 Tables_in_test
949 t1
950 SHOW CREATE TABLE t1;
951 Table Create Table
952 t1 CREATE TABLE `t1` (
953 `c1` decimal(10,0) NOT NULL
954 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
955 ALTER TABLE t1 ADD KEY USING HASH (c1);
956 Warnings:
957 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
958 SHOW TABLES;
959 Tables_in_test
960 t1
961 SHOW CREATE TABLE t1;
962 Table Create Table
963 t1 CREATE TABLE `t1` (
964 `c1` decimal(10,0) NOT NULL,
965 KEY `c1` (`c1`)
966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
967 DROP TABLE t1;
968 SHOW TABLES;
969 Tables_in_test
970 CREATE TABLE t1(c1 NUMERIC NOT NULL);
971 SHOW TABLES;
972 Tables_in_test
973 t1
974 SHOW CREATE TABLE t1;
975 Table Create Table
976 t1 CREATE TABLE `t1` (
977 `c1` decimal(10,0) NOT NULL
978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
979 ALTER TABLE t1 ADD KEY USING HASH (c1);
980 Warnings:
981 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
982 SHOW TABLES;
983 Tables_in_test
984 t1
985 SHOW CREATE TABLE t1;
986 Table Create Table
987 t1 CREATE TABLE `t1` (
988 `c1` decimal(10,0) NOT NULL,
989 KEY `c1` (`c1`)
990 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
991 DROP TABLE t1;
992 SHOW TABLES;
993 Tables_in_test
994 CREATE TABLE t1(c1 DATE NOT NULL);
995 SHOW TABLES;
996 Tables_in_test
997 t1
998 SHOW CREATE TABLE t1;
999 Table Create Table
1000 t1 CREATE TABLE `t1` (
1001 `c1` date NOT NULL
1002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1003 ALTER TABLE t1 ADD KEY USING HASH (c1);
1004 Warnings:
1005 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1006 SHOW TABLES;
1007 Tables_in_test
1008 t1
1009 SHOW CREATE TABLE t1;
1010 Table Create Table
1011 t1 CREATE TABLE `t1` (
1012 `c1` date NOT NULL,
1013 KEY `c1` (`c1`)
1014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1015 DROP TABLE t1;
1016 SHOW TABLES;
1017 Tables_in_test
1018 CREATE TABLE t1(c1 TIME NOT NULL);
1019 SHOW TABLES;
1020 Tables_in_test
1021 t1
1022 SHOW CREATE TABLE t1;
1023 Table Create Table
1024 t1 CREATE TABLE `t1` (
1025 `c1` time NOT NULL
1026 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1027 ALTER TABLE t1 ADD KEY USING HASH (c1);
1028 Warnings:
1029 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1030 SHOW TABLES;
1031 Tables_in_test
1032 t1
1033 SHOW CREATE TABLE t1;
1034 Table Create Table
1035 t1 CREATE TABLE `t1` (
1036 `c1` time NOT NULL,
1037 KEY `c1` (`c1`)
1038 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1039 DROP TABLE t1;
1040 SHOW TABLES;
1041 Tables_in_test
1042 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1043 SHOW TABLES;
1044 Tables_in_test
1045 t1
1046 SHOW CREATE TABLE t1;
1047 Table Create Table
1048 t1 CREATE TABLE `t1` (
1049 `c1` timestamp NOT NULL
1050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1051 ALTER TABLE t1 ADD KEY USING HASH (c1);
1052 Warnings:
1053 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1054 SHOW TABLES;
1055 Tables_in_test
1056 t1
1057 SHOW CREATE TABLE t1;
1058 Table Create Table
1059 t1 CREATE TABLE `t1` (
1060 `c1` timestamp NOT NULL,
1061 KEY `c1` (`c1`)
1062 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1063 DROP TABLE t1;
1064 SHOW TABLES;
1065 Tables_in_test
1066 CREATE TABLE t1(c1 YEAR NOT NULL);
1067 SHOW TABLES;
1068 Tables_in_test
1069 t1
1070 SHOW CREATE TABLE t1;
1071 Table Create Table
1072 t1 CREATE TABLE `t1` (
1073 `c1` year NOT NULL
1074 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1075 ALTER TABLE t1 ADD KEY USING HASH (c1);
1076 Warnings:
1077 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1078 SHOW TABLES;
1079 Tables_in_test
1080 t1
1081 SHOW CREATE TABLE t1;
1082 Table Create Table
1083 t1 CREATE TABLE `t1` (
1084 `c1` year NOT NULL,
1085 KEY `c1` (`c1`)
1086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1087 DROP TABLE t1;
1088 SHOW TABLES;
1089 Tables_in_test
1090 CREATE TABLE t1(c1 BIT NOT NULL);
1091 SHOW TABLES;
1092 Tables_in_test
1093 t1
1094 SHOW CREATE TABLE t1;
1095 Table Create Table
1096 t1 CREATE TABLE `t1` (
1097 `c1` bit(1) NOT NULL
1098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1099 ALTER TABLE t1 ADD INDEX (c1);
1100 SHOW TABLES;
1101 Tables_in_test
1102 t1
1103 SHOW CREATE TABLE t1;
1104 Table Create Table
1105 t1 CREATE TABLE `t1` (
1106 `c1` bit(1) NOT NULL,
1107 KEY `c1` (`c1`)
1108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1109 DROP TABLE t1;
1110 SHOW TABLES;
1111 Tables_in_test
1112 CREATE TABLE t1(c1 TINYINT NOT NULL);
1113 SHOW TABLES;
1114 Tables_in_test
1115 t1
1116 SHOW CREATE TABLE t1;
1117 Table Create Table
1118 t1 CREATE TABLE `t1` (
1119 `c1` tinyint NOT NULL
1120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1121 ALTER TABLE t1 ADD INDEX (c1);
1122 SHOW TABLES;
1123 Tables_in_test
1124 t1
1125 SHOW CREATE TABLE t1;
1126 Table Create Table
1127 t1 CREATE TABLE `t1` (
1128 `c1` tinyint NOT NULL,
1129 KEY `c1` (`c1`)
1130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1131 DROP TABLE t1;
1132 SHOW TABLES;
1133 Tables_in_test
1134 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1135 SHOW TABLES;
1136 Tables_in_test
1137 t1
1138 SHOW CREATE TABLE t1;
1139 Table Create Table
1140 t1 CREATE TABLE `t1` (
1141 `c1` smallint NOT NULL
1142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1143 ALTER TABLE t1 ADD INDEX (c1);
1144 SHOW TABLES;
1145 Tables_in_test
1146 t1
1147 SHOW CREATE TABLE t1;
1148 Table Create Table
1149 t1 CREATE TABLE `t1` (
1150 `c1` smallint NOT NULL,
1151 KEY `c1` (`c1`)
1152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1153 DROP TABLE t1;
1154 SHOW TABLES;
1155 Tables_in_test
1156 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1157 SHOW TABLES;
1158 Tables_in_test
1159 t1
1160 SHOW CREATE TABLE t1;
1161 Table Create Table
1162 t1 CREATE TABLE `t1` (
1163 `c1` mediumint NOT NULL
1164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1165 ALTER TABLE t1 ADD INDEX (c1);
1166 SHOW TABLES;
1167 Tables_in_test
1168 t1
1169 SHOW CREATE TABLE t1;
1170 Table Create Table
1171 t1 CREATE TABLE `t1` (
1172 `c1` mediumint NOT NULL,
1173 KEY `c1` (`c1`)
1174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1175 DROP TABLE t1;
1176 SHOW TABLES;
1177 Tables_in_test
1178 CREATE TABLE t1(c1 INT NOT NULL);
1179 SHOW TABLES;
1180 Tables_in_test
1181 t1
1182 SHOW CREATE TABLE t1;
1183 Table Create Table
1184 t1 CREATE TABLE `t1` (
1185 `c1` int NOT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1187 ALTER TABLE t1 ADD INDEX (c1);
1188 SHOW TABLES;
1189 Tables_in_test
1190 t1
1191 SHOW CREATE TABLE t1;
1192 Table Create Table
1193 t1 CREATE TABLE `t1` (
1194 `c1` int NOT NULL,
1195 KEY `c1` (`c1`)
1196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1197 DROP TABLE t1;
1198 SHOW TABLES;
1199 Tables_in_test
1200 CREATE TABLE t1(c1 INTEGER NOT NULL);
1201 SHOW TABLES;
1202 Tables_in_test
1203 t1
1204 SHOW CREATE TABLE t1;
1205 Table Create Table
1206 t1 CREATE TABLE `t1` (
1207 `c1` int NOT NULL
1208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1209 ALTER TABLE t1 ADD INDEX (c1);
1210 SHOW TABLES;
1211 Tables_in_test
1212 t1
1213 SHOW CREATE TABLE t1;
1214 Table Create Table
1215 t1 CREATE TABLE `t1` (
1216 `c1` int NOT NULL,
1217 KEY `c1` (`c1`)
1218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1219 DROP TABLE t1;
1220 SHOW TABLES;
1221 Tables_in_test
1222 CREATE TABLE t1(c1 BIGINT NOT NULL);
1223 SHOW TABLES;
1224 Tables_in_test
1225 t1
1226 SHOW CREATE TABLE t1;
1227 Table Create Table
1228 t1 CREATE TABLE `t1` (
1229 `c1` bigint NOT NULL
1230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1231 ALTER TABLE t1 ADD INDEX (c1);
1232 SHOW TABLES;
1233 Tables_in_test
1234 t1
1235 SHOW CREATE TABLE t1;
1236 Table Create Table
1237 t1 CREATE TABLE `t1` (
1238 `c1` bigint NOT NULL,
1239 KEY `c1` (`c1`)
1240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1241 DROP TABLE t1;
1242 SHOW TABLES;
1243 Tables_in_test
1244 CREATE TABLE t1(c1 REAL NOT NULL);
1245 SHOW TABLES;
1246 Tables_in_test
1247 t1
1248 SHOW CREATE TABLE t1;
1249 Table Create Table
1250 t1 CREATE TABLE `t1` (
1251 `c1` double NOT NULL
1252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1253 ALTER TABLE t1 ADD INDEX (c1);
1254 SHOW TABLES;
1255 Tables_in_test
1256 t1
1257 SHOW CREATE TABLE t1;
1258 Table Create Table
1259 t1 CREATE TABLE `t1` (
1260 `c1` double NOT NULL,
1261 KEY `c1` (`c1`)
1262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1263 DROP TABLE t1;
1264 SHOW TABLES;
1265 Tables_in_test
1266 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1267 SHOW TABLES;
1268 Tables_in_test
1269 t1
1270 SHOW CREATE TABLE t1;
1271 Table Create Table
1272 t1 CREATE TABLE `t1` (
1273 `c1` double NOT NULL
1274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1275 ALTER TABLE t1 ADD INDEX (c1);
1276 SHOW TABLES;
1277 Tables_in_test
1278 t1
1279 SHOW CREATE TABLE t1;
1280 Table Create Table
1281 t1 CREATE TABLE `t1` (
1282 `c1` double NOT NULL,
1283 KEY `c1` (`c1`)
1284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1285 DROP TABLE t1;
1286 SHOW TABLES;
1287 Tables_in_test
1288 CREATE TABLE t1(c1 FLOAT NOT NULL);
1289 SHOW TABLES;
1290 Tables_in_test
1291 t1
1292 SHOW CREATE TABLE t1;
1293 Table Create Table
1294 t1 CREATE TABLE `t1` (
1295 `c1` float NOT NULL
1296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1297 ALTER TABLE t1 ADD INDEX (c1);
1298 SHOW TABLES;
1299 Tables_in_test
1300 t1
1301 SHOW CREATE TABLE t1;
1302 Table Create Table
1303 t1 CREATE TABLE `t1` (
1304 `c1` float NOT NULL,
1305 KEY `c1` (`c1`)
1306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1307 DROP TABLE t1;
1308 SHOW TABLES;
1309 Tables_in_test
1310 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1311 SHOW TABLES;
1312 Tables_in_test
1313 t1
1314 SHOW CREATE TABLE t1;
1315 Table Create Table
1316 t1 CREATE TABLE `t1` (
1317 `c1` decimal(10,0) NOT NULL
1318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1319 ALTER TABLE t1 ADD INDEX (c1);
1320 SHOW TABLES;
1321 Tables_in_test
1322 t1
1323 SHOW CREATE TABLE t1;
1324 Table Create Table
1325 t1 CREATE TABLE `t1` (
1326 `c1` decimal(10,0) NOT NULL,
1327 KEY `c1` (`c1`)
1328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1329 DROP TABLE t1;
1330 SHOW TABLES;
1331 Tables_in_test
1332 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1333 SHOW TABLES;
1334 Tables_in_test
1335 t1
1336 SHOW CREATE TABLE t1;
1337 Table Create Table
1338 t1 CREATE TABLE `t1` (
1339 `c1` decimal(10,0) NOT NULL
1340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1341 ALTER TABLE t1 ADD INDEX (c1);
1342 SHOW TABLES;
1343 Tables_in_test
1344 t1
1345 SHOW CREATE TABLE t1;
1346 Table Create Table
1347 t1 CREATE TABLE `t1` (
1348 `c1` decimal(10,0) NOT NULL,
1349 KEY `c1` (`c1`)
1350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1351 DROP TABLE t1;
1352 SHOW TABLES;
1353 Tables_in_test
1354 CREATE TABLE t1(c1 DATE NOT NULL);
1355 SHOW TABLES;
1356 Tables_in_test
1357 t1
1358 SHOW CREATE TABLE t1;
1359 Table Create Table
1360 t1 CREATE TABLE `t1` (
1361 `c1` date NOT NULL
1362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1363 ALTER TABLE t1 ADD INDEX (c1);
1364 SHOW TABLES;
1365 Tables_in_test
1366 t1
1367 SHOW CREATE TABLE t1;
1368 Table Create Table
1369 t1 CREATE TABLE `t1` (
1370 `c1` date NOT NULL,
1371 KEY `c1` (`c1`)
1372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1373 DROP TABLE t1;
1374 SHOW TABLES;
1375 Tables_in_test
1376 CREATE TABLE t1(c1 TIME NOT NULL);
1377 SHOW TABLES;
1378 Tables_in_test
1379 t1
1380 SHOW CREATE TABLE t1;
1381 Table Create Table
1382 t1 CREATE TABLE `t1` (
1383 `c1` time NOT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1385 ALTER TABLE t1 ADD INDEX (c1);
1386 SHOW TABLES;
1387 Tables_in_test
1388 t1
1389 SHOW CREATE TABLE t1;
1390 Table Create Table
1391 t1 CREATE TABLE `t1` (
1392 `c1` time NOT NULL,
1393 KEY `c1` (`c1`)
1394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1395 DROP TABLE t1;
1396 SHOW TABLES;
1397 Tables_in_test
1398 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1399 SHOW TABLES;
1400 Tables_in_test
1401 t1
1402 SHOW CREATE TABLE t1;
1403 Table Create Table
1404 t1 CREATE TABLE `t1` (
1405 `c1` timestamp NOT NULL
1406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1407 ALTER TABLE t1 ADD INDEX (c1);
1408 SHOW TABLES;
1409 Tables_in_test
1410 t1
1411 SHOW CREATE TABLE t1;
1412 Table Create Table
1413 t1 CREATE TABLE `t1` (
1414 `c1` timestamp NOT NULL,
1415 KEY `c1` (`c1`)
1416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1417 DROP TABLE t1;
1418 SHOW TABLES;
1419 Tables_in_test
1420 CREATE TABLE t1(c1 YEAR NOT NULL);
1421 SHOW TABLES;
1422 Tables_in_test
1423 t1
1424 SHOW CREATE TABLE t1;
1425 Table Create Table
1426 t1 CREATE TABLE `t1` (
1427 `c1` year NOT NULL
1428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1429 ALTER TABLE t1 ADD INDEX (c1);
1430 SHOW TABLES;
1431 Tables_in_test
1432 t1
1433 SHOW CREATE TABLE t1;
1434 Table Create Table
1435 t1 CREATE TABLE `t1` (
1436 `c1` year NOT NULL,
1437 KEY `c1` (`c1`)
1438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1439 DROP TABLE t1;
1440 SHOW TABLES;
1441 Tables_in_test
1442 CREATE TABLE t1(c1 BIT NOT NULL);
1443 SHOW TABLES;
1444 Tables_in_test
1445 t1
1446 SHOW CREATE TABLE t1;
1447 Table Create Table
1448 t1 CREATE TABLE `t1` (
1449 `c1` bit(1) NOT NULL
1450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1451 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1452 SHOW TABLES;
1453 Tables_in_test
1454 t1
1455 SHOW CREATE TABLE t1;
1456 Table Create Table
1457 t1 CREATE TABLE `t1` (
1458 `c1` bit(1) NOT NULL,
1459 KEY `c1` (`c1`) USING BTREE
1460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1461 DROP TABLE t1;
1462 SHOW TABLES;
1463 Tables_in_test
1464 CREATE TABLE t1(c1 TINYINT NOT NULL);
1465 SHOW TABLES;
1466 Tables_in_test
1467 t1
1468 SHOW CREATE TABLE t1;
1469 Table Create Table
1470 t1 CREATE TABLE `t1` (
1471 `c1` tinyint NOT NULL
1472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1473 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1474 SHOW TABLES;
1475 Tables_in_test
1476 t1
1477 SHOW CREATE TABLE t1;
1478 Table Create Table
1479 t1 CREATE TABLE `t1` (
1480 `c1` tinyint NOT NULL,
1481 KEY `c1` (`c1`) USING BTREE
1482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1483 DROP TABLE t1;
1484 SHOW TABLES;
1485 Tables_in_test
1486 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1487 SHOW TABLES;
1488 Tables_in_test
1489 t1
1490 SHOW CREATE TABLE t1;
1491 Table Create Table
1492 t1 CREATE TABLE `t1` (
1493 `c1` smallint NOT NULL
1494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1495 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1496 SHOW TABLES;
1497 Tables_in_test
1498 t1
1499 SHOW CREATE TABLE t1;
1500 Table Create Table
1501 t1 CREATE TABLE `t1` (
1502 `c1` smallint NOT NULL,
1503 KEY `c1` (`c1`) USING BTREE
1504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1505 DROP TABLE t1;
1506 SHOW TABLES;
1507 Tables_in_test
1508 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1509 SHOW TABLES;
1510 Tables_in_test
1511 t1
1512 SHOW CREATE TABLE t1;
1513 Table Create Table
1514 t1 CREATE TABLE `t1` (
1515 `c1` mediumint NOT NULL
1516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1517 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1518 SHOW TABLES;
1519 Tables_in_test
1520 t1
1521 SHOW CREATE TABLE t1;
1522 Table Create Table
1523 t1 CREATE TABLE `t1` (
1524 `c1` mediumint NOT NULL,
1525 KEY `c1` (`c1`) USING BTREE
1526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1527 DROP TABLE t1;
1528 SHOW TABLES;
1529 Tables_in_test
1530 CREATE TABLE t1(c1 INT NOT NULL);
1531 SHOW TABLES;
1532 Tables_in_test
1533 t1
1534 SHOW CREATE TABLE t1;
1535 Table Create Table
1536 t1 CREATE TABLE `t1` (
1537 `c1` int NOT NULL
1538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1539 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1540 SHOW TABLES;
1541 Tables_in_test
1542 t1
1543 SHOW CREATE TABLE t1;
1544 Table Create Table
1545 t1 CREATE TABLE `t1` (
1546 `c1` int NOT NULL,
1547 KEY `c1` (`c1`) USING BTREE
1548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1549 DROP TABLE t1;
1550 SHOW TABLES;
1551 Tables_in_test
1552 CREATE TABLE t1(c1 INTEGER NOT NULL);
1553 SHOW TABLES;
1554 Tables_in_test
1555 t1
1556 SHOW CREATE TABLE t1;
1557 Table Create Table
1558 t1 CREATE TABLE `t1` (
1559 `c1` int NOT NULL
1560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1561 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1562 SHOW TABLES;
1563 Tables_in_test
1564 t1
1565 SHOW CREATE TABLE t1;
1566 Table Create Table
1567 t1 CREATE TABLE `t1` (
1568 `c1` int NOT NULL,
1569 KEY `c1` (`c1`) USING BTREE
1570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1571 DROP TABLE t1;
1572 SHOW TABLES;
1573 Tables_in_test
1574 CREATE TABLE t1(c1 BIGINT NOT NULL);
1575 SHOW TABLES;
1576 Tables_in_test
1577 t1
1578 SHOW CREATE TABLE t1;
1579 Table Create Table
1580 t1 CREATE TABLE `t1` (
1581 `c1` bigint NOT NULL
1582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1584 SHOW TABLES;
1585 Tables_in_test
1586 t1
1587 SHOW CREATE TABLE t1;
1588 Table Create Table
1589 t1 CREATE TABLE `t1` (
1590 `c1` bigint NOT NULL,
1591 KEY `c1` (`c1`) USING BTREE
1592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1593 DROP TABLE t1;
1594 SHOW TABLES;
1595 Tables_in_test
1596 CREATE TABLE t1(c1 REAL NOT NULL);
1597 SHOW TABLES;
1598 Tables_in_test
1599 t1
1600 SHOW CREATE TABLE t1;
1601 Table Create Table
1602 t1 CREATE TABLE `t1` (
1603 `c1` double NOT NULL
1604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1605 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1606 SHOW TABLES;
1607 Tables_in_test
1608 t1
1609 SHOW CREATE TABLE t1;
1610 Table Create Table
1611 t1 CREATE TABLE `t1` (
1612 `c1` double NOT NULL,
1613 KEY `c1` (`c1`) USING BTREE
1614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1615 DROP TABLE t1;
1616 SHOW TABLES;
1617 Tables_in_test
1618 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1619 SHOW TABLES;
1620 Tables_in_test
1621 t1
1622 SHOW CREATE TABLE t1;
1623 Table Create Table
1624 t1 CREATE TABLE `t1` (
1625 `c1` double NOT NULL
1626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1627 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1628 SHOW TABLES;
1629 Tables_in_test
1630 t1
1631 SHOW CREATE TABLE t1;
1632 Table Create Table
1633 t1 CREATE TABLE `t1` (
1634 `c1` double NOT NULL,
1635 KEY `c1` (`c1`) USING BTREE
1636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1637 DROP TABLE t1;
1638 SHOW TABLES;
1639 Tables_in_test
1640 CREATE TABLE t1(c1 FLOAT NOT NULL);
1641 SHOW TABLES;
1642 Tables_in_test
1643 t1
1644 SHOW CREATE TABLE t1;
1645 Table Create Table
1646 t1 CREATE TABLE `t1` (
1647 `c1` float NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1649 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1650 SHOW TABLES;
1651 Tables_in_test
1652 t1
1653 SHOW CREATE TABLE t1;
1654 Table Create Table
1655 t1 CREATE TABLE `t1` (
1656 `c1` float NOT NULL,
1657 KEY `c1` (`c1`) USING BTREE
1658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1659 DROP TABLE t1;
1660 SHOW TABLES;
1661 Tables_in_test
1662 CREATE TABLE t1(c1 DECIMAL NOT NULL);
1663 SHOW TABLES;
1664 Tables_in_test
1665 t1
1666 SHOW CREATE TABLE t1;
1667 Table Create Table
1668 t1 CREATE TABLE `t1` (
1669 `c1` decimal(10,0) NOT NULL
1670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1671 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1672 SHOW TABLES;
1673 Tables_in_test
1674 t1
1675 SHOW CREATE TABLE t1;
1676 Table Create Table
1677 t1 CREATE TABLE `t1` (
1678 `c1` decimal(10,0) NOT NULL,
1679 KEY `c1` (`c1`) USING BTREE
1680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1681 DROP TABLE t1;
1682 SHOW TABLES;
1683 Tables_in_test
1684 CREATE TABLE t1(c1 NUMERIC NOT NULL);
1685 SHOW TABLES;
1686 Tables_in_test
1687 t1
1688 SHOW CREATE TABLE t1;
1689 Table Create Table
1690 t1 CREATE TABLE `t1` (
1691 `c1` decimal(10,0) NOT NULL
1692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1693 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1694 SHOW TABLES;
1695 Tables_in_test
1696 t1
1697 SHOW CREATE TABLE t1;
1698 Table Create Table
1699 t1 CREATE TABLE `t1` (
1700 `c1` decimal(10,0) NOT NULL,
1701 KEY `c1` (`c1`) USING BTREE
1702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1703 DROP TABLE t1;
1704 SHOW TABLES;
1705 Tables_in_test
1706 CREATE TABLE t1(c1 DATE NOT NULL);
1707 SHOW TABLES;
1708 Tables_in_test
1709 t1
1710 SHOW CREATE TABLE t1;
1711 Table Create Table
1712 t1 CREATE TABLE `t1` (
1713 `c1` date NOT NULL
1714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1715 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1716 SHOW TABLES;
1717 Tables_in_test
1718 t1
1719 SHOW CREATE TABLE t1;
1720 Table Create Table
1721 t1 CREATE TABLE `t1` (
1722 `c1` date NOT NULL,
1723 KEY `c1` (`c1`) USING BTREE
1724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1725 DROP TABLE t1;
1726 SHOW TABLES;
1727 Tables_in_test
1728 CREATE TABLE t1(c1 TIME NOT NULL);
1729 SHOW TABLES;
1730 Tables_in_test
1731 t1
1732 SHOW CREATE TABLE t1;
1733 Table Create Table
1734 t1 CREATE TABLE `t1` (
1735 `c1` time NOT NULL
1736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1737 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1738 SHOW TABLES;
1739 Tables_in_test
1740 t1
1741 SHOW CREATE TABLE t1;
1742 Table Create Table
1743 t1 CREATE TABLE `t1` (
1744 `c1` time NOT NULL,
1745 KEY `c1` (`c1`) USING BTREE
1746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1747 DROP TABLE t1;
1748 SHOW TABLES;
1749 Tables_in_test
1750 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
1751 SHOW TABLES;
1752 Tables_in_test
1753 t1
1754 SHOW CREATE TABLE t1;
1755 Table Create Table
1756 t1 CREATE TABLE `t1` (
1757 `c1` timestamp NOT NULL
1758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1759 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1760 SHOW TABLES;
1761 Tables_in_test
1762 t1
1763 SHOW CREATE TABLE t1;
1764 Table Create Table
1765 t1 CREATE TABLE `t1` (
1766 `c1` timestamp NOT NULL,
1767 KEY `c1` (`c1`) USING BTREE
1768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1769 DROP TABLE t1;
1770 SHOW TABLES;
1771 Tables_in_test
1772 CREATE TABLE t1(c1 YEAR NOT NULL);
1773 SHOW TABLES;
1774 Tables_in_test
1775 t1
1776 SHOW CREATE TABLE t1;
1777 Table Create Table
1778 t1 CREATE TABLE `t1` (
1779 `c1` year NOT NULL
1780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1781 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
1782 SHOW TABLES;
1783 Tables_in_test
1784 t1
1785 SHOW CREATE TABLE t1;
1786 Table Create Table
1787 t1 CREATE TABLE `t1` (
1788 `c1` year NOT NULL,
1789 KEY `c1` (`c1`) USING BTREE
1790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1791 DROP TABLE t1;
1792 SHOW TABLES;
1793 Tables_in_test
1794 CREATE TABLE t1(c1 BIT NOT NULL);
1795 SHOW TABLES;
1796 Tables_in_test
1797 t1
1798 SHOW CREATE TABLE t1;
1799 Table Create Table
1800 t1 CREATE TABLE `t1` (
1801 `c1` bit(1) NOT NULL
1802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1803 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1804 Warnings:
1805 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1806 SHOW TABLES;
1807 Tables_in_test
1808 t1
1809 SHOW CREATE TABLE t1;
1810 Table Create Table
1811 t1 CREATE TABLE `t1` (
1812 `c1` bit(1) NOT NULL,
1813 KEY `c1` (`c1`)
1814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1815 DROP TABLE t1;
1816 SHOW TABLES;
1817 Tables_in_test
1818 CREATE TABLE t1(c1 TINYINT NOT NULL);
1819 SHOW TABLES;
1820 Tables_in_test
1821 t1
1822 SHOW CREATE TABLE t1;
1823 Table Create Table
1824 t1 CREATE TABLE `t1` (
1825 `c1` tinyint NOT NULL
1826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1827 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1828 Warnings:
1829 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1830 SHOW TABLES;
1831 Tables_in_test
1832 t1
1833 SHOW CREATE TABLE t1;
1834 Table Create Table
1835 t1 CREATE TABLE `t1` (
1836 `c1` tinyint NOT NULL,
1837 KEY `c1` (`c1`)
1838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1839 DROP TABLE t1;
1840 SHOW TABLES;
1841 Tables_in_test
1842 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1843 SHOW TABLES;
1844 Tables_in_test
1845 t1
1846 SHOW CREATE TABLE t1;
1847 Table Create Table
1848 t1 CREATE TABLE `t1` (
1849 `c1` smallint NOT NULL
1850 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1851 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1852 Warnings:
1853 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1854 SHOW TABLES;
1855 Tables_in_test
1856 t1
1857 SHOW CREATE TABLE t1;
1858 Table Create Table
1859 t1 CREATE TABLE `t1` (
1860 `c1` smallint NOT NULL,
1861 KEY `c1` (`c1`)
1862 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1863 DROP TABLE t1;
1864 SHOW TABLES;
1865 Tables_in_test
1866 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1867 SHOW TABLES;
1868 Tables_in_test
1869 t1
1870 SHOW CREATE TABLE t1;
1871 Table Create Table
1872 t1 CREATE TABLE `t1` (
1873 `c1` mediumint NOT NULL
1874 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1875 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1876 Warnings:
1877 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1878 SHOW TABLES;
1879 Tables_in_test
1880 t1
1881 SHOW CREATE TABLE t1;
1882 Table Create Table
1883 t1 CREATE TABLE `t1` (
1884 `c1` mediumint NOT NULL,
1885 KEY `c1` (`c1`)
1886 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1887 DROP TABLE t1;
1888 SHOW TABLES;
1889 Tables_in_test
1890 CREATE TABLE t1(c1 INT NOT NULL);
1891 SHOW TABLES;
1892 Tables_in_test
1893 t1
1894 SHOW CREATE TABLE t1;
1895 Table Create Table
1896 t1 CREATE TABLE `t1` (
1897 `c1` int NOT NULL
1898 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1899 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1900 Warnings:
1901 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1902 SHOW TABLES;
1903 Tables_in_test
1904 t1
1905 SHOW CREATE TABLE t1;
1906 Table Create Table
1907 t1 CREATE TABLE `t1` (
1908 `c1` int NOT NULL,
1909 KEY `c1` (`c1`)
1910 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1911 DROP TABLE t1;
1912 SHOW TABLES;
1913 Tables_in_test
1914 CREATE TABLE t1(c1 INTEGER NOT NULL);
1915 SHOW TABLES;
1916 Tables_in_test
1917 t1
1918 SHOW CREATE TABLE t1;
1919 Table Create Table
1920 t1 CREATE TABLE `t1` (
1921 `c1` int NOT NULL
1922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1923 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1924 Warnings:
1925 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1926 SHOW TABLES;
1927 Tables_in_test
1928 t1
1929 SHOW CREATE TABLE t1;
1930 Table Create Table
1931 t1 CREATE TABLE `t1` (
1932 `c1` int NOT NULL,
1933 KEY `c1` (`c1`)
1934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1935 DROP TABLE t1;
1936 SHOW TABLES;
1937 Tables_in_test
1938 CREATE TABLE t1(c1 BIGINT NOT NULL);
1939 SHOW TABLES;
1940 Tables_in_test
1941 t1
1942 SHOW CREATE TABLE t1;
1943 Table Create Table
1944 t1 CREATE TABLE `t1` (
1945 `c1` bigint NOT NULL
1946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1947 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1948 Warnings:
1949 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1950 SHOW TABLES;
1951 Tables_in_test
1952 t1
1953 SHOW CREATE TABLE t1;
1954 Table Create Table
1955 t1 CREATE TABLE `t1` (
1956 `c1` bigint NOT NULL,
1957 KEY `c1` (`c1`)
1958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1959 DROP TABLE t1;
1960 SHOW TABLES;
1961 Tables_in_test
1962 CREATE TABLE t1(c1 REAL NOT NULL);
1963 SHOW TABLES;
1964 Tables_in_test
1965 t1
1966 SHOW CREATE TABLE t1;
1967 Table Create Table
1968 t1 CREATE TABLE `t1` (
1969 `c1` double NOT NULL
1970 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1971 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1972 Warnings:
1973 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1974 SHOW TABLES;
1975 Tables_in_test
1976 t1
1977 SHOW CREATE TABLE t1;
1978 Table Create Table
1979 t1 CREATE TABLE `t1` (
1980 `c1` double NOT NULL,
1981 KEY `c1` (`c1`)
1982 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1983 DROP TABLE t1;
1984 SHOW TABLES;
1985 Tables_in_test
1986 CREATE TABLE t1(c1 DOUBLE NOT NULL);
1987 SHOW TABLES;
1988 Tables_in_test
1989 t1
1990 SHOW CREATE TABLE t1;
1991 Table Create Table
1992 t1 CREATE TABLE `t1` (
1993 `c1` double NOT NULL
1994 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1995 ALTER TABLE t1 ADD INDEX USING HASH (c1);
1996 Warnings:
1997 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
1998 SHOW TABLES;
1999 Tables_in_test
2000 t1
2001 SHOW CREATE TABLE t1;
2002 Table Create Table
2003 t1 CREATE TABLE `t1` (
2004 `c1` double NOT NULL,
2005 KEY `c1` (`c1`)
2006 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2007 DROP TABLE t1;
2008 SHOW TABLES;
2009 Tables_in_test
2010 CREATE TABLE t1(c1 FLOAT NOT NULL);
2011 SHOW TABLES;
2012 Tables_in_test
2013 t1
2014 SHOW CREATE TABLE t1;
2015 Table Create Table
2016 t1 CREATE TABLE `t1` (
2017 `c1` float NOT NULL
2018 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2019 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2020 Warnings:
2021 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2022 SHOW TABLES;
2023 Tables_in_test
2024 t1
2025 SHOW CREATE TABLE t1;
2026 Table Create Table
2027 t1 CREATE TABLE `t1` (
2028 `c1` float NOT NULL,
2029 KEY `c1` (`c1`)
2030 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2031 DROP TABLE t1;
2032 SHOW TABLES;
2033 Tables_in_test
2034 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2035 SHOW TABLES;
2036 Tables_in_test
2037 t1
2038 SHOW CREATE TABLE t1;
2039 Table Create Table
2040 t1 CREATE TABLE `t1` (
2041 `c1` decimal(10,0) NOT NULL
2042 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2043 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2044 Warnings:
2045 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2046 SHOW TABLES;
2047 Tables_in_test
2048 t1
2049 SHOW CREATE TABLE t1;
2050 Table Create Table
2051 t1 CREATE TABLE `t1` (
2052 `c1` decimal(10,0) NOT NULL,
2053 KEY `c1` (`c1`)
2054 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2055 DROP TABLE t1;
2056 SHOW TABLES;
2057 Tables_in_test
2058 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2059 SHOW TABLES;
2060 Tables_in_test
2061 t1
2062 SHOW CREATE TABLE t1;
2063 Table Create Table
2064 t1 CREATE TABLE `t1` (
2065 `c1` decimal(10,0) NOT NULL
2066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2067 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2068 Warnings:
2069 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2070 SHOW TABLES;
2071 Tables_in_test
2072 t1
2073 SHOW CREATE TABLE t1;
2074 Table Create Table
2075 t1 CREATE TABLE `t1` (
2076 `c1` decimal(10,0) NOT NULL,
2077 KEY `c1` (`c1`)
2078 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2079 DROP TABLE t1;
2080 SHOW TABLES;
2081 Tables_in_test
2082 CREATE TABLE t1(c1 DATE NOT NULL);
2083 SHOW TABLES;
2084 Tables_in_test
2085 t1
2086 SHOW CREATE TABLE t1;
2087 Table Create Table
2088 t1 CREATE TABLE `t1` (
2089 `c1` date NOT NULL
2090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2091 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2092 Warnings:
2093 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2094 SHOW TABLES;
2095 Tables_in_test
2096 t1
2097 SHOW CREATE TABLE t1;
2098 Table Create Table
2099 t1 CREATE TABLE `t1` (
2100 `c1` date NOT NULL,
2101 KEY `c1` (`c1`)
2102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2103 DROP TABLE t1;
2104 SHOW TABLES;
2105 Tables_in_test
2106 CREATE TABLE t1(c1 TIME NOT NULL);
2107 SHOW TABLES;
2108 Tables_in_test
2109 t1
2110 SHOW CREATE TABLE t1;
2111 Table Create Table
2112 t1 CREATE TABLE `t1` (
2113 `c1` time NOT NULL
2114 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2115 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2116 Warnings:
2117 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2118 SHOW TABLES;
2119 Tables_in_test
2120 t1
2121 SHOW CREATE TABLE t1;
2122 Table Create Table
2123 t1 CREATE TABLE `t1` (
2124 `c1` time NOT NULL,
2125 KEY `c1` (`c1`)
2126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2127 DROP TABLE t1;
2128 SHOW TABLES;
2129 Tables_in_test
2130 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2131 SHOW TABLES;
2132 Tables_in_test
2133 t1
2134 SHOW CREATE TABLE t1;
2135 Table Create Table
2136 t1 CREATE TABLE `t1` (
2137 `c1` timestamp NOT NULL
2138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2139 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2140 Warnings:
2141 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2142 SHOW TABLES;
2143 Tables_in_test
2144 t1
2145 SHOW CREATE TABLE t1;
2146 Table Create Table
2147 t1 CREATE TABLE `t1` (
2148 `c1` timestamp NOT NULL,
2149 KEY `c1` (`c1`)
2150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2151 DROP TABLE t1;
2152 SHOW TABLES;
2153 Tables_in_test
2154 CREATE TABLE t1(c1 YEAR NOT NULL);
2155 SHOW TABLES;
2156 Tables_in_test
2157 t1
2158 SHOW CREATE TABLE t1;
2159 Table Create Table
2160 t1 CREATE TABLE `t1` (
2161 `c1` year NOT NULL
2162 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2163 ALTER TABLE t1 ADD INDEX USING HASH (c1);
2164 Warnings:
2165 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2166 SHOW TABLES;
2167 Tables_in_test
2168 t1
2169 SHOW CREATE TABLE t1;
2170 Table Create Table
2171 t1 CREATE TABLE `t1` (
2172 `c1` year NOT NULL,
2173 KEY `c1` (`c1`)
2174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2175 DROP TABLE t1;
2176 SHOW TABLES;
2177 Tables_in_test
2178 CREATE TABLE t1(c1 BIT NOT NULL);
2179 SHOW TABLES;
2180 Tables_in_test
2181 t1
2182 SHOW CREATE TABLE t1;
2183 Table Create Table
2184 t1 CREATE TABLE `t1` (
2185 `c1` bit(1) NOT NULL
2186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2187 ALTER TABLE t1 ADD KEY i1 (c1);
2188 SHOW TABLES;
2189 Tables_in_test
2190 t1
2191 SHOW CREATE TABLE t1;
2192 Table Create Table
2193 t1 CREATE TABLE `t1` (
2194 `c1` bit(1) NOT NULL,
2195 KEY `i1` (`c1`)
2196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2197 DROP TABLE t1;
2198 SHOW TABLES;
2199 Tables_in_test
2200 CREATE TABLE t1(c1 TINYINT NOT NULL);
2201 SHOW TABLES;
2202 Tables_in_test
2203 t1
2204 SHOW CREATE TABLE t1;
2205 Table Create Table
2206 t1 CREATE TABLE `t1` (
2207 `c1` tinyint NOT NULL
2208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2209 ALTER TABLE t1 ADD KEY i1 (c1);
2210 SHOW TABLES;
2211 Tables_in_test
2212 t1
2213 SHOW CREATE TABLE t1;
2214 Table Create Table
2215 t1 CREATE TABLE `t1` (
2216 `c1` tinyint NOT NULL,
2217 KEY `i1` (`c1`)
2218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2219 DROP TABLE t1;
2220 SHOW TABLES;
2221 Tables_in_test
2222 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2223 SHOW TABLES;
2224 Tables_in_test
2225 t1
2226 SHOW CREATE TABLE t1;
2227 Table Create Table
2228 t1 CREATE TABLE `t1` (
2229 `c1` smallint NOT NULL
2230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2231 ALTER TABLE t1 ADD KEY i1 (c1);
2232 SHOW TABLES;
2233 Tables_in_test
2234 t1
2235 SHOW CREATE TABLE t1;
2236 Table Create Table
2237 t1 CREATE TABLE `t1` (
2238 `c1` smallint NOT NULL,
2239 KEY `i1` (`c1`)
2240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2241 DROP TABLE t1;
2242 SHOW TABLES;
2243 Tables_in_test
2244 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2245 SHOW TABLES;
2246 Tables_in_test
2247 t1
2248 SHOW CREATE TABLE t1;
2249 Table Create Table
2250 t1 CREATE TABLE `t1` (
2251 `c1` mediumint NOT NULL
2252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2253 ALTER TABLE t1 ADD KEY i1 (c1);
2254 SHOW TABLES;
2255 Tables_in_test
2256 t1
2257 SHOW CREATE TABLE t1;
2258 Table Create Table
2259 t1 CREATE TABLE `t1` (
2260 `c1` mediumint NOT NULL,
2261 KEY `i1` (`c1`)
2262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2263 DROP TABLE t1;
2264 SHOW TABLES;
2265 Tables_in_test
2266 CREATE TABLE t1(c1 INT NOT NULL);
2267 SHOW TABLES;
2268 Tables_in_test
2269 t1
2270 SHOW CREATE TABLE t1;
2271 Table Create Table
2272 t1 CREATE TABLE `t1` (
2273 `c1` int NOT NULL
2274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2275 ALTER TABLE t1 ADD KEY i1 (c1);
2276 SHOW TABLES;
2277 Tables_in_test
2278 t1
2279 SHOW CREATE TABLE t1;
2280 Table Create Table
2281 t1 CREATE TABLE `t1` (
2282 `c1` int NOT NULL,
2283 KEY `i1` (`c1`)
2284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2285 DROP TABLE t1;
2286 SHOW TABLES;
2287 Tables_in_test
2288 CREATE TABLE t1(c1 INTEGER NOT NULL);
2289 SHOW TABLES;
2290 Tables_in_test
2291 t1
2292 SHOW CREATE TABLE t1;
2293 Table Create Table
2294 t1 CREATE TABLE `t1` (
2295 `c1` int NOT NULL
2296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2297 ALTER TABLE t1 ADD KEY i1 (c1);
2298 SHOW TABLES;
2299 Tables_in_test
2300 t1
2301 SHOW CREATE TABLE t1;
2302 Table Create Table
2303 t1 CREATE TABLE `t1` (
2304 `c1` int NOT NULL,
2305 KEY `i1` (`c1`)
2306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2307 DROP TABLE t1;
2308 SHOW TABLES;
2309 Tables_in_test
2310 CREATE TABLE t1(c1 BIGINT NOT NULL);
2311 SHOW TABLES;
2312 Tables_in_test
2313 t1
2314 SHOW CREATE TABLE t1;
2315 Table Create Table
2316 t1 CREATE TABLE `t1` (
2317 `c1` bigint NOT NULL
2318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2319 ALTER TABLE t1 ADD KEY i1 (c1);
2320 SHOW TABLES;
2321 Tables_in_test
2322 t1
2323 SHOW CREATE TABLE t1;
2324 Table Create Table
2325 t1 CREATE TABLE `t1` (
2326 `c1` bigint NOT NULL,
2327 KEY `i1` (`c1`)
2328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2329 DROP TABLE t1;
2330 SHOW TABLES;
2331 Tables_in_test
2332 CREATE TABLE t1(c1 REAL NOT NULL);
2333 SHOW TABLES;
2334 Tables_in_test
2335 t1
2336 SHOW CREATE TABLE t1;
2337 Table Create Table
2338 t1 CREATE TABLE `t1` (
2339 `c1` double NOT NULL
2340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2341 ALTER TABLE t1 ADD KEY i1 (c1);
2342 SHOW TABLES;
2343 Tables_in_test
2344 t1
2345 SHOW CREATE TABLE t1;
2346 Table Create Table
2347 t1 CREATE TABLE `t1` (
2348 `c1` double NOT NULL,
2349 KEY `i1` (`c1`)
2350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2351 DROP TABLE t1;
2352 SHOW TABLES;
2353 Tables_in_test
2354 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2355 SHOW TABLES;
2356 Tables_in_test
2357 t1
2358 SHOW CREATE TABLE t1;
2359 Table Create Table
2360 t1 CREATE TABLE `t1` (
2361 `c1` double NOT NULL
2362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2363 ALTER TABLE t1 ADD KEY i1 (c1);
2364 SHOW TABLES;
2365 Tables_in_test
2366 t1
2367 SHOW CREATE TABLE t1;
2368 Table Create Table
2369 t1 CREATE TABLE `t1` (
2370 `c1` double NOT NULL,
2371 KEY `i1` (`c1`)
2372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2373 DROP TABLE t1;
2374 SHOW TABLES;
2375 Tables_in_test
2376 CREATE TABLE t1(c1 FLOAT NOT NULL);
2377 SHOW TABLES;
2378 Tables_in_test
2379 t1
2380 SHOW CREATE TABLE t1;
2381 Table Create Table
2382 t1 CREATE TABLE `t1` (
2383 `c1` float NOT NULL
2384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2385 ALTER TABLE t1 ADD KEY i1 (c1);
2386 SHOW TABLES;
2387 Tables_in_test
2388 t1
2389 SHOW CREATE TABLE t1;
2390 Table Create Table
2391 t1 CREATE TABLE `t1` (
2392 `c1` float NOT NULL,
2393 KEY `i1` (`c1`)
2394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2395 DROP TABLE t1;
2396 SHOW TABLES;
2397 Tables_in_test
2398 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2399 SHOW TABLES;
2400 Tables_in_test
2401 t1
2402 SHOW CREATE TABLE t1;
2403 Table Create Table
2404 t1 CREATE TABLE `t1` (
2405 `c1` decimal(10,0) NOT NULL
2406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2407 ALTER TABLE t1 ADD KEY i1 (c1);
2408 SHOW TABLES;
2409 Tables_in_test
2410 t1
2411 SHOW CREATE TABLE t1;
2412 Table Create Table
2413 t1 CREATE TABLE `t1` (
2414 `c1` decimal(10,0) NOT NULL,
2415 KEY `i1` (`c1`)
2416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2417 DROP TABLE t1;
2418 SHOW TABLES;
2419 Tables_in_test
2420 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2421 SHOW TABLES;
2422 Tables_in_test
2423 t1
2424 SHOW CREATE TABLE t1;
2425 Table Create Table
2426 t1 CREATE TABLE `t1` (
2427 `c1` decimal(10,0) NOT NULL
2428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2429 ALTER TABLE t1 ADD KEY i1 (c1);
2430 SHOW TABLES;
2431 Tables_in_test
2432 t1
2433 SHOW CREATE TABLE t1;
2434 Table Create Table
2435 t1 CREATE TABLE `t1` (
2436 `c1` decimal(10,0) NOT NULL,
2437 KEY `i1` (`c1`)
2438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2439 DROP TABLE t1;
2440 SHOW TABLES;
2441 Tables_in_test
2442 CREATE TABLE t1(c1 DATE NOT NULL);
2443 SHOW TABLES;
2444 Tables_in_test
2445 t1
2446 SHOW CREATE TABLE t1;
2447 Table Create Table
2448 t1 CREATE TABLE `t1` (
2449 `c1` date NOT NULL
2450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2451 ALTER TABLE t1 ADD KEY i1 (c1);
2452 SHOW TABLES;
2453 Tables_in_test
2454 t1
2455 SHOW CREATE TABLE t1;
2456 Table Create Table
2457 t1 CREATE TABLE `t1` (
2458 `c1` date NOT NULL,
2459 KEY `i1` (`c1`)
2460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2461 DROP TABLE t1;
2462 SHOW TABLES;
2463 Tables_in_test
2464 CREATE TABLE t1(c1 TIME NOT NULL);
2465 SHOW TABLES;
2466 Tables_in_test
2467 t1
2468 SHOW CREATE TABLE t1;
2469 Table Create Table
2470 t1 CREATE TABLE `t1` (
2471 `c1` time NOT NULL
2472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2473 ALTER TABLE t1 ADD KEY i1 (c1);
2474 SHOW TABLES;
2475 Tables_in_test
2476 t1
2477 SHOW CREATE TABLE t1;
2478 Table Create Table
2479 t1 CREATE TABLE `t1` (
2480 `c1` time NOT NULL,
2481 KEY `i1` (`c1`)
2482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2483 DROP TABLE t1;
2484 SHOW TABLES;
2485 Tables_in_test
2486 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2487 SHOW TABLES;
2488 Tables_in_test
2489 t1
2490 SHOW CREATE TABLE t1;
2491 Table Create Table
2492 t1 CREATE TABLE `t1` (
2493 `c1` timestamp NOT NULL
2494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2495 ALTER TABLE t1 ADD KEY i1 (c1);
2496 SHOW TABLES;
2497 Tables_in_test
2498 t1
2499 SHOW CREATE TABLE t1;
2500 Table Create Table
2501 t1 CREATE TABLE `t1` (
2502 `c1` timestamp NOT NULL,
2503 KEY `i1` (`c1`)
2504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2505 DROP TABLE t1;
2506 SHOW TABLES;
2507 Tables_in_test
2508 CREATE TABLE t1(c1 YEAR NOT NULL);
2509 SHOW TABLES;
2510 Tables_in_test
2511 t1
2512 SHOW CREATE TABLE t1;
2513 Table Create Table
2514 t1 CREATE TABLE `t1` (
2515 `c1` year NOT NULL
2516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2517 ALTER TABLE t1 ADD KEY i1 (c1);
2518 SHOW TABLES;
2519 Tables_in_test
2520 t1
2521 SHOW CREATE TABLE t1;
2522 Table Create Table
2523 t1 CREATE TABLE `t1` (
2524 `c1` year NOT NULL,
2525 KEY `i1` (`c1`)
2526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2527 DROP TABLE t1;
2528 SHOW TABLES;
2529 Tables_in_test
2530 CREATE TABLE t1(c1 BIT NOT NULL);
2531 SHOW TABLES;
2532 Tables_in_test
2533 t1
2534 SHOW CREATE TABLE t1;
2535 Table Create Table
2536 t1 CREATE TABLE `t1` (
2537 `c1` bit(1) NOT NULL
2538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2539 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2540 SHOW TABLES;
2541 Tables_in_test
2542 t1
2543 SHOW CREATE TABLE t1;
2544 Table Create Table
2545 t1 CREATE TABLE `t1` (
2546 `c1` bit(1) NOT NULL,
2547 KEY `i1` (`c1`) USING BTREE
2548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2549 DROP TABLE t1;
2550 SHOW TABLES;
2551 Tables_in_test
2552 CREATE TABLE t1(c1 TINYINT NOT NULL);
2553 SHOW TABLES;
2554 Tables_in_test
2555 t1
2556 SHOW CREATE TABLE t1;
2557 Table Create Table
2558 t1 CREATE TABLE `t1` (
2559 `c1` tinyint NOT NULL
2560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2561 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2562 SHOW TABLES;
2563 Tables_in_test
2564 t1
2565 SHOW CREATE TABLE t1;
2566 Table Create Table
2567 t1 CREATE TABLE `t1` (
2568 `c1` tinyint NOT NULL,
2569 KEY `i1` (`c1`) USING BTREE
2570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2571 DROP TABLE t1;
2572 SHOW TABLES;
2573 Tables_in_test
2574 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2575 SHOW TABLES;
2576 Tables_in_test
2577 t1
2578 SHOW CREATE TABLE t1;
2579 Table Create Table
2580 t1 CREATE TABLE `t1` (
2581 `c1` smallint NOT NULL
2582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2583 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2584 SHOW TABLES;
2585 Tables_in_test
2586 t1
2587 SHOW CREATE TABLE t1;
2588 Table Create Table
2589 t1 CREATE TABLE `t1` (
2590 `c1` smallint NOT NULL,
2591 KEY `i1` (`c1`) USING BTREE
2592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2593 DROP TABLE t1;
2594 SHOW TABLES;
2595 Tables_in_test
2596 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2597 SHOW TABLES;
2598 Tables_in_test
2599 t1
2600 SHOW CREATE TABLE t1;
2601 Table Create Table
2602 t1 CREATE TABLE `t1` (
2603 `c1` mediumint NOT NULL
2604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2605 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2606 SHOW TABLES;
2607 Tables_in_test
2608 t1
2609 SHOW CREATE TABLE t1;
2610 Table Create Table
2611 t1 CREATE TABLE `t1` (
2612 `c1` mediumint NOT NULL,
2613 KEY `i1` (`c1`) USING BTREE
2614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2615 DROP TABLE t1;
2616 SHOW TABLES;
2617 Tables_in_test
2618 CREATE TABLE t1(c1 INT NOT NULL);
2619 SHOW TABLES;
2620 Tables_in_test
2621 t1
2622 SHOW CREATE TABLE t1;
2623 Table Create Table
2624 t1 CREATE TABLE `t1` (
2625 `c1` int NOT NULL
2626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2627 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2628 SHOW TABLES;
2629 Tables_in_test
2630 t1
2631 SHOW CREATE TABLE t1;
2632 Table Create Table
2633 t1 CREATE TABLE `t1` (
2634 `c1` int NOT NULL,
2635 KEY `i1` (`c1`) USING BTREE
2636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2637 DROP TABLE t1;
2638 SHOW TABLES;
2639 Tables_in_test
2640 CREATE TABLE t1(c1 INTEGER NOT NULL);
2641 SHOW TABLES;
2642 Tables_in_test
2643 t1
2644 SHOW CREATE TABLE t1;
2645 Table Create Table
2646 t1 CREATE TABLE `t1` (
2647 `c1` int NOT NULL
2648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2649 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2650 SHOW TABLES;
2651 Tables_in_test
2652 t1
2653 SHOW CREATE TABLE t1;
2654 Table Create Table
2655 t1 CREATE TABLE `t1` (
2656 `c1` int NOT NULL,
2657 KEY `i1` (`c1`) USING BTREE
2658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2659 DROP TABLE t1;
2660 SHOW TABLES;
2661 Tables_in_test
2662 CREATE TABLE t1(c1 BIGINT NOT NULL);
2663 SHOW TABLES;
2664 Tables_in_test
2665 t1
2666 SHOW CREATE TABLE t1;
2667 Table Create Table
2668 t1 CREATE TABLE `t1` (
2669 `c1` bigint NOT NULL
2670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2671 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2672 SHOW TABLES;
2673 Tables_in_test
2674 t1
2675 SHOW CREATE TABLE t1;
2676 Table Create Table
2677 t1 CREATE TABLE `t1` (
2678 `c1` bigint NOT NULL,
2679 KEY `i1` (`c1`) USING BTREE
2680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2681 DROP TABLE t1;
2682 SHOW TABLES;
2683 Tables_in_test
2684 CREATE TABLE t1(c1 REAL NOT NULL);
2685 SHOW TABLES;
2686 Tables_in_test
2687 t1
2688 SHOW CREATE TABLE t1;
2689 Table Create Table
2690 t1 CREATE TABLE `t1` (
2691 `c1` double NOT NULL
2692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2693 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2694 SHOW TABLES;
2695 Tables_in_test
2696 t1
2697 SHOW CREATE TABLE t1;
2698 Table Create Table
2699 t1 CREATE TABLE `t1` (
2700 `c1` double NOT NULL,
2701 KEY `i1` (`c1`) USING BTREE
2702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2703 DROP TABLE t1;
2704 SHOW TABLES;
2705 Tables_in_test
2706 CREATE TABLE t1(c1 DOUBLE NOT NULL);
2707 SHOW TABLES;
2708 Tables_in_test
2709 t1
2710 SHOW CREATE TABLE t1;
2711 Table Create Table
2712 t1 CREATE TABLE `t1` (
2713 `c1` double NOT NULL
2714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2715 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2716 SHOW TABLES;
2717 Tables_in_test
2718 t1
2719 SHOW CREATE TABLE t1;
2720 Table Create Table
2721 t1 CREATE TABLE `t1` (
2722 `c1` double NOT NULL,
2723 KEY `i1` (`c1`) USING BTREE
2724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2725 DROP TABLE t1;
2726 SHOW TABLES;
2727 Tables_in_test
2728 CREATE TABLE t1(c1 FLOAT NOT NULL);
2729 SHOW TABLES;
2730 Tables_in_test
2731 t1
2732 SHOW CREATE TABLE t1;
2733 Table Create Table
2734 t1 CREATE TABLE `t1` (
2735 `c1` float NOT NULL
2736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2737 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2738 SHOW TABLES;
2739 Tables_in_test
2740 t1
2741 SHOW CREATE TABLE t1;
2742 Table Create Table
2743 t1 CREATE TABLE `t1` (
2744 `c1` float NOT NULL,
2745 KEY `i1` (`c1`) USING BTREE
2746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2747 DROP TABLE t1;
2748 SHOW TABLES;
2749 Tables_in_test
2750 CREATE TABLE t1(c1 DECIMAL NOT NULL);
2751 SHOW TABLES;
2752 Tables_in_test
2753 t1
2754 SHOW CREATE TABLE t1;
2755 Table Create Table
2756 t1 CREATE TABLE `t1` (
2757 `c1` decimal(10,0) NOT NULL
2758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2759 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2760 SHOW TABLES;
2761 Tables_in_test
2762 t1
2763 SHOW CREATE TABLE t1;
2764 Table Create Table
2765 t1 CREATE TABLE `t1` (
2766 `c1` decimal(10,0) NOT NULL,
2767 KEY `i1` (`c1`) USING BTREE
2768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2769 DROP TABLE t1;
2770 SHOW TABLES;
2771 Tables_in_test
2772 CREATE TABLE t1(c1 NUMERIC NOT NULL);
2773 SHOW TABLES;
2774 Tables_in_test
2775 t1
2776 SHOW CREATE TABLE t1;
2777 Table Create Table
2778 t1 CREATE TABLE `t1` (
2779 `c1` decimal(10,0) NOT NULL
2780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2781 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2782 SHOW TABLES;
2783 Tables_in_test
2784 t1
2785 SHOW CREATE TABLE t1;
2786 Table Create Table
2787 t1 CREATE TABLE `t1` (
2788 `c1` decimal(10,0) NOT NULL,
2789 KEY `i1` (`c1`) USING BTREE
2790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2791 DROP TABLE t1;
2792 SHOW TABLES;
2793 Tables_in_test
2794 CREATE TABLE t1(c1 DATE NOT NULL);
2795 SHOW TABLES;
2796 Tables_in_test
2797 t1
2798 SHOW CREATE TABLE t1;
2799 Table Create Table
2800 t1 CREATE TABLE `t1` (
2801 `c1` date NOT NULL
2802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2803 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2804 SHOW TABLES;
2805 Tables_in_test
2806 t1
2807 SHOW CREATE TABLE t1;
2808 Table Create Table
2809 t1 CREATE TABLE `t1` (
2810 `c1` date NOT NULL,
2811 KEY `i1` (`c1`) USING BTREE
2812 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2813 DROP TABLE t1;
2814 SHOW TABLES;
2815 Tables_in_test
2816 CREATE TABLE t1(c1 TIME NOT NULL);
2817 SHOW TABLES;
2818 Tables_in_test
2819 t1
2820 SHOW CREATE TABLE t1;
2821 Table Create Table
2822 t1 CREATE TABLE `t1` (
2823 `c1` time NOT NULL
2824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2825 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2826 SHOW TABLES;
2827 Tables_in_test
2828 t1
2829 SHOW CREATE TABLE t1;
2830 Table Create Table
2831 t1 CREATE TABLE `t1` (
2832 `c1` time NOT NULL,
2833 KEY `i1` (`c1`) USING BTREE
2834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2835 DROP TABLE t1;
2836 SHOW TABLES;
2837 Tables_in_test
2838 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
2839 SHOW TABLES;
2840 Tables_in_test
2841 t1
2842 SHOW CREATE TABLE t1;
2843 Table Create Table
2844 t1 CREATE TABLE `t1` (
2845 `c1` timestamp NOT NULL
2846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2847 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2848 SHOW TABLES;
2849 Tables_in_test
2850 t1
2851 SHOW CREATE TABLE t1;
2852 Table Create Table
2853 t1 CREATE TABLE `t1` (
2854 `c1` timestamp NOT NULL,
2855 KEY `i1` (`c1`) USING BTREE
2856 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2857 DROP TABLE t1;
2858 SHOW TABLES;
2859 Tables_in_test
2860 CREATE TABLE t1(c1 YEAR NOT NULL);
2861 SHOW TABLES;
2862 Tables_in_test
2863 t1
2864 SHOW CREATE TABLE t1;
2865 Table Create Table
2866 t1 CREATE TABLE `t1` (
2867 `c1` year NOT NULL
2868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2869 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
2870 SHOW TABLES;
2871 Tables_in_test
2872 t1
2873 SHOW CREATE TABLE t1;
2874 Table Create Table
2875 t1 CREATE TABLE `t1` (
2876 `c1` year NOT NULL,
2877 KEY `i1` (`c1`) USING BTREE
2878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2879 DROP TABLE t1;
2880 SHOW TABLES;
2881 Tables_in_test
2882 CREATE TABLE t1(c1 BIT NOT NULL);
2883 SHOW TABLES;
2884 Tables_in_test
2885 t1
2886 SHOW CREATE TABLE t1;
2887 Table Create Table
2888 t1 CREATE TABLE `t1` (
2889 `c1` bit(1) NOT NULL
2890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2891 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2892 Warnings:
2893 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2894 SHOW TABLES;
2895 Tables_in_test
2896 t1
2897 SHOW CREATE TABLE t1;
2898 Table Create Table
2899 t1 CREATE TABLE `t1` (
2900 `c1` bit(1) NOT NULL,
2901 KEY `i1` (`c1`)
2902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2903 DROP TABLE t1;
2904 SHOW TABLES;
2905 Tables_in_test
2906 CREATE TABLE t1(c1 TINYINT NOT NULL);
2907 SHOW TABLES;
2908 Tables_in_test
2909 t1
2910 SHOW CREATE TABLE t1;
2911 Table Create Table
2912 t1 CREATE TABLE `t1` (
2913 `c1` tinyint NOT NULL
2914 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2915 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2916 Warnings:
2917 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2918 SHOW TABLES;
2919 Tables_in_test
2920 t1
2921 SHOW CREATE TABLE t1;
2922 Table Create Table
2923 t1 CREATE TABLE `t1` (
2924 `c1` tinyint NOT NULL,
2925 KEY `i1` (`c1`)
2926 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2927 DROP TABLE t1;
2928 SHOW TABLES;
2929 Tables_in_test
2930 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2931 SHOW TABLES;
2932 Tables_in_test
2933 t1
2934 SHOW CREATE TABLE t1;
2935 Table Create Table
2936 t1 CREATE TABLE `t1` (
2937 `c1` smallint NOT NULL
2938 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2939 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2940 Warnings:
2941 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2942 SHOW TABLES;
2943 Tables_in_test
2944 t1
2945 SHOW CREATE TABLE t1;
2946 Table Create Table
2947 t1 CREATE TABLE `t1` (
2948 `c1` smallint NOT NULL,
2949 KEY `i1` (`c1`)
2950 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2951 DROP TABLE t1;
2952 SHOW TABLES;
2953 Tables_in_test
2954 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2955 SHOW TABLES;
2956 Tables_in_test
2957 t1
2958 SHOW CREATE TABLE t1;
2959 Table Create Table
2960 t1 CREATE TABLE `t1` (
2961 `c1` mediumint NOT NULL
2962 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2963 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2964 Warnings:
2965 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2966 SHOW TABLES;
2967 Tables_in_test
2968 t1
2969 SHOW CREATE TABLE t1;
2970 Table Create Table
2971 t1 CREATE TABLE `t1` (
2972 `c1` mediumint NOT NULL,
2973 KEY `i1` (`c1`)
2974 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2975 DROP TABLE t1;
2976 SHOW TABLES;
2977 Tables_in_test
2978 CREATE TABLE t1(c1 INT NOT NULL);
2979 SHOW TABLES;
2980 Tables_in_test
2981 t1
2982 SHOW CREATE TABLE t1;
2983 Table Create Table
2984 t1 CREATE TABLE `t1` (
2985 `c1` int NOT NULL
2986 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2987 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
2988 Warnings:
2989 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
2990 SHOW TABLES;
2991 Tables_in_test
2992 t1
2993 SHOW CREATE TABLE t1;
2994 Table Create Table
2995 t1 CREATE TABLE `t1` (
2996 `c1` int NOT NULL,
2997 KEY `i1` (`c1`)
2998 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2999 DROP TABLE t1;
3000 SHOW TABLES;
3001 Tables_in_test
3002 CREATE TABLE t1(c1 INTEGER NOT NULL);
3003 SHOW TABLES;
3004 Tables_in_test
3005 t1
3006 SHOW CREATE TABLE t1;
3007 Table Create Table
3008 t1 CREATE TABLE `t1` (
3009 `c1` int NOT NULL
3010 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3011 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3012 Warnings:
3013 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3014 SHOW TABLES;
3015 Tables_in_test
3016 t1
3017 SHOW CREATE TABLE t1;
3018 Table Create Table
3019 t1 CREATE TABLE `t1` (
3020 `c1` int NOT NULL,
3021 KEY `i1` (`c1`)
3022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3023 DROP TABLE t1;
3024 SHOW TABLES;
3025 Tables_in_test
3026 CREATE TABLE t1(c1 BIGINT NOT NULL);
3027 SHOW TABLES;
3028 Tables_in_test
3029 t1
3030 SHOW CREATE TABLE t1;
3031 Table Create Table
3032 t1 CREATE TABLE `t1` (
3033 `c1` bigint NOT NULL
3034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3035 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3036 Warnings:
3037 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3038 SHOW TABLES;
3039 Tables_in_test
3040 t1
3041 SHOW CREATE TABLE t1;
3042 Table Create Table
3043 t1 CREATE TABLE `t1` (
3044 `c1` bigint NOT NULL,
3045 KEY `i1` (`c1`)
3046 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3047 DROP TABLE t1;
3048 SHOW TABLES;
3049 Tables_in_test
3050 CREATE TABLE t1(c1 REAL NOT NULL);
3051 SHOW TABLES;
3052 Tables_in_test
3053 t1
3054 SHOW CREATE TABLE t1;
3055 Table Create Table
3056 t1 CREATE TABLE `t1` (
3057 `c1` double NOT NULL
3058 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3059 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3060 Warnings:
3061 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3062 SHOW TABLES;
3063 Tables_in_test
3064 t1
3065 SHOW CREATE TABLE t1;
3066 Table Create Table
3067 t1 CREATE TABLE `t1` (
3068 `c1` double NOT NULL,
3069 KEY `i1` (`c1`)
3070 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3071 DROP TABLE t1;
3072 SHOW TABLES;
3073 Tables_in_test
3074 CREATE TABLE t1(c1 DOUBLE NOT NULL);
3075 SHOW TABLES;
3076 Tables_in_test
3077 t1
3078 SHOW CREATE TABLE t1;
3079 Table Create Table
3080 t1 CREATE TABLE `t1` (
3081 `c1` double NOT NULL
3082 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3083 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3084 Warnings:
3085 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3086 SHOW TABLES;
3087 Tables_in_test
3088 t1
3089 SHOW CREATE TABLE t1;
3090 Table Create Table
3091 t1 CREATE TABLE `t1` (
3092 `c1` double NOT NULL,
3093 KEY `i1` (`c1`)
3094 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3095 DROP TABLE t1;
3096 SHOW TABLES;
3097 Tables_in_test
3098 CREATE TABLE t1(c1 FLOAT NOT NULL);
3099 SHOW TABLES;
3100 Tables_in_test
3101 t1
3102 SHOW CREATE TABLE t1;
3103 Table Create Table
3104 t1 CREATE TABLE `t1` (
3105 `c1` float NOT NULL
3106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3107 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3108 Warnings:
3109 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3110 SHOW TABLES;
3111 Tables_in_test
3112 t1
3113 SHOW CREATE TABLE t1;
3114 Table Create Table
3115 t1 CREATE TABLE `t1` (
3116 `c1` float NOT NULL,
3117 KEY `i1` (`c1`)
3118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3119 DROP TABLE t1;
3120 SHOW TABLES;
3121 Tables_in_test
3122 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3123 SHOW TABLES;
3124 Tables_in_test
3125 t1
3126 SHOW CREATE TABLE t1;
3127 Table Create Table
3128 t1 CREATE TABLE `t1` (
3129 `c1` decimal(10,0) NOT NULL
3130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3131 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3132 Warnings:
3133 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3134 SHOW TABLES;
3135 Tables_in_test
3136 t1
3137 SHOW CREATE TABLE t1;
3138 Table Create Table
3139 t1 CREATE TABLE `t1` (
3140 `c1` decimal(10,0) NOT NULL,
3141 KEY `i1` (`c1`)
3142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3143 DROP TABLE t1;
3144 SHOW TABLES;
3145 Tables_in_test
3146 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3147 SHOW TABLES;
3148 Tables_in_test
3149 t1
3150 SHOW CREATE TABLE t1;
3151 Table Create Table
3152 t1 CREATE TABLE `t1` (
3153 `c1` decimal(10,0) NOT NULL
3154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3155 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3156 Warnings:
3157 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3158 SHOW TABLES;
3159 Tables_in_test
3160 t1
3161 SHOW CREATE TABLE t1;
3162 Table Create Table
3163 t1 CREATE TABLE `t1` (
3164 `c1` decimal(10,0) NOT NULL,
3165 KEY `i1` (`c1`)
3166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3167 DROP TABLE t1;
3168 SHOW TABLES;
3169 Tables_in_test
3170 CREATE TABLE t1(c1 DATE NOT NULL);
3171 SHOW TABLES;
3172 Tables_in_test
3173 t1
3174 SHOW CREATE TABLE t1;
3175 Table Create Table
3176 t1 CREATE TABLE `t1` (
3177 `c1` date NOT NULL
3178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3179 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3180 Warnings:
3181 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3182 SHOW TABLES;
3183 Tables_in_test
3184 t1
3185 SHOW CREATE TABLE t1;
3186 Table Create Table
3187 t1 CREATE TABLE `t1` (
3188 `c1` date NOT NULL,
3189 KEY `i1` (`c1`)
3190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3191 DROP TABLE t1;
3192 SHOW TABLES;
3193 Tables_in_test
3194 CREATE TABLE t1(c1 TIME NOT NULL);
3195 SHOW TABLES;
3196 Tables_in_test
3197 t1
3198 SHOW CREATE TABLE t1;
3199 Table Create Table
3200 t1 CREATE TABLE `t1` (
3201 `c1` time NOT NULL
3202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3203 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3204 Warnings:
3205 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3206 SHOW TABLES;
3207 Tables_in_test
3208 t1
3209 SHOW CREATE TABLE t1;
3210 Table Create Table
3211 t1 CREATE TABLE `t1` (
3212 `c1` time NOT NULL,
3213 KEY `i1` (`c1`)
3214 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3215 DROP TABLE t1;
3216 SHOW TABLES;
3217 Tables_in_test
3218 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3219 SHOW TABLES;
3220 Tables_in_test
3221 t1
3222 SHOW CREATE TABLE t1;
3223 Table Create Table
3224 t1 CREATE TABLE `t1` (
3225 `c1` timestamp NOT NULL
3226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3227 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3228 Warnings:
3229 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3230 SHOW TABLES;
3231 Tables_in_test
3232 t1
3233 SHOW CREATE TABLE t1;
3234 Table Create Table
3235 t1 CREATE TABLE `t1` (
3236 `c1` timestamp NOT NULL,
3237 KEY `i1` (`c1`)
3238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3239 DROP TABLE t1;
3240 SHOW TABLES;
3241 Tables_in_test
3242 CREATE TABLE t1(c1 YEAR NOT NULL);
3243 SHOW TABLES;
3244 Tables_in_test
3245 t1
3246 SHOW CREATE TABLE t1;
3247 Table Create Table
3248 t1 CREATE TABLE `t1` (
3249 `c1` year NOT NULL
3250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3251 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
3252 Warnings:
3253 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3254 SHOW TABLES;
3255 Tables_in_test
3256 t1
3257 SHOW CREATE TABLE t1;
3258 Table Create Table
3259 t1 CREATE TABLE `t1` (
3260 `c1` year NOT NULL,
3261 KEY `i1` (`c1`)
3262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3263 DROP TABLE t1;
3264 SHOW TABLES;
3265 Tables_in_test
3266 CREATE TABLE t1(c1 BIT NOT NULL);
3267 SHOW TABLES;
3268 Tables_in_test
3269 t1
3270 SHOW CREATE TABLE t1;
3271 Table Create Table
3272 t1 CREATE TABLE `t1` (
3273 `c1` bit(1) NOT NULL
3274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3275 ALTER TABLE t1 ADD INDEX i1 (c1);
3276 SHOW TABLES;
3277 Tables_in_test
3278 t1
3279 SHOW CREATE TABLE t1;
3280 Table Create Table
3281 t1 CREATE TABLE `t1` (
3282 `c1` bit(1) NOT NULL,
3283 KEY `i1` (`c1`)
3284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3285 DROP TABLE t1;
3286 SHOW TABLES;
3287 Tables_in_test
3288 CREATE TABLE t1(c1 TINYINT NOT NULL);
3289 SHOW TABLES;
3290 Tables_in_test
3291 t1
3292 SHOW CREATE TABLE t1;
3293 Table Create Table
3294 t1 CREATE TABLE `t1` (
3295 `c1` tinyint NOT NULL
3296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3297 ALTER TABLE t1 ADD INDEX i1 (c1);
3298 SHOW TABLES;
3299 Tables_in_test
3300 t1
3301 SHOW CREATE TABLE t1;
3302 Table Create Table
3303 t1 CREATE TABLE `t1` (
3304 `c1` tinyint NOT NULL,
3305 KEY `i1` (`c1`)
3306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3307 DROP TABLE t1;
3308 SHOW TABLES;
3309 Tables_in_test
3310 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3311 SHOW TABLES;
3312 Tables_in_test
3313 t1
3314 SHOW CREATE TABLE t1;
3315 Table Create Table
3316 t1 CREATE TABLE `t1` (
3317 `c1` smallint NOT NULL
3318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3319 ALTER TABLE t1 ADD INDEX i1 (c1);
3320 SHOW TABLES;
3321 Tables_in_test
3322 t1
3323 SHOW CREATE TABLE t1;
3324 Table Create Table
3325 t1 CREATE TABLE `t1` (
3326 `c1` smallint NOT NULL,
3327 KEY `i1` (`c1`)
3328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3329 DROP TABLE t1;
3330 SHOW TABLES;
3331 Tables_in_test
3332 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3333 SHOW TABLES;
3334 Tables_in_test
3335 t1
3336 SHOW CREATE TABLE t1;
3337 Table Create Table
3338 t1 CREATE TABLE `t1` (
3339 `c1` mediumint NOT NULL
3340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3341 ALTER TABLE t1 ADD INDEX i1 (c1);
3342 SHOW TABLES;
3343 Tables_in_test
3344 t1
3345 SHOW CREATE TABLE t1;
3346 Table Create Table
3347 t1 CREATE TABLE `t1` (
3348 `c1` mediumint NOT NULL,
3349 KEY `i1` (`c1`)
3350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3351 DROP TABLE t1;
3352 SHOW TABLES;
3353 Tables_in_test
3354 CREATE TABLE t1(c1 INT NOT NULL);
3355 SHOW TABLES;
3356 Tables_in_test
3357 t1
3358 SHOW CREATE TABLE t1;
3359 Table Create Table
3360 t1 CREATE TABLE `t1` (
3361 `c1` int NOT NULL
3362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3363 ALTER TABLE t1 ADD INDEX i1 (c1);
3364 SHOW TABLES;
3365 Tables_in_test
3366 t1
3367 SHOW CREATE TABLE t1;
3368 Table Create Table
3369 t1 CREATE TABLE `t1` (
3370 `c1` int NOT NULL,
3371 KEY `i1` (`c1`)
3372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3373 DROP TABLE t1;
3374 SHOW TABLES;
3375 Tables_in_test
3376 CREATE TABLE t1(c1 INTEGER NOT NULL);
3377 SHOW TABLES;
3378 Tables_in_test
3379 t1
3380 SHOW CREATE TABLE t1;
3381 Table Create Table
3382 t1 CREATE TABLE `t1` (
3383 `c1` int NOT NULL
3384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3385 ALTER TABLE t1 ADD INDEX i1 (c1);
3386 SHOW TABLES;
3387 Tables_in_test
3388 t1
3389 SHOW CREATE TABLE t1;
3390 Table Create Table
3391 t1 CREATE TABLE `t1` (
3392 `c1` int NOT NULL,
3393 KEY `i1` (`c1`)
3394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3395 DROP TABLE t1;
3396 SHOW TABLES;
3397 Tables_in_test
3398 CREATE TABLE t1(c1 BIGINT NOT NULL);
3399 SHOW TABLES;
3400 Tables_in_test
3401 t1
3402 SHOW CREATE TABLE t1;
3403 Table Create Table
3404 t1 CREATE TABLE `t1` (
3405 `c1` bigint NOT NULL
3406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3407 ALTER TABLE t1 ADD INDEX i1 (c1);
3408 SHOW TABLES;
3409 Tables_in_test
3410 t1
3411 SHOW CREATE TABLE t1;
3412 Table Create Table
3413 t1 CREATE TABLE `t1` (
3414 `c1` bigint NOT NULL,
3415 KEY `i1` (`c1`)
3416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3417 DROP TABLE t1;
3418 SHOW TABLES;
3419 Tables_in_test
3420 CREATE TABLE t1(c1 REAL NOT NULL);
3421 SHOW TABLES;
3422 Tables_in_test
3423 t1
3424 SHOW CREATE TABLE t1;
3425 Table Create Table
3426 t1 CREATE TABLE `t1` (
3427 `c1` double NOT NULL
3428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3429 ALTER TABLE t1 ADD INDEX i1 (c1);
3430 SHOW TABLES;
3431 Tables_in_test
3432 t1
3433 SHOW CREATE TABLE t1;
3434 Table Create Table
3435 t1 CREATE TABLE `t1` (
3436 `c1` double NOT NULL,
3437 KEY `i1` (`c1`)
3438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3439 DROP TABLE t1;
3440 SHOW TABLES;
3441 Tables_in_test
3442 CREATE TABLE t1(c1 DOUBLE NOT NULL);
3443 SHOW TABLES;
3444 Tables_in_test
3445 t1
3446 SHOW CREATE TABLE t1;
3447 Table Create Table
3448 t1 CREATE TABLE `t1` (
3449 `c1` double NOT NULL
3450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3451 ALTER TABLE t1 ADD INDEX i1 (c1);
3452 SHOW TABLES;
3453 Tables_in_test
3454 t1
3455 SHOW CREATE TABLE t1;
3456 Table Create Table
3457 t1 CREATE TABLE `t1` (
3458 `c1` double NOT NULL,
3459 KEY `i1` (`c1`)
3460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3461 DROP TABLE t1;
3462 SHOW TABLES;
3463 Tables_in_test
3464 CREATE TABLE t1(c1 FLOAT NOT NULL);
3465 SHOW TABLES;
3466 Tables_in_test
3467 t1
3468 SHOW CREATE TABLE t1;
3469 Table Create Table
3470 t1 CREATE TABLE `t1` (
3471 `c1` float NOT NULL
3472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3473 ALTER TABLE t1 ADD INDEX i1 (c1);
3474 SHOW TABLES;
3475 Tables_in_test
3476 t1
3477 SHOW CREATE TABLE t1;
3478 Table Create Table
3479 t1 CREATE TABLE `t1` (
3480 `c1` float NOT NULL,
3481 KEY `i1` (`c1`)
3482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3483 DROP TABLE t1;
3484 SHOW TABLES;
3485 Tables_in_test
3486 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3487 SHOW TABLES;
3488 Tables_in_test
3489 t1
3490 SHOW CREATE TABLE t1;
3491 Table Create Table
3492 t1 CREATE TABLE `t1` (
3493 `c1` decimal(10,0) NOT NULL
3494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3495 ALTER TABLE t1 ADD INDEX i1 (c1);
3496 SHOW TABLES;
3497 Tables_in_test
3498 t1
3499 SHOW CREATE TABLE t1;
3500 Table Create Table
3501 t1 CREATE TABLE `t1` (
3502 `c1` decimal(10,0) NOT NULL,
3503 KEY `i1` (`c1`)
3504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3505 DROP TABLE t1;
3506 SHOW TABLES;
3507 Tables_in_test
3508 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3509 SHOW TABLES;
3510 Tables_in_test
3511 t1
3512 SHOW CREATE TABLE t1;
3513 Table Create Table
3514 t1 CREATE TABLE `t1` (
3515 `c1` decimal(10,0) NOT NULL
3516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3517 ALTER TABLE t1 ADD INDEX i1 (c1);
3518 SHOW TABLES;
3519 Tables_in_test
3520 t1
3521 SHOW CREATE TABLE t1;
3522 Table Create Table
3523 t1 CREATE TABLE `t1` (
3524 `c1` decimal(10,0) NOT NULL,
3525 KEY `i1` (`c1`)
3526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3527 DROP TABLE t1;
3528 SHOW TABLES;
3529 Tables_in_test
3530 CREATE TABLE t1(c1 DATE NOT NULL);
3531 SHOW TABLES;
3532 Tables_in_test
3533 t1
3534 SHOW CREATE TABLE t1;
3535 Table Create Table
3536 t1 CREATE TABLE `t1` (
3537 `c1` date NOT NULL
3538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3539 ALTER TABLE t1 ADD INDEX i1 (c1);
3540 SHOW TABLES;
3541 Tables_in_test
3542 t1
3543 SHOW CREATE TABLE t1;
3544 Table Create Table
3545 t1 CREATE TABLE `t1` (
3546 `c1` date NOT NULL,
3547 KEY `i1` (`c1`)
3548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3549 DROP TABLE t1;
3550 SHOW TABLES;
3551 Tables_in_test
3552 CREATE TABLE t1(c1 TIME NOT NULL);
3553 SHOW TABLES;
3554 Tables_in_test
3555 t1
3556 SHOW CREATE TABLE t1;
3557 Table Create Table
3558 t1 CREATE TABLE `t1` (
3559 `c1` time NOT NULL
3560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3561 ALTER TABLE t1 ADD INDEX i1 (c1);
3562 SHOW TABLES;
3563 Tables_in_test
3564 t1
3565 SHOW CREATE TABLE t1;
3566 Table Create Table
3567 t1 CREATE TABLE `t1` (
3568 `c1` time NOT NULL,
3569 KEY `i1` (`c1`)
3570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3571 DROP TABLE t1;
3572 SHOW TABLES;
3573 Tables_in_test
3574 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3575 SHOW TABLES;
3576 Tables_in_test
3577 t1
3578 SHOW CREATE TABLE t1;
3579 Table Create Table
3580 t1 CREATE TABLE `t1` (
3581 `c1` timestamp NOT NULL
3582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3583 ALTER TABLE t1 ADD INDEX i1 (c1);
3584 SHOW TABLES;
3585 Tables_in_test
3586 t1
3587 SHOW CREATE TABLE t1;
3588 Table Create Table
3589 t1 CREATE TABLE `t1` (
3590 `c1` timestamp NOT NULL,
3591 KEY `i1` (`c1`)
3592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3593 DROP TABLE t1;
3594 SHOW TABLES;
3595 Tables_in_test
3596 CREATE TABLE t1(c1 YEAR NOT NULL);
3597 SHOW TABLES;
3598 Tables_in_test
3599 t1
3600 SHOW CREATE TABLE t1;
3601 Table Create Table
3602 t1 CREATE TABLE `t1` (
3603 `c1` year NOT NULL
3604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3605 ALTER TABLE t1 ADD INDEX i1 (c1);
3606 SHOW TABLES;
3607 Tables_in_test
3608 t1
3609 SHOW CREATE TABLE t1;
3610 Table Create Table
3611 t1 CREATE TABLE `t1` (
3612 `c1` year NOT NULL,
3613 KEY `i1` (`c1`)
3614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3615 DROP TABLE t1;
3616 SHOW TABLES;
3617 Tables_in_test
3618 CREATE TABLE t1(c1 BIT NOT NULL);
3619 SHOW TABLES;
3620 Tables_in_test
3621 t1
3622 SHOW CREATE TABLE t1;
3623 Table Create Table
3624 t1 CREATE TABLE `t1` (
3625 `c1` bit(1) NOT NULL
3626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3627 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3628 SHOW TABLES;
3629 Tables_in_test
3630 t1
3631 SHOW CREATE TABLE t1;
3632 Table Create Table
3633 t1 CREATE TABLE `t1` (
3634 `c1` bit(1) NOT NULL,
3635 KEY `i1` (`c1`) USING BTREE
3636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3637 DROP TABLE t1;
3638 SHOW TABLES;
3639 Tables_in_test
3640 CREATE TABLE t1(c1 TINYINT NOT NULL);
3641 SHOW TABLES;
3642 Tables_in_test
3643 t1
3644 SHOW CREATE TABLE t1;
3645 Table Create Table
3646 t1 CREATE TABLE `t1` (
3647 `c1` tinyint NOT NULL
3648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3649 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3650 SHOW TABLES;
3651 Tables_in_test
3652 t1
3653 SHOW CREATE TABLE t1;
3654 Table Create Table
3655 t1 CREATE TABLE `t1` (
3656 `c1` tinyint NOT NULL,
3657 KEY `i1` (`c1`) USING BTREE
3658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3659 DROP TABLE t1;
3660 SHOW TABLES;
3661 Tables_in_test
3662 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3663 SHOW TABLES;
3664 Tables_in_test
3665 t1
3666 SHOW CREATE TABLE t1;
3667 Table Create Table
3668 t1 CREATE TABLE `t1` (
3669 `c1` smallint NOT NULL
3670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3671 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3672 SHOW TABLES;
3673 Tables_in_test
3674 t1
3675 SHOW CREATE TABLE t1;
3676 Table Create Table
3677 t1 CREATE TABLE `t1` (
3678 `c1` smallint NOT NULL,
3679 KEY `i1` (`c1`) USING BTREE
3680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3681 DROP TABLE t1;
3682 SHOW TABLES;
3683 Tables_in_test
3684 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3685 SHOW TABLES;
3686 Tables_in_test
3687 t1
3688 SHOW CREATE TABLE t1;
3689 Table Create Table
3690 t1 CREATE TABLE `t1` (
3691 `c1` mediumint NOT NULL
3692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3693 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3694 SHOW TABLES;
3695 Tables_in_test
3696 t1
3697 SHOW CREATE TABLE t1;
3698 Table Create Table
3699 t1 CREATE TABLE `t1` (
3700 `c1` mediumint NOT NULL,
3701 KEY `i1` (`c1`) USING BTREE
3702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3703 DROP TABLE t1;
3704 SHOW TABLES;
3705 Tables_in_test
3706 CREATE TABLE t1(c1 INT NOT NULL);
3707 SHOW TABLES;
3708 Tables_in_test
3709 t1
3710 SHOW CREATE TABLE t1;
3711 Table Create Table
3712 t1 CREATE TABLE `t1` (
3713 `c1` int NOT NULL
3714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3715 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3716 SHOW TABLES;
3717 Tables_in_test
3718 t1
3719 SHOW CREATE TABLE t1;
3720 Table Create Table
3721 t1 CREATE TABLE `t1` (
3722 `c1` int NOT NULL,
3723 KEY `i1` (`c1`) USING BTREE
3724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3725 DROP TABLE t1;
3726 SHOW TABLES;
3727 Tables_in_test
3728 CREATE TABLE t1(c1 INTEGER NOT NULL);
3729 SHOW TABLES;
3730 Tables_in_test
3731 t1
3732 SHOW CREATE TABLE t1;
3733 Table Create Table
3734 t1 CREATE TABLE `t1` (
3735 `c1` int NOT NULL
3736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3737 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3738 SHOW TABLES;
3739 Tables_in_test
3740 t1
3741 SHOW CREATE TABLE t1;
3742 Table Create Table
3743 t1 CREATE TABLE `t1` (
3744 `c1` int NOT NULL,
3745 KEY `i1` (`c1`) USING BTREE
3746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3747 DROP TABLE t1;
3748 SHOW TABLES;
3749 Tables_in_test
3750 CREATE TABLE t1(c1 BIGINT NOT NULL);
3751 SHOW TABLES;
3752 Tables_in_test
3753 t1
3754 SHOW CREATE TABLE t1;
3755 Table Create Table
3756 t1 CREATE TABLE `t1` (
3757 `c1` bigint NOT NULL
3758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3759 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3760 SHOW TABLES;
3761 Tables_in_test
3762 t1
3763 SHOW CREATE TABLE t1;
3764 Table Create Table
3765 t1 CREATE TABLE `t1` (
3766 `c1` bigint NOT NULL,
3767 KEY `i1` (`c1`) USING BTREE
3768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3769 DROP TABLE t1;
3770 SHOW TABLES;
3771 Tables_in_test
3772 CREATE TABLE t1(c1 REAL NOT NULL);
3773 SHOW TABLES;
3774 Tables_in_test
3775 t1
3776 SHOW CREATE TABLE t1;
3777 Table Create Table
3778 t1 CREATE TABLE `t1` (
3779 `c1` double NOT NULL
3780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3781 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3782 SHOW TABLES;
3783 Tables_in_test
3784 t1
3785 SHOW CREATE TABLE t1;
3786 Table Create Table
3787 t1 CREATE TABLE `t1` (
3788 `c1` double NOT NULL,
3789 KEY `i1` (`c1`) USING BTREE
3790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3791 DROP TABLE t1;
3792 SHOW TABLES;
3793 Tables_in_test
3794 CREATE TABLE t1(c1 DOUBLE NOT NULL);
3795 SHOW TABLES;
3796 Tables_in_test
3797 t1
3798 SHOW CREATE TABLE t1;
3799 Table Create Table
3800 t1 CREATE TABLE `t1` (
3801 `c1` double NOT NULL
3802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3803 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3804 SHOW TABLES;
3805 Tables_in_test
3806 t1
3807 SHOW CREATE TABLE t1;
3808 Table Create Table
3809 t1 CREATE TABLE `t1` (
3810 `c1` double NOT NULL,
3811 KEY `i1` (`c1`) USING BTREE
3812 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3813 DROP TABLE t1;
3814 SHOW TABLES;
3815 Tables_in_test
3816 CREATE TABLE t1(c1 FLOAT NOT NULL);
3817 SHOW TABLES;
3818 Tables_in_test
3819 t1
3820 SHOW CREATE TABLE t1;
3821 Table Create Table
3822 t1 CREATE TABLE `t1` (
3823 `c1` float NOT NULL
3824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3825 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3826 SHOW TABLES;
3827 Tables_in_test
3828 t1
3829 SHOW CREATE TABLE t1;
3830 Table Create Table
3831 t1 CREATE TABLE `t1` (
3832 `c1` float NOT NULL,
3833 KEY `i1` (`c1`) USING BTREE
3834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3835 DROP TABLE t1;
3836 SHOW TABLES;
3837 Tables_in_test
3838 CREATE TABLE t1(c1 DECIMAL NOT NULL);
3839 SHOW TABLES;
3840 Tables_in_test
3841 t1
3842 SHOW CREATE TABLE t1;
3843 Table Create Table
3844 t1 CREATE TABLE `t1` (
3845 `c1` decimal(10,0) NOT NULL
3846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3847 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3848 SHOW TABLES;
3849 Tables_in_test
3850 t1
3851 SHOW CREATE TABLE t1;
3852 Table Create Table
3853 t1 CREATE TABLE `t1` (
3854 `c1` decimal(10,0) NOT NULL,
3855 KEY `i1` (`c1`) USING BTREE
3856 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3857 DROP TABLE t1;
3858 SHOW TABLES;
3859 Tables_in_test
3860 CREATE TABLE t1(c1 NUMERIC NOT NULL);
3861 SHOW TABLES;
3862 Tables_in_test
3863 t1
3864 SHOW CREATE TABLE t1;
3865 Table Create Table
3866 t1 CREATE TABLE `t1` (
3867 `c1` decimal(10,0) NOT NULL
3868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3869 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3870 SHOW TABLES;
3871 Tables_in_test
3872 t1
3873 SHOW CREATE TABLE t1;
3874 Table Create Table
3875 t1 CREATE TABLE `t1` (
3876 `c1` decimal(10,0) NOT NULL,
3877 KEY `i1` (`c1`) USING BTREE
3878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3879 DROP TABLE t1;
3880 SHOW TABLES;
3881 Tables_in_test
3882 CREATE TABLE t1(c1 DATE NOT NULL);
3883 SHOW TABLES;
3884 Tables_in_test
3885 t1
3886 SHOW CREATE TABLE t1;
3887 Table Create Table
3888 t1 CREATE TABLE `t1` (
3889 `c1` date NOT NULL
3890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3891 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3892 SHOW TABLES;
3893 Tables_in_test
3894 t1
3895 SHOW CREATE TABLE t1;
3896 Table Create Table
3897 t1 CREATE TABLE `t1` (
3898 `c1` date NOT NULL,
3899 KEY `i1` (`c1`) USING BTREE
3900 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3901 DROP TABLE t1;
3902 SHOW TABLES;
3903 Tables_in_test
3904 CREATE TABLE t1(c1 TIME NOT NULL);
3905 SHOW TABLES;
3906 Tables_in_test
3907 t1
3908 SHOW CREATE TABLE t1;
3909 Table Create Table
3910 t1 CREATE TABLE `t1` (
3911 `c1` time NOT NULL
3912 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3913 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3914 SHOW TABLES;
3915 Tables_in_test
3916 t1
3917 SHOW CREATE TABLE t1;
3918 Table Create Table
3919 t1 CREATE TABLE `t1` (
3920 `c1` time NOT NULL,
3921 KEY `i1` (`c1`) USING BTREE
3922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3923 DROP TABLE t1;
3924 SHOW TABLES;
3925 Tables_in_test
3926 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
3927 SHOW TABLES;
3928 Tables_in_test
3929 t1
3930 SHOW CREATE TABLE t1;
3931 Table Create Table
3932 t1 CREATE TABLE `t1` (
3933 `c1` timestamp NOT NULL
3934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3935 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3936 SHOW TABLES;
3937 Tables_in_test
3938 t1
3939 SHOW CREATE TABLE t1;
3940 Table Create Table
3941 t1 CREATE TABLE `t1` (
3942 `c1` timestamp NOT NULL,
3943 KEY `i1` (`c1`) USING BTREE
3944 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3945 DROP TABLE t1;
3946 SHOW TABLES;
3947 Tables_in_test
3948 CREATE TABLE t1(c1 YEAR NOT NULL);
3949 SHOW TABLES;
3950 Tables_in_test
3951 t1
3952 SHOW CREATE TABLE t1;
3953 Table Create Table
3954 t1 CREATE TABLE `t1` (
3955 `c1` year NOT NULL
3956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3957 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
3958 SHOW TABLES;
3959 Tables_in_test
3960 t1
3961 SHOW CREATE TABLE t1;
3962 Table Create Table
3963 t1 CREATE TABLE `t1` (
3964 `c1` year NOT NULL,
3965 KEY `i1` (`c1`) USING BTREE
3966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3967 DROP TABLE t1;
3968 SHOW TABLES;
3969 Tables_in_test
3970 CREATE TABLE t1(c1 BIT NOT NULL);
3971 SHOW TABLES;
3972 Tables_in_test
3973 t1
3974 SHOW CREATE TABLE t1;
3975 Table Create Table
3976 t1 CREATE TABLE `t1` (
3977 `c1` bit(1) NOT NULL
3978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3979 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
3980 Warnings:
3981 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
3982 SHOW TABLES;
3983 Tables_in_test
3984 t1
3985 SHOW CREATE TABLE t1;
3986 Table Create Table
3987 t1 CREATE TABLE `t1` (
3988 `c1` bit(1) NOT NULL,
3989 KEY `i1` (`c1`)
3990 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3991 DROP TABLE t1;
3992 SHOW TABLES;
3993 Tables_in_test
3994 CREATE TABLE t1(c1 TINYINT NOT NULL);
3995 SHOW TABLES;
3996 Tables_in_test
3997 t1
3998 SHOW CREATE TABLE t1;
3999 Table Create Table
4000 t1 CREATE TABLE `t1` (
4001 `c1` tinyint NOT NULL
4002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4003 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4004 Warnings:
4005 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4006 SHOW TABLES;
4007 Tables_in_test
4008 t1
4009 SHOW CREATE TABLE t1;
4010 Table Create Table
4011 t1 CREATE TABLE `t1` (
4012 `c1` tinyint NOT NULL,
4013 KEY `i1` (`c1`)
4014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4015 DROP TABLE t1;
4016 SHOW TABLES;
4017 Tables_in_test
4018 CREATE TABLE t1(c1 SMALLINT NOT NULL);
4019 SHOW TABLES;
4020 Tables_in_test
4021 t1
4022 SHOW CREATE TABLE t1;
4023 Table Create Table
4024 t1 CREATE TABLE `t1` (
4025 `c1` smallint NOT NULL
4026 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4027 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4028 Warnings:
4029 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4030 SHOW TABLES;
4031 Tables_in_test
4032 t1
4033 SHOW CREATE TABLE t1;
4034 Table Create Table
4035 t1 CREATE TABLE `t1` (
4036 `c1` smallint NOT NULL,
4037 KEY `i1` (`c1`)
4038 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4039 DROP TABLE t1;
4040 SHOW TABLES;
4041 Tables_in_test
4042 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
4043 SHOW TABLES;
4044 Tables_in_test
4045 t1
4046 SHOW CREATE TABLE t1;
4047 Table Create Table
4048 t1 CREATE TABLE `t1` (
4049 `c1` mediumint NOT NULL
4050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4051 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4052 Warnings:
4053 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4054 SHOW TABLES;
4055 Tables_in_test
4056 t1
4057 SHOW CREATE TABLE t1;
4058 Table Create Table
4059 t1 CREATE TABLE `t1` (
4060 `c1` mediumint NOT NULL,
4061 KEY `i1` (`c1`)
4062 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4063 DROP TABLE t1;
4064 SHOW TABLES;
4065 Tables_in_test
4066 CREATE TABLE t1(c1 INT NOT NULL);
4067 SHOW TABLES;
4068 Tables_in_test
4069 t1
4070 SHOW CREATE TABLE t1;
4071 Table Create Table
4072 t1 CREATE TABLE `t1` (
4073 `c1` int NOT NULL
4074 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4075 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4076 Warnings:
4077 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4078 SHOW TABLES;
4079 Tables_in_test
4080 t1
4081 SHOW CREATE TABLE t1;
4082 Table Create Table
4083 t1 CREATE TABLE `t1` (
4084 `c1` int NOT NULL,
4085 KEY `i1` (`c1`)
4086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4087 DROP TABLE t1;
4088 SHOW TABLES;
4089 Tables_in_test
4090 CREATE TABLE t1(c1 INTEGER NOT NULL);
4091 SHOW TABLES;
4092 Tables_in_test
4093 t1
4094 SHOW CREATE TABLE t1;
4095 Table Create Table
4096 t1 CREATE TABLE `t1` (
4097 `c1` int NOT NULL
4098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4099 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4100 Warnings:
4101 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4102 SHOW TABLES;
4103 Tables_in_test
4104 t1
4105 SHOW CREATE TABLE t1;
4106 Table Create Table
4107 t1 CREATE TABLE `t1` (
4108 `c1` int NOT NULL,
4109 KEY `i1` (`c1`)
4110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4111 DROP TABLE t1;
4112 SHOW TABLES;
4113 Tables_in_test
4114 CREATE TABLE t1(c1 BIGINT NOT NULL);
4115 SHOW TABLES;
4116 Tables_in_test
4117 t1
4118 SHOW CREATE TABLE t1;
4119 Table Create Table
4120 t1 CREATE TABLE `t1` (
4121 `c1` bigint NOT NULL
4122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4123 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4124 Warnings:
4125 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4126 SHOW TABLES;
4127 Tables_in_test
4128 t1
4129 SHOW CREATE TABLE t1;
4130 Table Create Table
4131 t1 CREATE TABLE `t1` (
4132 `c1` bigint NOT NULL,
4133 KEY `i1` (`c1`)
4134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4135 DROP TABLE t1;
4136 SHOW TABLES;
4137 Tables_in_test
4138 CREATE TABLE t1(c1 REAL NOT NULL);
4139 SHOW TABLES;
4140 Tables_in_test
4141 t1
4142 SHOW CREATE TABLE t1;
4143 Table Create Table
4144 t1 CREATE TABLE `t1` (
4145 `c1` double NOT NULL
4146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4147 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4148 Warnings:
4149 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4150 SHOW TABLES;
4151 Tables_in_test
4152 t1
4153 SHOW CREATE TABLE t1;
4154 Table Create Table
4155 t1 CREATE TABLE `t1` (
4156 `c1` double NOT NULL,
4157 KEY `i1` (`c1`)
4158 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4159 DROP TABLE t1;
4160 SHOW TABLES;
4161 Tables_in_test
4162 CREATE TABLE t1(c1 DOUBLE NOT NULL);
4163 SHOW TABLES;
4164 Tables_in_test
4165 t1
4166 SHOW CREATE TABLE t1;
4167 Table Create Table
4168 t1 CREATE TABLE `t1` (
4169 `c1` double NOT NULL
4170 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4171 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4172 Warnings:
4173 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4174 SHOW TABLES;
4175 Tables_in_test
4176 t1
4177 SHOW CREATE TABLE t1;
4178 Table Create Table
4179 t1 CREATE TABLE `t1` (
4180 `c1` double NOT NULL,
4181 KEY `i1` (`c1`)
4182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4183 DROP TABLE t1;
4184 SHOW TABLES;
4185 Tables_in_test
4186 CREATE TABLE t1(c1 FLOAT NOT NULL);
4187 SHOW TABLES;
4188 Tables_in_test
4189 t1
4190 SHOW CREATE TABLE t1;
4191 Table Create Table
4192 t1 CREATE TABLE `t1` (
4193 `c1` float NOT NULL
4194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4195 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4196 Warnings:
4197 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4198 SHOW TABLES;
4199 Tables_in_test
4200 t1
4201 SHOW CREATE TABLE t1;
4202 Table Create Table
4203 t1 CREATE TABLE `t1` (
4204 `c1` float NOT NULL,
4205 KEY `i1` (`c1`)
4206 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4207 DROP TABLE t1;
4208 SHOW TABLES;
4209 Tables_in_test
4210 CREATE TABLE t1(c1 DECIMAL NOT NULL);
4211 SHOW TABLES;
4212 Tables_in_test
4213 t1
4214 SHOW CREATE TABLE t1;
4215 Table Create Table
4216 t1 CREATE TABLE `t1` (
4217 `c1` decimal(10,0) NOT NULL
4218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4219 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4220 Warnings:
4221 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4222 SHOW TABLES;
4223 Tables_in_test
4224 t1
4225 SHOW CREATE TABLE t1;
4226 Table Create Table
4227 t1 CREATE TABLE `t1` (
4228 `c1` decimal(10,0) NOT NULL,
4229 KEY `i1` (`c1`)
4230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4231 DROP TABLE t1;
4232 SHOW TABLES;
4233 Tables_in_test
4234 CREATE TABLE t1(c1 NUMERIC NOT NULL);
4235 SHOW TABLES;
4236 Tables_in_test
4237 t1
4238 SHOW CREATE TABLE t1;
4239 Table Create Table
4240 t1 CREATE TABLE `t1` (
4241 `c1` decimal(10,0) NOT NULL
4242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4243 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4244 Warnings:
4245 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4246 SHOW TABLES;
4247 Tables_in_test
4248 t1
4249 SHOW CREATE TABLE t1;
4250 Table Create Table
4251 t1 CREATE TABLE `t1` (
4252 `c1` decimal(10,0) NOT NULL,
4253 KEY `i1` (`c1`)
4254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4255 DROP TABLE t1;
4256 SHOW TABLES;
4257 Tables_in_test
4258 CREATE TABLE t1(c1 DATE NOT NULL);
4259 SHOW TABLES;
4260 Tables_in_test
4261 t1
4262 SHOW CREATE TABLE t1;
4263 Table Create Table
4264 t1 CREATE TABLE `t1` (
4265 `c1` date NOT NULL
4266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4267 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4268 Warnings:
4269 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4270 SHOW TABLES;
4271 Tables_in_test
4272 t1
4273 SHOW CREATE TABLE t1;
4274 Table Create Table
4275 t1 CREATE TABLE `t1` (
4276 `c1` date NOT NULL,
4277 KEY `i1` (`c1`)
4278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4279 DROP TABLE t1;
4280 SHOW TABLES;
4281 Tables_in_test
4282 CREATE TABLE t1(c1 TIME NOT NULL);
4283 SHOW TABLES;
4284 Tables_in_test
4285 t1
4286 SHOW CREATE TABLE t1;
4287 Table Create Table
4288 t1 CREATE TABLE `t1` (
4289 `c1` time NOT NULL
4290 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4291 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4292 Warnings:
4293 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4294 SHOW TABLES;
4295 Tables_in_test
4296 t1
4297 SHOW CREATE TABLE t1;
4298 Table Create Table
4299 t1 CREATE TABLE `t1` (
4300 `c1` time NOT NULL,
4301 KEY `i1` (`c1`)
4302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4303 DROP TABLE t1;
4304 SHOW TABLES;
4305 Tables_in_test
4306 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
4307 SHOW TABLES;
4308 Tables_in_test
4309 t1
4310 SHOW CREATE TABLE t1;
4311 Table Create Table
4312 t1 CREATE TABLE `t1` (
4313 `c1` timestamp NOT NULL
4314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4315 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4316 Warnings:
4317 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4318 SHOW TABLES;
4319 Tables_in_test
4320 t1
4321 SHOW CREATE TABLE t1;
4322 Table Create Table
4323 t1 CREATE TABLE `t1` (
4324 `c1` timestamp NOT NULL,
4325 KEY `i1` (`c1`)
4326 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4327 DROP TABLE t1;
4328 SHOW TABLES;
4329 Tables_in_test
4330 CREATE TABLE t1(c1 YEAR NOT NULL);
4331 SHOW TABLES;
4332 Tables_in_test
4333 t1
4334 SHOW CREATE TABLE t1;
4335 Table Create Table
4336 t1 CREATE TABLE `t1` (
4337 `c1` year NOT NULL
4338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4339 ALTER TABLE t1 ADD INDEX i1 USING HASH (c1);
4340 Warnings:
4341 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
4342 SHOW TABLES;
4343 Tables_in_test
4344 t1
4345 SHOW CREATE TABLE t1;
4346 Table Create Table
4347 t1 CREATE TABLE `t1` (
4348 `c1` year NOT NULL,
4349 KEY `i1` (`c1`)
4350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4351 DROP TABLE t1;
4352 SHOW TABLES;
4353 Tables_in_test