Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) 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` char(30) 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` char(30) 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 VARCHAR(30) 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` varchar(30) 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` varchar(30) 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 BINARY(30) 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` binary(30) 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` binary(30) 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 VARBINARY(30) 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` varbinary(30) 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` varbinary(30) 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 CHAR(30) 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` char(30) NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t1 ADD KEY USING BTREE (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` char(30) NOT NULL,
107 KEY `c1` (`c1`) USING BTREE
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 VARCHAR(30) 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` varchar(30) NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t1 ADD KEY USING BTREE (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` varchar(30) NOT NULL,
129 KEY `c1` (`c1`) USING BTREE
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 BINARY(30) 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` binary(30) NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t1 ADD KEY USING BTREE (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` binary(30) NOT NULL,
151 KEY `c1` (`c1`) USING BTREE
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 VARBINARY(30) 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` varbinary(30) NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t1 ADD KEY USING BTREE (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` varbinary(30) NOT NULL,
173 KEY `c1` (`c1`) USING BTREE
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 CHAR(30) 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` char(30) NOT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t1 ADD KEY USING HASH (c1);
188 Warnings:
189 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
190 SHOW TABLES;
191 Tables_in_test
192 t1
193 SHOW CREATE TABLE t1;
194 Table Create Table
195 t1 CREATE TABLE `t1` (
196 `c1` char(30) NOT NULL,
197 KEY `c1` (`c1`)
198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
199 DROP TABLE t1;
200 SHOW TABLES;
201 Tables_in_test
202 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
203 SHOW TABLES;
204 Tables_in_test
205 t1
206 SHOW CREATE TABLE t1;
207 Table Create Table
208 t1 CREATE TABLE `t1` (
209 `c1` varchar(30) NOT NULL
210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
211 ALTER TABLE t1 ADD KEY USING HASH (c1);
212 Warnings:
213 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
214 SHOW TABLES;
215 Tables_in_test
216 t1
217 SHOW CREATE TABLE t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `c1` varchar(30) NOT NULL,
221 KEY `c1` (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t1;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
227 SHOW TABLES;
228 Tables_in_test
229 t1
230 SHOW CREATE TABLE t1;
231 Table Create Table
232 t1 CREATE TABLE `t1` (
233 `c1` binary(30) NOT NULL
234 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
235 ALTER TABLE t1 ADD KEY USING HASH (c1);
236 Warnings:
237 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
238 SHOW TABLES;
239 Tables_in_test
240 t1
241 SHOW CREATE TABLE t1;
242 Table Create Table
243 t1 CREATE TABLE `t1` (
244 `c1` binary(30) NOT NULL,
245 KEY `c1` (`c1`)
246 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
247 DROP TABLE t1;
248 SHOW TABLES;
249 Tables_in_test
250 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
251 SHOW TABLES;
252 Tables_in_test
253 t1
254 SHOW CREATE TABLE t1;
255 Table Create Table
256 t1 CREATE TABLE `t1` (
257 `c1` varbinary(30) NOT NULL
258 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
259 ALTER TABLE t1 ADD KEY USING HASH (c1);
260 Warnings:
261 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
262 SHOW TABLES;
263 Tables_in_test
264 t1
265 SHOW CREATE TABLE t1;
266 Table Create Table
267 t1 CREATE TABLE `t1` (
268 `c1` varbinary(30) NOT NULL,
269 KEY `c1` (`c1`)
270 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
271 DROP TABLE t1;
272 SHOW TABLES;
273 Tables_in_test
274 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
275 SHOW TABLES;
276 Tables_in_test
277 t1
278 SHOW CREATE TABLE t1;
279 Table Create Table
280 t1 CREATE TABLE `t1` (
281 `c1` char(30) NOT NULL
282 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
283 ALTER TABLE t1 ADD INDEX (c1);
284 SHOW TABLES;
285 Tables_in_test
286 t1
287 SHOW CREATE TABLE t1;
288 Table Create Table
289 t1 CREATE TABLE `t1` (
290 `c1` char(30) NOT NULL,
291 KEY `c1` (`c1`)
292 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
293 DROP TABLE t1;
294 SHOW TABLES;
295 Tables_in_test
296 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
297 SHOW TABLES;
298 Tables_in_test
299 t1
300 SHOW CREATE TABLE t1;
301 Table Create Table
302 t1 CREATE TABLE `t1` (
303 `c1` varchar(30) NOT NULL
304 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
305 ALTER TABLE t1 ADD INDEX (c1);
306 SHOW TABLES;
307 Tables_in_test
308 t1
309 SHOW CREATE TABLE t1;
310 Table Create Table
311 t1 CREATE TABLE `t1` (
312 `c1` varchar(30) NOT NULL,
313 KEY `c1` (`c1`)
314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
315 DROP TABLE t1;
316 SHOW TABLES;
317 Tables_in_test
318 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
319 SHOW TABLES;
320 Tables_in_test
321 t1
322 SHOW CREATE TABLE t1;
323 Table Create Table
324 t1 CREATE TABLE `t1` (
325 `c1` binary(30) NOT NULL
326 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
327 ALTER TABLE t1 ADD INDEX (c1);
328 SHOW TABLES;
329 Tables_in_test
330 t1
331 SHOW CREATE TABLE t1;
332 Table Create Table
333 t1 CREATE TABLE `t1` (
334 `c1` binary(30) NOT NULL,
335 KEY `c1` (`c1`)
336 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
337 DROP TABLE t1;
338 SHOW TABLES;
339 Tables_in_test
340 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
341 SHOW TABLES;
342 Tables_in_test
343 t1
344 SHOW CREATE TABLE t1;
345 Table Create Table
346 t1 CREATE TABLE `t1` (
347 `c1` varbinary(30) NOT NULL
348 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
349 ALTER TABLE t1 ADD INDEX (c1);
350 SHOW TABLES;
351 Tables_in_test
352 t1
353 SHOW CREATE TABLE t1;
354 Table Create Table
355 t1 CREATE TABLE `t1` (
356 `c1` varbinary(30) NOT NULL,
357 KEY `c1` (`c1`)
358 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
359 DROP TABLE t1;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
363 SHOW TABLES;
364 Tables_in_test
365 t1
366 SHOW CREATE TABLE t1;
367 Table Create Table
368 t1 CREATE TABLE `t1` (
369 `c1` char(30) NOT NULL
370 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
371 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
372 SHOW TABLES;
373 Tables_in_test
374 t1
375 SHOW CREATE TABLE t1;
376 Table Create Table
377 t1 CREATE TABLE `t1` (
378 `c1` char(30) NOT NULL,
379 KEY `c1` (`c1`) USING BTREE
380 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
381 DROP TABLE t1;
382 SHOW TABLES;
383 Tables_in_test
384 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
385 SHOW TABLES;
386 Tables_in_test
387 t1
388 SHOW CREATE TABLE t1;
389 Table Create Table
390 t1 CREATE TABLE `t1` (
391 `c1` varchar(30) NOT NULL
392 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
393 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
394 SHOW TABLES;
395 Tables_in_test
396 t1
397 SHOW CREATE TABLE t1;
398 Table Create Table
399 t1 CREATE TABLE `t1` (
400 `c1` varchar(30) NOT NULL,
401 KEY `c1` (`c1`) USING BTREE
402 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
403 DROP TABLE t1;
404 SHOW TABLES;
405 Tables_in_test
406 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
407 SHOW TABLES;
408 Tables_in_test
409 t1
410 SHOW CREATE TABLE t1;
411 Table Create Table
412 t1 CREATE TABLE `t1` (
413 `c1` binary(30) NOT NULL
414 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
415 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
416 SHOW TABLES;
417 Tables_in_test
418 t1
419 SHOW CREATE TABLE t1;
420 Table Create Table
421 t1 CREATE TABLE `t1` (
422 `c1` binary(30) NOT NULL,
423 KEY `c1` (`c1`) USING BTREE
424 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
425 DROP TABLE t1;
426 SHOW TABLES;
427 Tables_in_test
428 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
429 SHOW TABLES;
430 Tables_in_test
431 t1
432 SHOW CREATE TABLE t1;
433 Table Create Table
434 t1 CREATE TABLE `t1` (
435 `c1` varbinary(30) NOT NULL
436 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
437 ALTER TABLE t1 ADD INDEX USING BTREE (c1);
438 SHOW TABLES;
439 Tables_in_test
440 t1
441 SHOW CREATE TABLE t1;
442 Table Create Table
443 t1 CREATE TABLE `t1` (
444 `c1` varbinary(30) NOT NULL,
445 KEY `c1` (`c1`) USING BTREE
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE t1;
448 SHOW TABLES;
449 Tables_in_test
450 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
451 SHOW TABLES;
452 Tables_in_test
453 t1
454 SHOW CREATE TABLE t1;
455 Table Create Table
456 t1 CREATE TABLE `t1` (
457 `c1` char(30) NOT NULL
458 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
459 ALTER TABLE t1 ADD INDEX USING HASH (c1);
460 Warnings:
461 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
462 SHOW TABLES;
463 Tables_in_test
464 t1
465 SHOW CREATE TABLE t1;
466 Table Create Table
467 t1 CREATE TABLE `t1` (
468 `c1` char(30) NOT NULL,
469 KEY `c1` (`c1`)
470 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
471 DROP TABLE t1;
472 SHOW TABLES;
473 Tables_in_test
474 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
475 SHOW TABLES;
476 Tables_in_test
477 t1
478 SHOW CREATE TABLE t1;
479 Table Create Table
480 t1 CREATE TABLE `t1` (
481 `c1` varchar(30) NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 ALTER TABLE t1 ADD INDEX USING HASH (c1);
484 Warnings:
485 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
486 SHOW TABLES;
487 Tables_in_test
488 t1
489 SHOW CREATE TABLE t1;
490 Table Create Table
491 t1 CREATE TABLE `t1` (
492 `c1` varchar(30) NOT NULL,
493 KEY `c1` (`c1`)
494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495 DROP TABLE t1;
496 SHOW TABLES;
497 Tables_in_test
498 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
499 SHOW TABLES;
500 Tables_in_test
501 t1
502 SHOW CREATE TABLE t1;
503 Table Create Table
504 t1 CREATE TABLE `t1` (
505 `c1` binary(30) NOT NULL
506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
507 ALTER TABLE t1 ADD INDEX USING HASH (c1);
508 Warnings:
509 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
510 SHOW TABLES;
511 Tables_in_test
512 t1
513 SHOW CREATE TABLE t1;
514 Table Create Table
515 t1 CREATE TABLE `t1` (
516 `c1` binary(30) NOT NULL,
517 KEY `c1` (`c1`)
518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
519 DROP TABLE t1;
520 SHOW TABLES;
521 Tables_in_test
522 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
523 SHOW TABLES;
524 Tables_in_test
525 t1
526 SHOW CREATE TABLE t1;
527 Table Create Table
528 t1 CREATE TABLE `t1` (
529 `c1` varbinary(30) NOT NULL
530 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
531 ALTER TABLE t1 ADD INDEX USING HASH (c1);
532 Warnings:
533 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
534 SHOW TABLES;
535 Tables_in_test
536 t1
537 SHOW CREATE TABLE t1;
538 Table Create Table
539 t1 CREATE TABLE `t1` (
540 `c1` varbinary(30) NOT NULL,
541 KEY `c1` (`c1`)
542 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
543 DROP TABLE t1;
544 SHOW TABLES;
545 Tables_in_test
546 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
547 SHOW TABLES;
548 Tables_in_test
549 t1
550 SHOW CREATE TABLE t1;
551 Table Create Table
552 t1 CREATE TABLE `t1` (
553 `c1` char(30) NOT NULL
554 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
555 ALTER TABLE t1 ADD KEY i1 (c1);
556 SHOW TABLES;
557 Tables_in_test
558 t1
559 SHOW CREATE TABLE t1;
560 Table Create Table
561 t1 CREATE TABLE `t1` (
562 `c1` char(30) NOT NULL,
563 KEY `i1` (`c1`)
564 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
565 DROP TABLE t1;
566 SHOW TABLES;
567 Tables_in_test
568 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
569 SHOW TABLES;
570 Tables_in_test
571 t1
572 SHOW CREATE TABLE t1;
573 Table Create Table
574 t1 CREATE TABLE `t1` (
575 `c1` varchar(30) NOT NULL
576 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
577 ALTER TABLE t1 ADD KEY i1 (c1);
578 SHOW TABLES;
579 Tables_in_test
580 t1
581 SHOW CREATE TABLE t1;
582 Table Create Table
583 t1 CREATE TABLE `t1` (
584 `c1` varchar(30) NOT NULL,
585 KEY `i1` (`c1`)
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
587 DROP TABLE t1;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t1
594 SHOW CREATE TABLE t1;
595 Table Create Table
596 t1 CREATE TABLE `t1` (
597 `c1` binary(30) NOT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
599 ALTER TABLE t1 ADD KEY i1 (c1);
600 SHOW TABLES;
601 Tables_in_test
602 t1
603 SHOW CREATE TABLE t1;
604 Table Create Table
605 t1 CREATE TABLE `t1` (
606 `c1` binary(30) NOT NULL,
607 KEY `i1` (`c1`)
608 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 DROP TABLE t1;
610 SHOW TABLES;
611 Tables_in_test
612 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
613 SHOW TABLES;
614 Tables_in_test
615 t1
616 SHOW CREATE TABLE t1;
617 Table Create Table
618 t1 CREATE TABLE `t1` (
619 `c1` varbinary(30) NOT NULL
620 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
621 ALTER TABLE t1 ADD KEY i1 (c1);
622 SHOW TABLES;
623 Tables_in_test
624 t1
625 SHOW CREATE TABLE t1;
626 Table Create Table
627 t1 CREATE TABLE `t1` (
628 `c1` varbinary(30) NOT NULL,
629 KEY `i1` (`c1`)
630 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
631 DROP TABLE t1;
632 SHOW TABLES;
633 Tables_in_test
634 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
635 SHOW TABLES;
636 Tables_in_test
637 t1
638 SHOW CREATE TABLE t1;
639 Table Create Table
640 t1 CREATE TABLE `t1` (
641 `c1` char(30) NOT NULL
642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
644 SHOW TABLES;
645 Tables_in_test
646 t1
647 SHOW CREATE TABLE t1;
648 Table Create Table
649 t1 CREATE TABLE `t1` (
650 `c1` char(30) NOT NULL,
651 KEY `i1` (`c1`) USING BTREE
652 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
653 DROP TABLE t1;
654 SHOW TABLES;
655 Tables_in_test
656 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
657 SHOW TABLES;
658 Tables_in_test
659 t1
660 SHOW CREATE TABLE t1;
661 Table Create Table
662 t1 CREATE TABLE `t1` (
663 `c1` varchar(30) NOT NULL
664 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
665 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
666 SHOW TABLES;
667 Tables_in_test
668 t1
669 SHOW CREATE TABLE t1;
670 Table Create Table
671 t1 CREATE TABLE `t1` (
672 `c1` varchar(30) NOT NULL,
673 KEY `i1` (`c1`) USING BTREE
674 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
675 DROP TABLE t1;
676 SHOW TABLES;
677 Tables_in_test
678 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
679 SHOW TABLES;
680 Tables_in_test
681 t1
682 SHOW CREATE TABLE t1;
683 Table Create Table
684 t1 CREATE TABLE `t1` (
685 `c1` binary(30) NOT NULL
686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
687 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
688 SHOW TABLES;
689 Tables_in_test
690 t1
691 SHOW CREATE TABLE t1;
692 Table Create Table
693 t1 CREATE TABLE `t1` (
694 `c1` binary(30) NOT NULL,
695 KEY `i1` (`c1`) USING BTREE
696 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
697 DROP TABLE t1;
698 SHOW TABLES;
699 Tables_in_test
700 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
701 SHOW TABLES;
702 Tables_in_test
703 t1
704 SHOW CREATE TABLE t1;
705 Table Create Table
706 t1 CREATE TABLE `t1` (
707 `c1` varbinary(30) NOT NULL
708 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
709 ALTER TABLE t1 ADD KEY i1 USING BTREE (c1);
710 SHOW TABLES;
711 Tables_in_test
712 t1
713 SHOW CREATE TABLE t1;
714 Table Create Table
715 t1 CREATE TABLE `t1` (
716 `c1` varbinary(30) NOT NULL,
717 KEY `i1` (`c1`) USING BTREE
718 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
719 DROP TABLE t1;
720 SHOW TABLES;
721 Tables_in_test
722 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
723 SHOW TABLES;
724 Tables_in_test
725 t1
726 SHOW CREATE TABLE t1;
727 Table Create Table
728 t1 CREATE TABLE `t1` (
729 `c1` char(30) NOT NULL
730 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
731 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
732 Warnings:
733 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
734 SHOW TABLES;
735 Tables_in_test
736 t1
737 SHOW CREATE TABLE t1;
738 Table Create Table
739 t1 CREATE TABLE `t1` (
740 `c1` char(30) NOT NULL,
741 KEY `i1` (`c1`)
742 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
743 DROP TABLE t1;
744 SHOW TABLES;
745 Tables_in_test
746 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
747 SHOW TABLES;
748 Tables_in_test
749 t1
750 SHOW CREATE TABLE t1;
751 Table Create Table
752 t1 CREATE TABLE `t1` (
753 `c1` varchar(30) NOT NULL
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
755 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
756 Warnings:
757 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
758 SHOW TABLES;
759 Tables_in_test
760 t1
761 SHOW CREATE TABLE t1;
762 Table Create Table
763 t1 CREATE TABLE `t1` (
764 `c1` varchar(30) NOT NULL,
765 KEY `i1` (`c1`)
766 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
767 DROP TABLE t1;
768 SHOW TABLES;
769 Tables_in_test
770 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
771 SHOW TABLES;
772 Tables_in_test
773 t1
774 SHOW CREATE TABLE t1;
775 Table Create Table
776 t1 CREATE TABLE `t1` (
777 `c1` binary(30) NOT NULL
778 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
779 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
780 Warnings:
781 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
782 SHOW TABLES;
783 Tables_in_test
784 t1
785 SHOW CREATE TABLE t1;
786 Table Create Table
787 t1 CREATE TABLE `t1` (
788 `c1` binary(30) NOT NULL,
789 KEY `i1` (`c1`)
790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
791 DROP TABLE t1;
792 SHOW TABLES;
793 Tables_in_test
794 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
795 SHOW TABLES;
796 Tables_in_test
797 t1
798 SHOW CREATE TABLE t1;
799 Table Create Table
800 t1 CREATE TABLE `t1` (
801 `c1` varbinary(30) NOT NULL
802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
803 ALTER TABLE t1 ADD KEY i1 USING HASH (c1);
804 Warnings:
805 Note 3502 This storage engine does not support the HASH index algorithm, storage engine default was used instead.
806 SHOW TABLES;
807 Tables_in_test
808 t1
809 SHOW CREATE TABLE t1;
810 Table Create Table
811 t1 CREATE TABLE `t1` (
812 `c1` varbinary(30) NOT NULL,
813 KEY `i1` (`c1`)
814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
815 DROP TABLE t1;
816 SHOW TABLES;
817 Tables_in_test
818 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
819 SHOW TABLES;
820 Tables_in_test
821 t1
822 SHOW CREATE TABLE t1;
823 Table Create Table
824 t1 CREATE TABLE `t1` (
825 `c1` char(30) NOT NULL
826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
827 ALTER TABLE t1 ADD INDEX i1 (c1);
828 SHOW TABLES;
829 Tables_in_test
830 t1
831 SHOW CREATE TABLE t1;
832 Table Create Table
833 t1 CREATE TABLE `t1` (
834 `c1` char(30) NOT NULL,
835 KEY `i1` (`c1`)
836 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
837 DROP TABLE t1;
838 SHOW TABLES;
839 Tables_in_test
840 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
841 SHOW TABLES;
842 Tables_in_test
843 t1
844 SHOW CREATE TABLE t1;
845 Table Create Table
846 t1 CREATE TABLE `t1` (
847 `c1` varchar(30) NOT NULL
848 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
849 ALTER TABLE t1 ADD INDEX i1 (c1);
850 SHOW TABLES;
851 Tables_in_test
852 t1
853 SHOW CREATE TABLE t1;
854 Table Create Table
855 t1 CREATE TABLE `t1` (
856 `c1` varchar(30) NOT NULL,
857 KEY `i1` (`c1`)
858 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
859 DROP TABLE t1;
860 SHOW TABLES;
861 Tables_in_test
862 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
863 SHOW TABLES;
864 Tables_in_test
865 t1
866 SHOW CREATE TABLE t1;
867 Table Create Table
868 t1 CREATE TABLE `t1` (
869 `c1` binary(30) NOT NULL
870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
871 ALTER TABLE t1 ADD INDEX i1 (c1);
872 SHOW TABLES;
873 Tables_in_test
874 t1
875 SHOW CREATE TABLE t1;
876 Table Create Table
877 t1 CREATE TABLE `t1` (
878 `c1` binary(30) NOT NULL,
879 KEY `i1` (`c1`)
880 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
881 DROP TABLE t1;
882 SHOW TABLES;
883 Tables_in_test
884 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
885 SHOW TABLES;
886 Tables_in_test
887 t1
888 SHOW CREATE TABLE t1;
889 Table Create Table
890 t1 CREATE TABLE `t1` (
891 `c1` varbinary(30) NOT NULL
892 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
893 ALTER TABLE t1 ADD INDEX i1 (c1);
894 SHOW TABLES;
895 Tables_in_test
896 t1
897 SHOW CREATE TABLE t1;
898 Table Create Table
899 t1 CREATE TABLE `t1` (
900 `c1` varbinary(30) NOT NULL,
901 KEY `i1` (`c1`)
902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
903 DROP TABLE t1;
904 SHOW TABLES;
905 Tables_in_test
906 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
907 SHOW TABLES;
908 Tables_in_test
909 t1
910 SHOW CREATE TABLE t1;
911 Table Create Table
912 t1 CREATE TABLE `t1` (
913 `c1` char(30) NOT NULL
914 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
915 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
916 SHOW TABLES;
917 Tables_in_test
918 t1
919 SHOW CREATE TABLE t1;
920 Table Create Table
921 t1 CREATE TABLE `t1` (
922 `c1` char(30) NOT NULL,
923 KEY `i1` (`c1`) USING BTREE
924 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
925 DROP TABLE t1;
926 SHOW TABLES;
927 Tables_in_test
928 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL);
929 SHOW TABLES;
930 Tables_in_test
931 t1
932 SHOW CREATE TABLE t1;
933 Table Create Table
934 t1 CREATE TABLE `t1` (
935 `c1` varchar(30) NOT NULL
936 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
937 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
938 SHOW TABLES;
939 Tables_in_test
940 t1
941 SHOW CREATE TABLE t1;
942 Table Create Table
943 t1 CREATE TABLE `t1` (
944 `c1` varchar(30) NOT NULL,
945 KEY `i1` (`c1`) USING BTREE
946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
947 DROP TABLE t1;
948 SHOW TABLES;
949 Tables_in_test
950 CREATE TABLE t1(c1 BINARY(30) NOT NULL);
951 SHOW TABLES;
952 Tables_in_test
953 t1
954 SHOW CREATE TABLE t1;
955 Table Create Table
956 t1 CREATE TABLE `t1` (
957 `c1` binary(30) NOT NULL
958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
959 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
960 SHOW TABLES;
961 Tables_in_test
962 t1
963 SHOW CREATE TABLE t1;
964 Table Create Table
965 t1 CREATE TABLE `t1` (
966 `c1` binary(30) NOT NULL,
967 KEY `i1` (`c1`) USING BTREE
968 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
969 DROP TABLE t1;
970 SHOW TABLES;
971 Tables_in_test
972 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL);
973 SHOW TABLES;
974 Tables_in_test
975 t1
976 SHOW CREATE TABLE t1;
977 Table Create Table
978 t1 CREATE TABLE `t1` (
979 `c1` varbinary(30) NOT NULL
980 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
981 ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1);
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` varbinary(30) NOT NULL,
989 KEY `i1` (`c1`) USING BTREE
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 CHAR(30) 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` char(30) NOT NULL
1002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1003 ALTER TABLE t1 ADD INDEX i1 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` char(30) NOT NULL,
1013 KEY `i1` (`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 VARCHAR(30) 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` varchar(30) NOT NULL
1026 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1027 ALTER TABLE t1 ADD INDEX i1 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` varchar(30) NOT NULL,
1037 KEY `i1` (`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 BINARY(30) 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` binary(30) NOT NULL
1050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1051 ALTER TABLE t1 ADD INDEX i1 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` binary(30) NOT NULL,
1061 KEY `i1` (`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 VARBINARY(30) 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` varbinary(30) NOT NULL
1074 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1075 ALTER TABLE t1 ADD INDEX i1 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` varbinary(30) NOT NULL,
1085 KEY `i1` (`c1`)
1086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1087 DROP TABLE t1;
1088 SHOW TABLES;
1089 Tables_in_test