Debian Codegraph @

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

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