Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t9;
2 CREATE TABLE t9(c1 BIT NOT NULL PRIMARY KEY);
3 SHOW TABLES;
4 Tables_in_test
5 t9
6 SHOW CREATE TABLE t9;
7 Table Create Table
8 t9 CREATE TABLE `t9` (
9 `c1` bit(1) NOT NULL,
10 PRIMARY KEY (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t9 DROP PRIMARY KEY;
13 SHOW TABLES;
14 Tables_in_test
15 t9
16 SHOW CREATE TABLE t9;
17 Table Create Table
18 t9 CREATE TABLE `t9` (
19 `c1` bit(1) NOT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t9;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t9(c1 TINYINT NOT NULL PRIMARY KEY);
25 SHOW TABLES;
26 Tables_in_test
27 t9
28 SHOW CREATE TABLE t9;
29 Table Create Table
30 t9 CREATE TABLE `t9` (
31 `c1` tinyint NOT NULL,
32 PRIMARY KEY (`c1`)
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t9 DROP PRIMARY KEY;
35 SHOW TABLES;
36 Tables_in_test
37 t9
38 SHOW CREATE TABLE t9;
39 Table Create Table
40 t9 CREATE TABLE `t9` (
41 `c1` tinyint NOT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t9;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t9(c1 SMALLINT NOT NULL PRIMARY KEY);
47 SHOW TABLES;
48 Tables_in_test
49 t9
50 SHOW CREATE TABLE t9;
51 Table Create Table
52 t9 CREATE TABLE `t9` (
53 `c1` smallint NOT NULL,
54 PRIMARY KEY (`c1`)
55 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 ALTER TABLE t9 DROP PRIMARY KEY;
57 SHOW TABLES;
58 Tables_in_test
59 t9
60 SHOW CREATE TABLE t9;
61 Table Create Table
62 t9 CREATE TABLE `t9` (
63 `c1` smallint NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t9;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t9(c1 MEDIUMINT NOT NULL PRIMARY KEY);
69 SHOW TABLES;
70 Tables_in_test
71 t9
72 SHOW CREATE TABLE t9;
73 Table Create Table
74 t9 CREATE TABLE `t9` (
75 `c1` mediumint NOT NULL,
76 PRIMARY KEY (`c1`)
77 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
78 ALTER TABLE t9 DROP PRIMARY KEY;
79 SHOW TABLES;
80 Tables_in_test
81 t9
82 SHOW CREATE TABLE t9;
83 Table Create Table
84 t9 CREATE TABLE `t9` (
85 `c1` mediumint NOT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t9;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t9(c1 INT NOT NULL PRIMARY KEY);
91 SHOW TABLES;
92 Tables_in_test
93 t9
94 SHOW CREATE TABLE t9;
95 Table Create Table
96 t9 CREATE TABLE `t9` (
97 `c1` int NOT NULL,
98 PRIMARY KEY (`c1`)
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 ALTER TABLE t9 DROP PRIMARY KEY;
101 SHOW TABLES;
102 Tables_in_test
103 t9
104 SHOW CREATE TABLE t9;
105 Table Create Table
106 t9 CREATE TABLE `t9` (
107 `c1` int NOT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t9;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t9(c1 INTEGER NOT NULL PRIMARY KEY);
113 SHOW TABLES;
114 Tables_in_test
115 t9
116 SHOW CREATE TABLE t9;
117 Table Create Table
118 t9 CREATE TABLE `t9` (
119 `c1` int NOT NULL,
120 PRIMARY KEY (`c1`)
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 ALTER TABLE t9 DROP PRIMARY KEY;
123 SHOW TABLES;
124 Tables_in_test
125 t9
126 SHOW CREATE TABLE t9;
127 Table Create Table
128 t9 CREATE TABLE `t9` (
129 `c1` int NOT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t9;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t9(c1 BIGINT NOT NULL PRIMARY KEY);
135 SHOW TABLES;
136 Tables_in_test
137 t9
138 SHOW CREATE TABLE t9;
139 Table Create Table
140 t9 CREATE TABLE `t9` (
141 `c1` bigint NOT NULL,
142 PRIMARY KEY (`c1`)
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 ALTER TABLE t9 DROP PRIMARY KEY;
145 SHOW TABLES;
146 Tables_in_test
147 t9
148 SHOW CREATE TABLE t9;
149 Table Create Table
150 t9 CREATE TABLE `t9` (
151 `c1` bigint NOT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t9;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t9(c1 REAL NOT NULL PRIMARY KEY);
157 SHOW TABLES;
158 Tables_in_test
159 t9
160 SHOW CREATE TABLE t9;
161 Table Create Table
162 t9 CREATE TABLE `t9` (
163 `c1` double NOT NULL,
164 PRIMARY KEY (`c1`)
165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
166 ALTER TABLE t9 DROP PRIMARY KEY;
167 SHOW TABLES;
168 Tables_in_test
169 t9
170 SHOW CREATE TABLE t9;
171 Table Create Table
172 t9 CREATE TABLE `t9` (
173 `c1` double NOT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t9;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t9(c1 DOUBLE NOT NULL PRIMARY KEY);
179 SHOW TABLES;
180 Tables_in_test
181 t9
182 SHOW CREATE TABLE t9;
183 Table Create Table
184 t9 CREATE TABLE `t9` (
185 `c1` double NOT NULL,
186 PRIMARY KEY (`c1`)
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
188 ALTER TABLE t9 DROP PRIMARY KEY;
189 SHOW TABLES;
190 Tables_in_test
191 t9
192 SHOW CREATE TABLE t9;
193 Table Create Table
194 t9 CREATE TABLE `t9` (
195 `c1` double NOT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t9;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t9(c1 FLOAT NOT NULL PRIMARY KEY);
201 SHOW TABLES;
202 Tables_in_test
203 t9
204 SHOW CREATE TABLE t9;
205 Table Create Table
206 t9 CREATE TABLE `t9` (
207 `c1` float NOT NULL,
208 PRIMARY KEY (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t9 DROP PRIMARY KEY;
211 SHOW TABLES;
212 Tables_in_test
213 t9
214 SHOW CREATE TABLE t9;
215 Table Create Table
216 t9 CREATE TABLE `t9` (
217 `c1` float NOT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t9;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t9(c1 DECIMAL NOT NULL PRIMARY KEY);
223 SHOW TABLES;
224 Tables_in_test
225 t9
226 SHOW CREATE TABLE t9;
227 Table Create Table
228 t9 CREATE TABLE `t9` (
229 `c1` decimal(10,0) NOT NULL,
230 PRIMARY KEY (`c1`)
231 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 ALTER TABLE t9 DROP PRIMARY KEY;
233 SHOW TABLES;
234 Tables_in_test
235 t9
236 SHOW CREATE TABLE t9;
237 Table Create Table
238 t9 CREATE TABLE `t9` (
239 `c1` decimal(10,0) NOT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t9;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t9(c1 NUMERIC NOT NULL PRIMARY KEY);
245 SHOW TABLES;
246 Tables_in_test
247 t9
248 SHOW CREATE TABLE t9;
249 Table Create Table
250 t9 CREATE TABLE `t9` (
251 `c1` decimal(10,0) NOT NULL,
252 PRIMARY KEY (`c1`)
253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
254 ALTER TABLE t9 DROP PRIMARY KEY;
255 SHOW TABLES;
256 Tables_in_test
257 t9
258 SHOW CREATE TABLE t9;
259 Table Create Table
260 t9 CREATE TABLE `t9` (
261 `c1` decimal(10,0) NOT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t9;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t9(c1 DATE NOT NULL PRIMARY KEY);
267 SHOW TABLES;
268 Tables_in_test
269 t9
270 SHOW CREATE TABLE t9;
271 Table Create Table
272 t9 CREATE TABLE `t9` (
273 `c1` date NOT NULL,
274 PRIMARY KEY (`c1`)
275 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
276 ALTER TABLE t9 DROP PRIMARY KEY;
277 SHOW TABLES;
278 Tables_in_test
279 t9
280 SHOW CREATE TABLE t9;
281 Table Create Table
282 t9 CREATE TABLE `t9` (
283 `c1` date NOT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t9;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t9(c1 TIME NOT NULL PRIMARY KEY);
289 SHOW TABLES;
290 Tables_in_test
291 t9
292 SHOW CREATE TABLE t9;
293 Table Create Table
294 t9 CREATE TABLE `t9` (
295 `c1` time NOT NULL,
296 PRIMARY KEY (`c1`)
297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 ALTER TABLE t9 DROP PRIMARY KEY;
299 SHOW TABLES;
300 Tables_in_test
301 t9
302 SHOW CREATE TABLE t9;
303 Table Create Table
304 t9 CREATE TABLE `t9` (
305 `c1` time NOT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t9;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t9(c1 TIMESTAMP NOT NULL PRIMARY KEY);
311 SHOW TABLES;
312 Tables_in_test
313 t9
314 SHOW CREATE TABLE t9;
315 Table Create Table
316 t9 CREATE TABLE `t9` (
317 `c1` timestamp NOT NULL,
318 PRIMARY KEY (`c1`)
319 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
320 ALTER TABLE t9 DROP PRIMARY KEY;
321 SHOW TABLES;
322 Tables_in_test
323 t9
324 SHOW CREATE TABLE t9;
325 Table Create Table
326 t9 CREATE TABLE `t9` (
327 `c1` timestamp NOT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t9;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t9(c1 YEAR NOT NULL PRIMARY KEY);
333 SHOW TABLES;
334 Tables_in_test
335 t9
336 SHOW CREATE TABLE t9;
337 Table Create Table
338 t9 CREATE TABLE `t9` (
339 `c1` year NOT NULL,
340 PRIMARY KEY (`c1`)
341 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
342 ALTER TABLE t9 DROP PRIMARY KEY;
343 SHOW TABLES;
344 Tables_in_test
345 t9
346 SHOW CREATE TABLE t9;
347 Table Create Table
348 t9 CREATE TABLE `t9` (
349 `c1` year NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t9;
352 SHOW TABLES;
353 Tables_in_test