Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t8;
2 CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
3 SHOW TABLES;
4 Tables_in_test
5 t8
6 SHOW CREATE TABLE t8;
7 Table Create Table
8 t8 CREATE TABLE `t8` (
9 `c1` tinyint NOT NULL AUTO_INCREMENT,
10 PRIMARY KEY (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t8 MODIFY c1 TINYINT NOT NULL, DROP PRIMARY KEY;
13 SHOW TABLES;
14 Tables_in_test
15 t8
16 SHOW CREATE TABLE t8;
17 Table Create Table
18 t8 CREATE TABLE `t8` (
19 `c1` tinyint NOT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t8;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
25 SHOW TABLES;
26 Tables_in_test
27 t8
28 SHOW CREATE TABLE t8;
29 Table Create Table
30 t8 CREATE TABLE `t8` (
31 `c1` smallint NOT NULL AUTO_INCREMENT,
32 PRIMARY KEY (`c1`)
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t8 MODIFY c1 SMALLINT NOT NULL, DROP PRIMARY KEY;
35 SHOW TABLES;
36 Tables_in_test
37 t8
38 SHOW CREATE TABLE t8;
39 Table Create Table
40 t8 CREATE TABLE `t8` (
41 `c1` smallint NOT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t8;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
47 SHOW TABLES;
48 Tables_in_test
49 t8
50 SHOW CREATE TABLE t8;
51 Table Create Table
52 t8 CREATE TABLE `t8` (
53 `c1` mediumint NOT NULL AUTO_INCREMENT,
54 PRIMARY KEY (`c1`)
55 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 ALTER TABLE t8 MODIFY c1 MEDIUMINT NOT NULL, DROP PRIMARY KEY;
57 SHOW TABLES;
58 Tables_in_test
59 t8
60 SHOW CREATE TABLE t8;
61 Table Create Table
62 t8 CREATE TABLE `t8` (
63 `c1` mediumint NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t8;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
69 SHOW TABLES;
70 Tables_in_test
71 t8
72 SHOW CREATE TABLE t8;
73 Table Create Table
74 t8 CREATE TABLE `t8` (
75 `c1` int NOT NULL AUTO_INCREMENT,
76 PRIMARY KEY (`c1`)
77 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
78 ALTER TABLE t8 MODIFY c1 INT NOT NULL, DROP PRIMARY KEY;
79 SHOW TABLES;
80 Tables_in_test
81 t8
82 SHOW CREATE TABLE t8;
83 Table Create Table
84 t8 CREATE TABLE `t8` (
85 `c1` int NOT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t8;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
91 SHOW TABLES;
92 Tables_in_test
93 t8
94 SHOW CREATE TABLE t8;
95 Table Create Table
96 t8 CREATE TABLE `t8` (
97 `c1` int NOT NULL AUTO_INCREMENT,
98 PRIMARY KEY (`c1`)
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 ALTER TABLE t8 MODIFY c1 INTEGER NOT NULL, DROP PRIMARY KEY;
101 SHOW TABLES;
102 Tables_in_test
103 t8
104 SHOW CREATE TABLE t8;
105 Table Create Table
106 t8 CREATE TABLE `t8` (
107 `c1` int NOT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t8;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
113 SHOW TABLES;
114 Tables_in_test
115 t8
116 SHOW CREATE TABLE t8;
117 Table Create Table
118 t8 CREATE TABLE `t8` (
119 `c1` bigint NOT NULL AUTO_INCREMENT,
120 PRIMARY KEY (`c1`)
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 ALTER TABLE t8 MODIFY c1 BIGINT NOT NULL, DROP PRIMARY KEY;
123 SHOW TABLES;
124 Tables_in_test
125 t8
126 SHOW CREATE TABLE t8;
127 Table Create Table
128 t8 CREATE TABLE `t8` (
129 `c1` bigint NOT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t8;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
135 SHOW TABLES;
136 Tables_in_test
137 t8
138 SHOW CREATE TABLE t8;
139 Table Create Table
140 t8 CREATE TABLE `t8` (
141 `c1` tinyint NOT NULL AUTO_INCREMENT,
142 PRIMARY KEY (`c1`)
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 ALTER TABLE t8 CHANGE c1 c1 TINYINT NOT NULL, DROP PRIMARY KEY;
145 SHOW TABLES;
146 Tables_in_test
147 t8
148 SHOW CREATE TABLE t8;
149 Table Create Table
150 t8 CREATE TABLE `t8` (
151 `c1` tinyint NOT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t8;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
157 SHOW TABLES;
158 Tables_in_test
159 t8
160 SHOW CREATE TABLE t8;
161 Table Create Table
162 t8 CREATE TABLE `t8` (
163 `c1` smallint NOT NULL AUTO_INCREMENT,
164 PRIMARY KEY (`c1`)
165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
166 ALTER TABLE t8 CHANGE c1 c1 SMALLINT NOT NULL, DROP PRIMARY KEY;
167 SHOW TABLES;
168 Tables_in_test
169 t8
170 SHOW CREATE TABLE t8;
171 Table Create Table
172 t8 CREATE TABLE `t8` (
173 `c1` smallint NOT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t8;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
179 SHOW TABLES;
180 Tables_in_test
181 t8
182 SHOW CREATE TABLE t8;
183 Table Create Table
184 t8 CREATE TABLE `t8` (
185 `c1` mediumint NOT NULL AUTO_INCREMENT,
186 PRIMARY KEY (`c1`)
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
188 ALTER TABLE t8 CHANGE c1 c1 MEDIUMINT NOT NULL, DROP PRIMARY KEY;
189 SHOW TABLES;
190 Tables_in_test
191 t8
192 SHOW CREATE TABLE t8;
193 Table Create Table
194 t8 CREATE TABLE `t8` (
195 `c1` mediumint NOT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t8;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
201 SHOW TABLES;
202 Tables_in_test
203 t8
204 SHOW CREATE TABLE t8;
205 Table Create Table
206 t8 CREATE TABLE `t8` (
207 `c1` int NOT NULL AUTO_INCREMENT,
208 PRIMARY KEY (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t8 CHANGE c1 c1 INT NOT NULL, DROP PRIMARY KEY;
211 SHOW TABLES;
212 Tables_in_test
213 t8
214 SHOW CREATE TABLE t8;
215 Table Create Table
216 t8 CREATE TABLE `t8` (
217 `c1` int NOT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t8;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
223 SHOW TABLES;
224 Tables_in_test
225 t8
226 SHOW CREATE TABLE t8;
227 Table Create Table
228 t8 CREATE TABLE `t8` (
229 `c1` int NOT NULL AUTO_INCREMENT,
230 PRIMARY KEY (`c1`)
231 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 ALTER TABLE t8 CHANGE c1 c1 INTEGER NOT NULL, DROP PRIMARY KEY;
233 SHOW TABLES;
234 Tables_in_test
235 t8
236 SHOW CREATE TABLE t8;
237 Table Create Table
238 t8 CREATE TABLE `t8` (
239 `c1` int NOT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t8;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
245 SHOW TABLES;
246 Tables_in_test
247 t8
248 SHOW CREATE TABLE t8;
249 Table Create Table
250 t8 CREATE TABLE `t8` (
251 `c1` bigint NOT NULL AUTO_INCREMENT,
252 PRIMARY KEY (`c1`)
253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
254 ALTER TABLE t8 CHANGE c1 c1 BIGINT NOT NULL, DROP PRIMARY KEY;
255 SHOW TABLES;
256 Tables_in_test
257 t8
258 SHOW CREATE TABLE t8;
259 Table Create Table
260 t8 CREATE TABLE `t8` (
261 `c1` bigint NOT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t8;
264 SHOW TABLES;
265 Tables_in_test