Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t9;
2 CREATE TABLE t9(c1 CHAR(20) 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` char(20) 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` char(20) 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 VARCHAR(20) 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` varchar(20) 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` varchar(20) 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 BINARY(20) 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` binary(20) 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` binary(20) 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 VARBINARY(20) 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` varbinary(20) 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` varbinary(20) NOT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t9;
88 SHOW TABLES;
89 Tables_in_test