Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_drop_column.test

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t1;
7 --enable_warnings
8 SET sql_mode='NO_ENGINE_SUBSTITUTION';
9 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t1;
13 ALTER TABLE t1 DROP c2;
14 --error 1090
15 ALTER TABLE t1 DROP c1;
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
17 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
18 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
19 SHOW TABLES;
20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21 SHOW CREATE TABLE t1;
22 ALTER TABLE t1 DROP c2;
23 --error 1090
24 ALTER TABLE t1 DROP c1;
25 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
26 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
27 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
28 SHOW TABLES;
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE t1;
31 ALTER TABLE t1 DROP c2;
32 --error 1090
33 ALTER TABLE t1 DROP c1;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
35 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
36 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
37 SHOW TABLES;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39 SHOW CREATE TABLE t1;
40 ALTER TABLE t1 DROP c2;
41 --error 1090
42 ALTER TABLE t1 DROP c1;
43 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
44 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
45 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
46 SHOW TABLES;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t1;
49 ALTER TABLE t1 DROP c2;
50 --error 1090
51 ALTER TABLE t1 DROP c1;
52 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
54 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
55 SHOW TABLES;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57 SHOW CREATE TABLE t1;
58 ALTER TABLE t1 DROP c2;
59 --error 1090
60 ALTER TABLE t1 DROP c1;
61 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
63 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
64 SHOW TABLES;
65 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
66 SHOW CREATE TABLE t1;
67 ALTER TABLE t1 DROP c2;
68 --error 1090
69 ALTER TABLE t1 DROP c1;
70 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
71 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
72 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
73 SHOW TABLES;
74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75 SHOW CREATE TABLE t1;
76 ALTER TABLE t1 DROP c2;
77 --error 1090
78 ALTER TABLE t1 DROP c1;
79 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
80 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
81 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
82 SHOW TABLES;
83 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
84 SHOW CREATE TABLE t1;
85 ALTER TABLE t1 DROP c2;
86 --error 1090
87 ALTER TABLE t1 DROP c1;
88 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
90 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
91 SHOW TABLES;
92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE t1;
94 ALTER TABLE t1 DROP c2;
95 --error 1090
96 ALTER TABLE t1 DROP c1;
97 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
98 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
99 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
100 SHOW TABLES;
101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
102 SHOW CREATE TABLE t1;
103 ALTER TABLE t1 DROP c2;
104 --error 1090
105 ALTER TABLE t1 DROP c1;
106 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
107 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
108 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
109 SHOW TABLES;
110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
111 SHOW CREATE TABLE t1;
112 ALTER TABLE t1 DROP c2;
113 --error 1090
114 ALTER TABLE t1 DROP c1;
115 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
116 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
117 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
118 SHOW TABLES;
119 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE t1;
121 ALTER TABLE t1 DROP c2;
122 --error 1090
123 ALTER TABLE t1 DROP c1;
124 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
125 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
126 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
127 SHOW TABLES;
128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129 SHOW CREATE TABLE t1;
130 ALTER TABLE t1 DROP c2;
131 --error 1090
132 ALTER TABLE t1 DROP c1;
133 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
134 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
135 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
136 SHOW TABLES;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE t1;
139 ALTER TABLE t1 DROP c2;
140 --error 1090
141 ALTER TABLE t1 DROP c1;
142 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
144 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
145 SHOW TABLES;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147 SHOW CREATE TABLE t1;
148 ALTER TABLE t1 DROP c2;
149 --error 1090
150 ALTER TABLE t1 DROP c1;
151 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
152 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
153 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
154 SHOW TABLES;
155 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
156 SHOW CREATE TABLE t1;
157 ALTER TABLE t1 DROP COLUMN c2;
158 --error 1090
159 ALTER TABLE t1 DROP COLUMN c1;
160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
161 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
162 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
163 SHOW TABLES;
164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
165 SHOW CREATE TABLE t1;
166 ALTER TABLE t1 DROP COLUMN c2;
167 --error 1090
168 ALTER TABLE t1 DROP COLUMN c1;
169 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
170 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
171 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
172 SHOW TABLES;
173 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
174 SHOW CREATE TABLE t1;
175 ALTER TABLE t1 DROP COLUMN c2;
176 --error 1090
177 ALTER TABLE t1 DROP COLUMN c1;
178 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
179 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
180 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
181 SHOW TABLES;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183 SHOW CREATE TABLE t1;
184 ALTER TABLE t1 DROP COLUMN c2;
185 --error 1090
186 ALTER TABLE t1 DROP COLUMN c1;
187 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
188 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
189 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
190 SHOW TABLES;
191 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
192 SHOW CREATE TABLE t1;
193 ALTER TABLE t1 DROP COLUMN c2;
194 --error 1090
195 ALTER TABLE t1 DROP COLUMN c1;
196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
197 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
198 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
199 SHOW TABLES;
200 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
201 SHOW CREATE TABLE t1;
202 ALTER TABLE t1 DROP COLUMN c2;
203 --error 1090
204 ALTER TABLE t1 DROP COLUMN c1;
205 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
206 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
207 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
208 SHOW TABLES;
209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
210 SHOW CREATE TABLE t1;
211 ALTER TABLE t1 DROP COLUMN c2;
212 --error 1090
213 ALTER TABLE t1 DROP COLUMN c1;
214 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
215 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
216 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
217 SHOW TABLES;
218 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
219 SHOW CREATE TABLE t1;
220 ALTER TABLE t1 DROP COLUMN c2;
221 --error 1090
222 ALTER TABLE t1 DROP COLUMN c1;
223 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
224 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
225 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
226 SHOW TABLES;
227 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
228 SHOW CREATE TABLE t1;
229 ALTER TABLE t1 DROP COLUMN c2;
230 --error 1090
231 ALTER TABLE t1 DROP COLUMN c1;
232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
234 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
235 SHOW TABLES;
236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
237 SHOW CREATE TABLE t1;
238 ALTER TABLE t1 DROP COLUMN c2;
239 --error 1090
240 ALTER TABLE t1 DROP COLUMN c1;
241 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
242 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
243 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
244 SHOW TABLES;
245 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
246 SHOW CREATE TABLE t1;
247 ALTER TABLE t1 DROP COLUMN c2;
248 --error 1090
249 ALTER TABLE t1 DROP COLUMN c1;
250 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
251 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
252 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
253 SHOW TABLES;
254 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
255 SHOW CREATE TABLE t1;
256 ALTER TABLE t1 DROP COLUMN c2;
257 --error 1090
258 ALTER TABLE t1 DROP COLUMN c1;
259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
260 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
261 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
262 SHOW TABLES;
263 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
264 SHOW CREATE TABLE t1;
265 ALTER TABLE t1 DROP COLUMN c2;
266 --error 1090
267 ALTER TABLE t1 DROP COLUMN c1;
268 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
269 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
270 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
271 SHOW TABLES;
272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
273 SHOW CREATE TABLE t1;
274 ALTER TABLE t1 DROP COLUMN c2;
275 --error 1090
276 ALTER TABLE t1 DROP COLUMN c1;
277 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
278 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
279 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
280 SHOW TABLES;
281 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
282 SHOW CREATE TABLE t1;
283 ALTER TABLE t1 DROP COLUMN c2;
284 --error 1090
285 ALTER TABLE t1 DROP COLUMN c1;
286 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
287 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
288 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
289 SHOW TABLES;
290 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
291 SHOW CREATE TABLE t1;
292 ALTER TABLE t1 DROP COLUMN c2;
293 --error 1090
294 ALTER TABLE t1 DROP COLUMN c1;
295 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
296 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
297 SET sql_mode=default;