Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
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 `c2` char(30) DEFAULT NULL
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t1 DROP c2;
13 ALTER TABLE t1 DROP c1;
14 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `c1` char(30) NOT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
20 DROP TABLE t1;
21 SHOW TABLES;
22 Tables_in_test
23 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
24 SHOW TABLES;
25 Tables_in_test
26 t1
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `c1` varchar(30) NOT NULL,
31 `c2` varchar(30) DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t1 DROP c2;
34 ALTER TABLE t1 DROP c1;
35 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
36 SHOW CREATE TABLE t1;
37 Table Create Table
38 t1 CREATE TABLE `t1` (
39 `c1` varchar(30) NOT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
41 DROP TABLE t1;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
45 SHOW TABLES;
46 Tables_in_test
47 t1
48 SHOW CREATE TABLE t1;
49 Table Create Table
50 t1 CREATE TABLE `t1` (
51 `c1` binary(30) NOT NULL,
52 `c2` binary(30) DEFAULT NULL
53 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
54 ALTER TABLE t1 DROP c2;
55 ALTER TABLE t1 DROP c1;
56 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
57 SHOW CREATE TABLE t1;
58 Table Create Table
59 t1 CREATE TABLE `t1` (
60 `c1` binary(30) NOT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
62 DROP TABLE t1;
63 SHOW TABLES;
64 Tables_in_test
65 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
66 SHOW TABLES;
67 Tables_in_test
68 t1
69 SHOW CREATE TABLE t1;
70 Table Create Table
71 t1 CREATE TABLE `t1` (
72 `c1` varbinary(30) NOT NULL,
73 `c2` varbinary(30) DEFAULT NULL
74 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
75 ALTER TABLE t1 DROP c2;
76 ALTER TABLE t1 DROP c1;
77 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
78 SHOW CREATE TABLE t1;
79 Table Create Table
80 t1 CREATE TABLE `t1` (
81 `c1` varbinary(30) NOT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t1;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
87 SHOW TABLES;
88 Tables_in_test
89 t1
90 SHOW CREATE TABLE t1;
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `c1` char(30) NOT NULL,
94 `c2` char(30) DEFAULT NULL
95 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
96 ALTER TABLE t1 DROP COLUMN c2;
97 ALTER TABLE t1 DROP COLUMN c1;
98 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
99 SHOW CREATE TABLE t1;
100 Table Create Table
101 t1 CREATE TABLE `t1` (
102 `c1` char(30) NOT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
104 DROP TABLE t1;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
108 SHOW TABLES;
109 Tables_in_test
110 t1
111 SHOW CREATE TABLE t1;
112 Table Create Table
113 t1 CREATE TABLE `t1` (
114 `c1` varchar(30) NOT NULL,
115 `c2` varchar(30) DEFAULT NULL
116 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117 ALTER TABLE t1 DROP COLUMN c2;
118 ALTER TABLE t1 DROP COLUMN c1;
119 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
120 SHOW CREATE TABLE t1;
121 Table Create Table
122 t1 CREATE TABLE `t1` (
123 `c1` varchar(30) NOT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
125 DROP TABLE t1;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
129 SHOW TABLES;
130 Tables_in_test
131 t1
132 SHOW CREATE TABLE t1;
133 Table Create Table
134 t1 CREATE TABLE `t1` (
135 `c1` binary(30) NOT NULL,
136 `c2` binary(30) DEFAULT NULL
137 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
138 ALTER TABLE t1 DROP COLUMN c2;
139 ALTER TABLE t1 DROP COLUMN c1;
140 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
141 SHOW CREATE TABLE t1;
142 Table Create Table
143 t1 CREATE TABLE `t1` (
144 `c1` binary(30) NOT NULL
145 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
146 DROP TABLE t1;
147 SHOW TABLES;
148 Tables_in_test
149 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
150 SHOW TABLES;
151 Tables_in_test
152 t1
153 SHOW CREATE TABLE t1;
154 Table Create Table
155 t1 CREATE TABLE `t1` (
156 `c1` varbinary(30) NOT NULL,
157 `c2` varbinary(30) DEFAULT NULL
158 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
159 ALTER TABLE t1 DROP COLUMN c2;
160 ALTER TABLE t1 DROP COLUMN c1;
161 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
162 SHOW CREATE TABLE t1;
163 Table Create Table
164 t1 CREATE TABLE `t1` (
165 `c1` varbinary(30) NOT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t1;
168 SHOW TABLES;
169 Tables_in_test