1DROP TABLE IF EXISTS t1;
2CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
3SHOW CREATE TABLE t1;
4Table	Create Table
5t1	CREATE TABLE `t1` (
6  `c1` tinyint NOT NULL AUTO_INCREMENT,
7  PRIMARY KEY (`c1`)
8) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
9INSERT INTO t1 VALUES(null);
10INSERT INTO t1 VALUES(null);
11INSERT INTO t1 VALUES(null);
12SELECT * FROM t1;
13c1
1410
1511
1612
17DROP TABLE t1;
18SHOW TABLES;
19Tables_in_test
20CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
21SHOW CREATE TABLE t1;
22Table	Create Table
23t1	CREATE TABLE `t1` (
24  `c1` smallint NOT NULL AUTO_INCREMENT,
25  PRIMARY KEY (`c1`)
26) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27INSERT INTO t1 VALUES(null);
28INSERT INTO t1 VALUES(null);
29INSERT INTO t1 VALUES(null);
30SELECT * FROM t1;
31c1
3210
3311
3412
35DROP TABLE t1;
36SHOW TABLES;
37Tables_in_test
38CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
39SHOW CREATE TABLE t1;
40Table	Create Table
41t1	CREATE TABLE `t1` (
42  `c1` mediumint NOT NULL AUTO_INCREMENT,
43  PRIMARY KEY (`c1`)
44) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
45INSERT INTO t1 VALUES(null);
46INSERT INTO t1 VALUES(null);
47INSERT INTO t1 VALUES(null);
48SELECT * FROM t1;
49c1
5010
5111
5212
53DROP TABLE t1;
54SHOW TABLES;
55Tables_in_test
56CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
57SHOW CREATE TABLE t1;
58Table	Create Table
59t1	CREATE TABLE `t1` (
60  `c1` int NOT NULL AUTO_INCREMENT,
61  PRIMARY KEY (`c1`)
62) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
63INSERT INTO t1 VALUES(null);
64INSERT INTO t1 VALUES(null);
65INSERT INTO t1 VALUES(null);
66SELECT * FROM t1;
67c1
6810
6911
7012
71DROP TABLE t1;
72SHOW TABLES;
73Tables_in_test
74CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
75SHOW CREATE TABLE t1;
76Table	Create Table
77t1	CREATE TABLE `t1` (
78  `c1` int NOT NULL AUTO_INCREMENT,
79  PRIMARY KEY (`c1`)
80) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
81INSERT INTO t1 VALUES(null);
82INSERT INTO t1 VALUES(null);
83INSERT INTO t1 VALUES(null);
84SELECT * FROM t1;
85c1
8610
8711
8812
89DROP TABLE t1;
90SHOW TABLES;
91Tables_in_test
92CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
93SHOW CREATE TABLE t1;
94Table	Create Table
95t1	CREATE TABLE `t1` (
96  `c1` bigint NOT NULL AUTO_INCREMENT,
97  PRIMARY KEY (`c1`)
98) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99INSERT INTO t1 VALUES(null);
100INSERT INTO t1 VALUES(null);
101INSERT INTO t1 VALUES(null);
102SELECT * FROM t1;
103c1
10410
10511
10612
107DROP TABLE t1;
108SHOW TABLES;
109Tables_in_test
110CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
111SHOW CREATE TABLE t1;
112Table	Create Table
113t1	CREATE TABLE `t1` (
114  `c1` tinyint NOT NULL AUTO_INCREMENT,
115  PRIMARY KEY (`c1`)
116) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117INSERT INTO t1 VALUES(null);
118INSERT INTO t1 VALUES(null);
119INSERT INTO t1 VALUES(null);
120SELECT * FROM t1;
121c1
12210
12311
12412
125DROP TABLE t1;
126SHOW TABLES;
127Tables_in_test
128CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
129SHOW CREATE TABLE t1;
130Table	Create Table
131t1	CREATE TABLE `t1` (
132  `c1` smallint NOT NULL AUTO_INCREMENT,
133  PRIMARY KEY (`c1`)
134) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
135INSERT INTO t1 VALUES(null);
136INSERT INTO t1 VALUES(null);
137INSERT INTO t1 VALUES(null);
138SELECT * FROM t1;
139c1
14010
14111
14212
143DROP TABLE t1;
144SHOW TABLES;
145Tables_in_test
146CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
147SHOW CREATE TABLE t1;
148Table	Create Table
149t1	CREATE TABLE `t1` (
150  `c1` mediumint NOT NULL AUTO_INCREMENT,
151  PRIMARY KEY (`c1`)
152) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153INSERT INTO t1 VALUES(null);
154INSERT INTO t1 VALUES(null);
155INSERT INTO t1 VALUES(null);
156SELECT * FROM t1;
157c1
15810
15911
16012
161DROP TABLE t1;
162SHOW TABLES;
163Tables_in_test
164CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
165SHOW CREATE TABLE t1;
166Table	Create Table
167t1	CREATE TABLE `t1` (
168  `c1` int NOT NULL AUTO_INCREMENT,
169  PRIMARY KEY (`c1`)
170) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
171INSERT INTO t1 VALUES(null);
172INSERT INTO t1 VALUES(null);
173INSERT INTO t1 VALUES(null);
174SELECT * FROM t1;
175c1
17610
17711
17812
179DROP TABLE t1;
180SHOW TABLES;
181Tables_in_test
182CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
183SHOW CREATE TABLE t1;
184Table	Create Table
185t1	CREATE TABLE `t1` (
186  `c1` int NOT NULL AUTO_INCREMENT,
187  PRIMARY KEY (`c1`)
188) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
189INSERT INTO t1 VALUES(null);
190INSERT INTO t1 VALUES(null);
191INSERT INTO t1 VALUES(null);
192SELECT * FROM t1;
193c1
19410
19511
19612
197DROP TABLE t1;
198SHOW TABLES;
199Tables_in_test
200CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
201SHOW CREATE TABLE t1;
202Table	Create Table
203t1	CREATE TABLE `t1` (
204  `c1` bigint NOT NULL AUTO_INCREMENT,
205  PRIMARY KEY (`c1`)
206) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
207INSERT INTO t1 VALUES(null);
208INSERT INTO t1 VALUES(null);
209INSERT INTO t1 VALUES(null);
210SELECT * FROM t1;
211c1
21210
21311
21412
215DROP TABLE t1;
216SHOW TABLES;
217Tables_in_test
218CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
219SHOW CREATE TABLE t1;
220Table	Create Table
221t1	CREATE TABLE `t1` (
222  `c1` tinyint AUTO_INCREMENT,
223  UNIQUE KEY `c1` (`c1`)
224) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
225INSERT INTO t1 VALUES(null);
226INSERT INTO t1 VALUES(null);
227INSERT INTO t1 VALUES(null);
228SELECT * FROM t1;
229c1
230NULL
231NULL
232NULL
233DROP TABLE t1;
234SHOW TABLES;
235Tables_in_test
236CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
237SHOW CREATE TABLE t1;
238Table	Create Table
239t1	CREATE TABLE `t1` (
240  `c1` smallint AUTO_INCREMENT,
241  UNIQUE KEY `c1` (`c1`)
242) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
243INSERT INTO t1 VALUES(null);
244INSERT INTO t1 VALUES(null);
245INSERT INTO t1 VALUES(null);
246SELECT * FROM t1;
247c1
248NULL
249NULL
250NULL
251DROP TABLE t1;
252SHOW TABLES;
253Tables_in_test
254CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
255SHOW CREATE TABLE t1;
256Table	Create Table
257t1	CREATE TABLE `t1` (
258  `c1` mediumint AUTO_INCREMENT,
259  UNIQUE KEY `c1` (`c1`)
260) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
261INSERT INTO t1 VALUES(null);
262INSERT INTO t1 VALUES(null);
263INSERT INTO t1 VALUES(null);
264SELECT * FROM t1;
265c1
266NULL
267NULL
268NULL
269DROP TABLE t1;
270SHOW TABLES;
271Tables_in_test
272CREATE TABLE t1(c1 INT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
273SHOW CREATE TABLE t1;
274Table	Create Table
275t1	CREATE TABLE `t1` (
276  `c1` int AUTO_INCREMENT,
277  UNIQUE KEY `c1` (`c1`)
278) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279INSERT INTO t1 VALUES(null);
280INSERT INTO t1 VALUES(null);
281INSERT INTO t1 VALUES(null);
282SELECT * FROM t1;
283c1
284NULL
285NULL
286NULL
287DROP TABLE t1;
288SHOW TABLES;
289Tables_in_test
290CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
291SHOW CREATE TABLE t1;
292Table	Create Table
293t1	CREATE TABLE `t1` (
294  `c1` int AUTO_INCREMENT,
295  UNIQUE KEY `c1` (`c1`)
296) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297INSERT INTO t1 VALUES(null);
298INSERT INTO t1 VALUES(null);
299INSERT INTO t1 VALUES(null);
300SELECT * FROM t1;
301c1
302NULL
303NULL
304NULL
305DROP TABLE t1;
306SHOW TABLES;
307Tables_in_test
308CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
309SHOW CREATE TABLE t1;
310Table	Create Table
311t1	CREATE TABLE `t1` (
312  `c1` bigint AUTO_INCREMENT,
313  UNIQUE KEY `c1` (`c1`)
314) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
315INSERT INTO t1 VALUES(null);
316INSERT INTO t1 VALUES(null);
317INSERT INTO t1 VALUES(null);
318SELECT * FROM t1;
319c1
320NULL
321NULL
322NULL
323DROP TABLE t1;
324SHOW TABLES;
325Tables_in_test
326CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
327SHOW CREATE TABLE t1;
328Table	Create Table
329t1	CREATE TABLE `t1` (
330  `c1` tinyint NOT NULL AUTO_INCREMENT,
331  UNIQUE KEY `c1` (`c1`)
332) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
333INSERT INTO t1 VALUES(null);
334INSERT INTO t1 VALUES(null);
335INSERT INTO t1 VALUES(null);
336SELECT * FROM t1;
337c1
33810
33911
34012
341DROP TABLE t1;
342SHOW TABLES;
343Tables_in_test
344CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
345SHOW CREATE TABLE t1;
346Table	Create Table
347t1	CREATE TABLE `t1` (
348  `c1` smallint NOT NULL AUTO_INCREMENT,
349  UNIQUE KEY `c1` (`c1`)
350) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351INSERT INTO t1 VALUES(null);
352INSERT INTO t1 VALUES(null);
353INSERT INTO t1 VALUES(null);
354SELECT * FROM t1;
355c1
35610
35711
35812
359DROP TABLE t1;
360SHOW TABLES;
361Tables_in_test
362CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
363SHOW CREATE TABLE t1;
364Table	Create Table
365t1	CREATE TABLE `t1` (
366  `c1` mediumint NOT NULL AUTO_INCREMENT,
367  UNIQUE KEY `c1` (`c1`)
368) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
369INSERT INTO t1 VALUES(null);
370INSERT INTO t1 VALUES(null);
371INSERT INTO t1 VALUES(null);
372SELECT * FROM t1;
373c1
37410
37511
37612
377DROP TABLE t1;
378SHOW TABLES;
379Tables_in_test
380CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
381SHOW CREATE TABLE t1;
382Table	Create Table
383t1	CREATE TABLE `t1` (
384  `c1` int NOT NULL AUTO_INCREMENT,
385  UNIQUE KEY `c1` (`c1`)
386) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
387INSERT INTO t1 VALUES(null);
388INSERT INTO t1 VALUES(null);
389INSERT INTO t1 VALUES(null);
390SELECT * FROM t1;
391c1
39210
39311
39412
395DROP TABLE t1;
396SHOW TABLES;
397Tables_in_test
398CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
399SHOW CREATE TABLE t1;
400Table	Create Table
401t1	CREATE TABLE `t1` (
402  `c1` int NOT NULL AUTO_INCREMENT,
403  UNIQUE KEY `c1` (`c1`)
404) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
405INSERT INTO t1 VALUES(null);
406INSERT INTO t1 VALUES(null);
407INSERT INTO t1 VALUES(null);
408SELECT * FROM t1;
409c1
41010
41111
41212
413DROP TABLE t1;
414SHOW TABLES;
415Tables_in_test
416CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
417SHOW CREATE TABLE t1;
418Table	Create Table
419t1	CREATE TABLE `t1` (
420  `c1` bigint NOT NULL AUTO_INCREMENT,
421  UNIQUE KEY `c1` (`c1`)
422) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
423INSERT INTO t1 VALUES(null);
424INSERT INTO t1 VALUES(null);
425INSERT INTO t1 VALUES(null);
426SELECT * FROM t1;
427c1
42810
42911
43012
431DROP TABLE t1;
432SHOW TABLES;
433Tables_in_test
434CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
435SHOW CREATE TABLE t1;
436Table	Create Table
437t1	CREATE TABLE `t1` (
438  `c1` tinyint NOT NULL AUTO_INCREMENT,
439  PRIMARY KEY (`c1`)
440) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
441INSERT INTO t1 VALUES(null);
442INSERT INTO t1 VALUES(null);
443INSERT INTO t1 VALUES(null);
444SELECT * FROM t1;
445c1
44610
44711
44812
449DROP TABLE t1;
450SHOW TABLES;
451Tables_in_test
452CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
453SHOW CREATE TABLE t1;
454Table	Create Table
455t1	CREATE TABLE `t1` (
456  `c1` smallint NOT NULL AUTO_INCREMENT,
457  PRIMARY KEY (`c1`)
458) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
459INSERT INTO t1 VALUES(null);
460INSERT INTO t1 VALUES(null);
461INSERT INTO t1 VALUES(null);
462SELECT * FROM t1;
463c1
46410
46511
46612
467DROP TABLE t1;
468SHOW TABLES;
469Tables_in_test
470CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
471SHOW CREATE TABLE t1;
472Table	Create Table
473t1	CREATE TABLE `t1` (
474  `c1` mediumint NOT NULL AUTO_INCREMENT,
475  PRIMARY KEY (`c1`)
476) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
477INSERT INTO t1 VALUES(null);
478INSERT INTO t1 VALUES(null);
479INSERT INTO t1 VALUES(null);
480SELECT * FROM t1;
481c1
48210
48311
48412
485DROP TABLE t1;
486SHOW TABLES;
487Tables_in_test
488CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
489SHOW CREATE TABLE t1;
490Table	Create Table
491t1	CREATE TABLE `t1` (
492  `c1` int NOT NULL AUTO_INCREMENT,
493  PRIMARY KEY (`c1`)
494) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495INSERT INTO t1 VALUES(null);
496INSERT INTO t1 VALUES(null);
497INSERT INTO t1 VALUES(null);
498SELECT * FROM t1;
499c1
50010
50111
50212
503DROP TABLE t1;
504SHOW TABLES;
505Tables_in_test
506CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
507SHOW CREATE TABLE t1;
508Table	Create Table
509t1	CREATE TABLE `t1` (
510  `c1` int NOT NULL AUTO_INCREMENT,
511  PRIMARY KEY (`c1`)
512) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
513INSERT INTO t1 VALUES(null);
514INSERT INTO t1 VALUES(null);
515INSERT INTO t1 VALUES(null);
516SELECT * FROM t1;
517c1
51810
51911
52012
521DROP TABLE t1;
522SHOW TABLES;
523Tables_in_test
524CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
525SHOW CREATE TABLE t1;
526Table	Create Table
527t1	CREATE TABLE `t1` (
528  `c1` bigint NOT NULL AUTO_INCREMENT,
529  PRIMARY KEY (`c1`)
530) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
531INSERT INTO t1 VALUES(null);
532INSERT INTO t1 VALUES(null);
533INSERT INTO t1 VALUES(null);
534SELECT * FROM t1;
535c1
53610
53711
53812
539DROP TABLE t1;
540SHOW TABLES;
541Tables_in_test
542CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
543SHOW CREATE TABLE t1;
544Table	Create Table
545t1	CREATE TABLE `t1` (
546  `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
547  PRIMARY KEY (`c1`)
548) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549INSERT INTO t1 VALUES(null);
550INSERT INTO t1 VALUES(null);
551INSERT INTO t1 VALUES(null);
552SELECT * FROM t1;
553c1
55410
55511
55612
557DROP TABLE t1;
558SHOW TABLES;
559Tables_in_test
560CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
561SHOW CREATE TABLE t1;
562Table	Create Table
563t1	CREATE TABLE `t1` (
564  `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
565  PRIMARY KEY (`c1`)
566) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
567INSERT INTO t1 VALUES(null);
568INSERT INTO t1 VALUES(null);
569INSERT INTO t1 VALUES(null);
570SELECT * FROM t1;
571c1
57210
57311
57412
575DROP TABLE t1;
576SHOW TABLES;
577Tables_in_test
578CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
579SHOW CREATE TABLE t1;
580Table	Create Table
581t1	CREATE TABLE `t1` (
582  `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
583  PRIMARY KEY (`c1`)
584) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
585INSERT INTO t1 VALUES(null);
586INSERT INTO t1 VALUES(null);
587INSERT INTO t1 VALUES(null);
588SELECT * FROM t1;
589c1
59010
59111
59212
593DROP TABLE t1;
594SHOW TABLES;
595Tables_in_test
596CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
597SHOW CREATE TABLE t1;
598Table	Create Table
599t1	CREATE TABLE `t1` (
600  `c1` int unsigned NOT NULL AUTO_INCREMENT,
601  PRIMARY KEY (`c1`)
602) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
603INSERT INTO t1 VALUES(null);
604INSERT INTO t1 VALUES(null);
605INSERT INTO t1 VALUES(null);
606SELECT * FROM t1;
607c1
60810
60911
61012
611DROP TABLE t1;
612SHOW TABLES;
613Tables_in_test
614CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
615SHOW CREATE TABLE t1;
616Table	Create Table
617t1	CREATE TABLE `t1` (
618  `c1` int unsigned NOT NULL AUTO_INCREMENT,
619  PRIMARY KEY (`c1`)
620) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
621INSERT INTO t1 VALUES(null);
622INSERT INTO t1 VALUES(null);
623INSERT INTO t1 VALUES(null);
624SELECT * FROM t1;
625c1
62610
62711
62812
629DROP TABLE t1;
630SHOW TABLES;
631Tables_in_test
632CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
633SHOW CREATE TABLE t1;
634Table	Create Table
635t1	CREATE TABLE `t1` (
636  `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
637  PRIMARY KEY (`c1`)
638) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
639INSERT INTO t1 VALUES(null);
640INSERT INTO t1 VALUES(null);
641INSERT INTO t1 VALUES(null);
642SELECT * FROM t1;
643c1
64410
64511
64612
647DROP TABLE t1;
648SHOW TABLES;
649Tables_in_test
650CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
651SHOW CREATE TABLE t1;
652Table	Create Table
653t1	CREATE TABLE `t1` (
654  `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
655  PRIMARY KEY (`c1`)
656) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
657INSERT INTO t1 VALUES(null);
658INSERT INTO t1 VALUES(null);
659INSERT INTO t1 VALUES(null);
660SELECT * FROM t1;
661c1
66210
66311
66412
665DROP TABLE t1;
666SHOW TABLES;
667Tables_in_test
668CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
669SHOW CREATE TABLE t1;
670Table	Create Table
671t1	CREATE TABLE `t1` (
672  `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
673  PRIMARY KEY (`c1`)
674) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
675INSERT INTO t1 VALUES(null);
676INSERT INTO t1 VALUES(null);
677INSERT INTO t1 VALUES(null);
678SELECT * FROM t1;
679c1
68010
68111
68212
683DROP TABLE t1;
684SHOW TABLES;
685Tables_in_test
686CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
687SHOW CREATE TABLE t1;
688Table	Create Table
689t1	CREATE TABLE `t1` (
690  `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
691  PRIMARY KEY (`c1`)
692) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693INSERT INTO t1 VALUES(null);
694INSERT INTO t1 VALUES(null);
695INSERT INTO t1 VALUES(null);
696SELECT * FROM t1;
697c1
69810
69911
70012
701DROP TABLE t1;
702SHOW TABLES;
703Tables_in_test
704CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
705SHOW CREATE TABLE t1;
706Table	Create Table
707t1	CREATE TABLE `t1` (
708  `c1` int unsigned NOT NULL AUTO_INCREMENT,
709  PRIMARY KEY (`c1`)
710) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
711INSERT INTO t1 VALUES(null);
712INSERT INTO t1 VALUES(null);
713INSERT INTO t1 VALUES(null);
714SELECT * FROM t1;
715c1
71610
71711
71812
719DROP TABLE t1;
720SHOW TABLES;
721Tables_in_test
722CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
723SHOW CREATE TABLE t1;
724Table	Create Table
725t1	CREATE TABLE `t1` (
726  `c1` int unsigned NOT NULL AUTO_INCREMENT,
727  PRIMARY KEY (`c1`)
728) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
729INSERT INTO t1 VALUES(null);
730INSERT INTO t1 VALUES(null);
731INSERT INTO t1 VALUES(null);
732SELECT * FROM t1;
733c1
73410
73511
73612
737DROP TABLE t1;
738SHOW TABLES;
739Tables_in_test
740CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
741SHOW CREATE TABLE t1;
742Table	Create Table
743t1	CREATE TABLE `t1` (
744  `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
745  PRIMARY KEY (`c1`)
746) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
747INSERT INTO t1 VALUES(null);
748INSERT INTO t1 VALUES(null);
749INSERT INTO t1 VALUES(null);
750SELECT * FROM t1;
751c1
75210
75311
75412
755DROP TABLE t1;
756SHOW TABLES;
757Tables_in_test
758CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
759SHOW CREATE TABLE t1;
760Table	Create Table
761t1	CREATE TABLE `t1` (
762  `c1` tinyint unsigned AUTO_INCREMENT,
763  UNIQUE KEY `c1` (`c1`)
764) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
765INSERT INTO t1 VALUES(null);
766INSERT INTO t1 VALUES(null);
767INSERT INTO t1 VALUES(null);
768SELECT * FROM t1;
769c1
770NULL
771NULL
772NULL
773DROP TABLE t1;
774SHOW TABLES;
775Tables_in_test
776CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
777SHOW CREATE TABLE t1;
778Table	Create Table
779t1	CREATE TABLE `t1` (
780  `c1` smallint unsigned AUTO_INCREMENT,
781  UNIQUE KEY `c1` (`c1`)
782) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
783INSERT INTO t1 VALUES(null);
784INSERT INTO t1 VALUES(null);
785INSERT INTO t1 VALUES(null);
786SELECT * FROM t1;
787c1
788NULL
789NULL
790NULL
791DROP TABLE t1;
792SHOW TABLES;
793Tables_in_test
794CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
795SHOW CREATE TABLE t1;
796Table	Create Table
797t1	CREATE TABLE `t1` (
798  `c1` mediumint unsigned AUTO_INCREMENT,
799  UNIQUE KEY `c1` (`c1`)
800) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
801INSERT INTO t1 VALUES(null);
802INSERT INTO t1 VALUES(null);
803INSERT INTO t1 VALUES(null);
804SELECT * FROM t1;
805c1
806NULL
807NULL
808NULL
809DROP TABLE t1;
810SHOW TABLES;
811Tables_in_test
812CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
813SHOW CREATE TABLE t1;
814Table	Create Table
815t1	CREATE TABLE `t1` (
816  `c1` int unsigned AUTO_INCREMENT,
817  UNIQUE KEY `c1` (`c1`)
818) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
819INSERT INTO t1 VALUES(null);
820INSERT INTO t1 VALUES(null);
821INSERT INTO t1 VALUES(null);
822SELECT * FROM t1;
823c1
824NULL
825NULL
826NULL
827DROP TABLE t1;
828SHOW TABLES;
829Tables_in_test
830CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
831SHOW CREATE TABLE t1;
832Table	Create Table
833t1	CREATE TABLE `t1` (
834  `c1` int unsigned AUTO_INCREMENT,
835  UNIQUE KEY `c1` (`c1`)
836) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
837INSERT INTO t1 VALUES(null);
838INSERT INTO t1 VALUES(null);
839INSERT INTO t1 VALUES(null);
840SELECT * FROM t1;
841c1
842NULL
843NULL
844NULL
845DROP TABLE t1;
846SHOW TABLES;
847Tables_in_test
848CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
849SHOW CREATE TABLE t1;
850Table	Create Table
851t1	CREATE TABLE `t1` (
852  `c1` bigint unsigned AUTO_INCREMENT,
853  UNIQUE KEY `c1` (`c1`)
854) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
855INSERT INTO t1 VALUES(null);
856INSERT INTO t1 VALUES(null);
857INSERT INTO t1 VALUES(null);
858SELECT * FROM t1;
859c1
860NULL
861NULL
862NULL
863DROP TABLE t1;
864SHOW TABLES;
865Tables_in_test
866CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
867SHOW CREATE TABLE t1;
868Table	Create Table
869t1	CREATE TABLE `t1` (
870  `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
871  UNIQUE KEY `c1` (`c1`)
872) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
873INSERT INTO t1 VALUES(null);
874INSERT INTO t1 VALUES(null);
875INSERT INTO t1 VALUES(null);
876SELECT * FROM t1;
877c1
87810
87911
88012
881DROP TABLE t1;
882SHOW TABLES;
883Tables_in_test
884CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
885SHOW CREATE TABLE t1;
886Table	Create Table
887t1	CREATE TABLE `t1` (
888  `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
889  UNIQUE KEY `c1` (`c1`)
890) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
891INSERT INTO t1 VALUES(null);
892INSERT INTO t1 VALUES(null);
893INSERT INTO t1 VALUES(null);
894SELECT * FROM t1;
895c1
89610
89711
89812
899DROP TABLE t1;
900SHOW TABLES;
901Tables_in_test
902CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
903SHOW CREATE TABLE t1;
904Table	Create Table
905t1	CREATE TABLE `t1` (
906  `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
907  UNIQUE KEY `c1` (`c1`)
908) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
909INSERT INTO t1 VALUES(null);
910INSERT INTO t1 VALUES(null);
911INSERT INTO t1 VALUES(null);
912SELECT * FROM t1;
913c1
91410
91511
91612
917DROP TABLE t1;
918SHOW TABLES;
919Tables_in_test
920CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
921SHOW CREATE TABLE t1;
922Table	Create Table
923t1	CREATE TABLE `t1` (
924  `c1` int unsigned NOT NULL AUTO_INCREMENT,
925  UNIQUE KEY `c1` (`c1`)
926) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
927INSERT INTO t1 VALUES(null);
928INSERT INTO t1 VALUES(null);
929INSERT INTO t1 VALUES(null);
930SELECT * FROM t1;
931c1
93210
93311
93412
935DROP TABLE t1;
936SHOW TABLES;
937Tables_in_test
938CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
939SHOW CREATE TABLE t1;
940Table	Create Table
941t1	CREATE TABLE `t1` (
942  `c1` int unsigned NOT NULL AUTO_INCREMENT,
943  UNIQUE KEY `c1` (`c1`)
944) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
945INSERT INTO t1 VALUES(null);
946INSERT INTO t1 VALUES(null);
947INSERT INTO t1 VALUES(null);
948SELECT * FROM t1;
949c1
95010
95111
95212
953DROP TABLE t1;
954SHOW TABLES;
955Tables_in_test
956CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
957SHOW CREATE TABLE t1;
958Table	Create Table
959t1	CREATE TABLE `t1` (
960  `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
961  UNIQUE KEY `c1` (`c1`)
962) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
963INSERT INTO t1 VALUES(null);
964INSERT INTO t1 VALUES(null);
965INSERT INTO t1 VALUES(null);
966SELECT * FROM t1;
967c1
96810
96911
97012
971DROP TABLE t1;
972SHOW TABLES;
973Tables_in_test
974CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
975SHOW CREATE TABLE t1;
976Table	Create Table
977t1	CREATE TABLE `t1` (
978  `c1` tinyint unsigned NOT NULL AUTO_INCREMENT,
979  PRIMARY KEY (`c1`)
980) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
981INSERT INTO t1 VALUES(null);
982INSERT INTO t1 VALUES(null);
983INSERT INTO t1 VALUES(null);
984SELECT * FROM t1;
985c1
98610
98711
98812
989DROP TABLE t1;
990SHOW TABLES;
991Tables_in_test
992CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
993SHOW CREATE TABLE t1;
994Table	Create Table
995t1	CREATE TABLE `t1` (
996  `c1` smallint unsigned NOT NULL AUTO_INCREMENT,
997  PRIMARY KEY (`c1`)
998) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
999INSERT INTO t1 VALUES(null);
1000INSERT INTO t1 VALUES(null);
1001INSERT INTO t1 VALUES(null);
1002SELECT * FROM t1;
1003c1
100410
100511
100612
1007DROP TABLE t1;
1008SHOW TABLES;
1009Tables_in_test
1010CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1011SHOW CREATE TABLE t1;
1012Table	Create Table
1013t1	CREATE TABLE `t1` (
1014  `c1` mediumint unsigned NOT NULL AUTO_INCREMENT,
1015  PRIMARY KEY (`c1`)
1016) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1017INSERT INTO t1 VALUES(null);
1018INSERT INTO t1 VALUES(null);
1019INSERT INTO t1 VALUES(null);
1020SELECT * FROM t1;
1021c1
102210
102311
102412
1025DROP TABLE t1;
1026SHOW TABLES;
1027Tables_in_test
1028CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1029SHOW CREATE TABLE t1;
1030Table	Create Table
1031t1	CREATE TABLE `t1` (
1032  `c1` int unsigned NOT NULL AUTO_INCREMENT,
1033  PRIMARY KEY (`c1`)
1034) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1035INSERT INTO t1 VALUES(null);
1036INSERT INTO t1 VALUES(null);
1037INSERT INTO t1 VALUES(null);
1038SELECT * FROM t1;
1039c1
104010
104111
104212
1043DROP TABLE t1;
1044SHOW TABLES;
1045Tables_in_test
1046CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1047SHOW CREATE TABLE t1;
1048Table	Create Table
1049t1	CREATE TABLE `t1` (
1050  `c1` int unsigned NOT NULL AUTO_INCREMENT,
1051  PRIMARY KEY (`c1`)
1052) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1053INSERT INTO t1 VALUES(null);
1054INSERT INTO t1 VALUES(null);
1055INSERT INTO t1 VALUES(null);
1056SELECT * FROM t1;
1057c1
105810
105911
106012
1061DROP TABLE t1;
1062SHOW TABLES;
1063Tables_in_test
1064CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1065SHOW CREATE TABLE t1;
1066Table	Create Table
1067t1	CREATE TABLE `t1` (
1068  `c1` bigint unsigned NOT NULL AUTO_INCREMENT,
1069  PRIMARY KEY (`c1`)
1070) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1071INSERT INTO t1 VALUES(null);
1072INSERT INTO t1 VALUES(null);
1073INSERT INTO t1 VALUES(null);
1074SELECT * FROM t1;
1075c1
107610
107711
107812
1079DROP TABLE t1;
1080SHOW TABLES;
1081Tables_in_test
1082