Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL, INDEX i1 (c1));
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 KEY `i1` (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t1 DROP KEY i1;
13 SHOW TABLES;
14 Tables_in_test
15 t1
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` char(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t1 DROP KEY i1;
35 SHOW TABLES;
36 Tables_in_test
37 t1
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `c1` varchar(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
55 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 ALTER TABLE t1 DROP KEY i1;
57 SHOW TABLES;
58 Tables_in_test
59 t1
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `c1` binary(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
77 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
78 ALTER TABLE t1 DROP KEY i1;
79 SHOW TABLES;
80 Tables_in_test
81 t1
82 SHOW CREATE TABLE t1;
83 Table Create Table
84 t1 CREATE TABLE `t1` (
85 `c1` varbinary(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 ALTER TABLE t1 DROP KEY i1;
101 SHOW TABLES;
102 Tables_in_test
103 t1
104 SHOW CREATE TABLE t1;
105 Table Create Table
106 t1 CREATE TABLE `t1` (
107 `c1` char(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 ALTER TABLE t1 DROP KEY i1;
123 SHOW TABLES;
124 Tables_in_test
125 t1
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TABLE `t1` (
129 `c1` varchar(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 ALTER TABLE t1 DROP KEY i1;
145 SHOW TABLES;
146 Tables_in_test
147 t1
148 SHOW CREATE TABLE t1;
149 Table Create Table
150 t1 CREATE TABLE `t1` (
151 `c1` binary(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
166 ALTER TABLE t1 DROP KEY i1;
167 SHOW TABLES;
168 Tables_in_test
169 t1
170 SHOW CREATE TABLE t1;
171 Table Create Table
172 t1 CREATE TABLE `t1` (
173 `c1` varbinary(30) NOT NULL
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, INDEX i1 (c1));
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 KEY `i1` (`c1`)
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
188 ALTER TABLE t1 DROP KEY i1;
189 SHOW TABLES;
190 Tables_in_test
191 t1
192 SHOW CREATE TABLE t1;
193 Table Create Table
194 t1 CREATE TABLE `t1` (
195 `c1` char(30) NOT NULL
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 VARCHAR(30) NOT NULL, INDEX i1 (c1));
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` varchar(30) NOT NULL,
208 KEY `i1` (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t1 DROP KEY i1;
211 SHOW TABLES;
212 Tables_in_test
213 t1
214 SHOW CREATE TABLE t1;
215 Table Create Table
216 t1 CREATE TABLE `t1` (
217 `c1` varchar(30) NOT NULL
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 BINARY(30) NOT NULL, INDEX i1 (c1));
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` binary(30) NOT NULL,
230 KEY `i1` (`c1`)
231 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 ALTER TABLE t1 DROP KEY i1;
233 SHOW TABLES;
234 Tables_in_test
235 t1
236 SHOW CREATE TABLE t1;
237 Table Create Table
238 t1 CREATE TABLE `t1` (
239 `c1` binary(30) NOT NULL
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 VARBINARY(30) NOT NULL, INDEX i1 (c1));
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` varbinary(30) NOT NULL,
252 KEY `i1` (`c1`)
253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
254 ALTER TABLE t1 DROP KEY i1;
255 SHOW TABLES;
256 Tables_in_test
257 t1
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TABLE `t1` (
261 `c1` varbinary(30) NOT NULL
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 CHAR(30) NOT NULL, INDEX i1 (c1));
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` char(30) NOT NULL,
274 KEY `i1` (`c1`)
275 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
276 ALTER TABLE t1 DROP INDEX i1;
277 SHOW TABLES;
278 Tables_in_test
279 t1
280 SHOW CREATE TABLE t1;
281 Table Create Table
282 t1 CREATE TABLE `t1` (
283 `c1` char(30) NOT NULL
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 VARCHAR(30) NOT NULL, INDEX i1 (c1));
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` varchar(30) NOT NULL,
296 KEY `i1` (`c1`)
297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 ALTER TABLE t1 DROP INDEX i1;
299 SHOW TABLES;
300 Tables_in_test
301 t1
302 SHOW CREATE TABLE t1;
303 Table Create Table
304 t1 CREATE TABLE `t1` (
305 `c1` varchar(30) NOT NULL
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 BINARY(30) NOT NULL, INDEX i1 (c1));
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` binary(30) NOT NULL,
318 KEY `i1` (`c1`)
319 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
320 ALTER TABLE t1 DROP INDEX i1;
321 SHOW TABLES;
322 Tables_in_test
323 t1
324 SHOW CREATE TABLE t1;
325 Table Create Table
326 t1 CREATE TABLE `t1` (
327 `c1` binary(30) NOT NULL
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 VARBINARY(30) NOT NULL, INDEX i1 (c1));
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` varbinary(30) NOT NULL,
340 KEY `i1` (`c1`)
341 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
342 ALTER TABLE t1 DROP INDEX i1;
343 SHOW TABLES;
344 Tables_in_test
345 t1
346 SHOW CREATE TABLE t1;
347 Table Create Table
348 t1 CREATE TABLE `t1` (
349 `c1` varbinary(30) NOT NULL
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 CHAR(30) NOT NULL, INDEX i1 (c1));
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` char(30) NOT NULL,
362 KEY `i1` (`c1`)
363 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
364 ALTER TABLE t1 DROP INDEX i1;
365 SHOW TABLES;
366 Tables_in_test
367 t1
368 SHOW CREATE TABLE t1;
369 Table Create Table
370 t1 CREATE TABLE `t1` (
371 `c1` char(30) NOT NULL
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 VARCHAR(30) NOT NULL, INDEX i1 (c1));
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` varchar(30) NOT NULL,
384 KEY `i1` (`c1`)
385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
386 ALTER TABLE t1 DROP INDEX i1;
387 SHOW TABLES;
388 Tables_in_test
389 t1
390 SHOW CREATE TABLE t1;
391 Table Create Table
392 t1 CREATE TABLE `t1` (
393 `c1` varchar(30) NOT NULL
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 BINARY(30) NOT NULL, INDEX i1 (c1));
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` binary(30) NOT NULL,
406 KEY `i1` (`c1`)
407 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
408 ALTER TABLE t1 DROP INDEX i1;
409 SHOW TABLES;
410 Tables_in_test
411 t1
412 SHOW CREATE TABLE t1;
413 Table Create Table
414 t1 CREATE TABLE `t1` (
415 `c1` binary(30) NOT NULL
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 VARBINARY(30) NOT NULL, INDEX i1 (c1));
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` varbinary(30) NOT NULL,
428 KEY `i1` (`c1`)
429 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
430 ALTER TABLE t1 DROP INDEX i1;
431 SHOW TABLES;
432 Tables_in_test
433 t1
434 SHOW CREATE TABLE t1;
435 Table Create Table
436 t1 CREATE TABLE `t1` (
437 `c1` varbinary(30) NOT NULL
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 CHAR(30) NOT NULL, INDEX i1 (c1));
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` char(30) NOT NULL,
450 KEY `i1` (`c1`)
451 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
452 ALTER TABLE t1 DROP INDEX i1;
453 SHOW TABLES;
454 Tables_in_test
455 t1
456 SHOW CREATE TABLE t1;
457 Table Create Table
458 t1 CREATE TABLE `t1` (
459 `c1` char(30) NOT NULL
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 VARCHAR(30) NOT NULL, INDEX i1 (c1));
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` varchar(30) NOT NULL,
472 KEY `i1` (`c1`)
473 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
474 ALTER TABLE t1 DROP INDEX i1;
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 DROP TABLE t1;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t1(c1 BINARY(30) NOT NULL, INDEX i1 (c1));
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` binary(30) NOT NULL,
494 KEY `i1` (`c1`)
495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
496 ALTER TABLE t1 DROP INDEX i1;
497 SHOW TABLES;
498 Tables_in_test
499 t1
500 SHOW CREATE TABLE t1;
501 Table Create Table
502 t1 CREATE TABLE `t1` (
503 `c1` binary(30) NOT NULL
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 VARBINARY(30) NOT NULL, INDEX i1 (c1));
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` varbinary(30) NOT NULL,
516 KEY `i1` (`c1`)
517 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
518 ALTER TABLE t1 DROP INDEX i1;
519 SHOW TABLES;
520 Tables_in_test
521 t1
522 SHOW CREATE TABLE t1;
523 Table Create Table
524 t1 CREATE TABLE `t1` (
525 `c1` varbinary(30) NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t1;
528 SHOW TABLES;
529 Tables_in_test