Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
5 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
10 INSERT INTO t1 VALUES(null);
11 INSERT INTO t1 VALUES(null);
12 SELECT * FROM t1;
13 DROP TABLE t1;
14 SHOW TABLES;
15 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
16 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
21 INSERT INTO t1 VALUES(null);
22 INSERT INTO t1 VALUES(null);
23 SELECT * FROM t1;
24 DROP TABLE t1;
25 SHOW TABLES;
26 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
27 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
32 INSERT INTO t1 VALUES(null);
33 INSERT INTO t1 VALUES(null);
34 SELECT * FROM t1;
35 DROP TABLE t1;
36 SHOW TABLES;
37 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
38 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
43 INSERT INTO t1 VALUES(null);
44 INSERT INTO t1 VALUES(null);
45 SELECT * FROM t1;
46 DROP TABLE t1;
47 SHOW TABLES;
48 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
49 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
54 INSERT INTO t1 VALUES(null);
55 INSERT INTO t1 VALUES(null);
56 SELECT * FROM t1;
57 DROP TABLE t1;
58 SHOW TABLES;
59 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
60 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
65 INSERT INTO t1 VALUES(null);
66 INSERT INTO t1 VALUES(null);
67 SELECT * FROM t1;
68 DROP TABLE t1;
69 SHOW TABLES;
70 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
71 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
76 INSERT INTO t1 VALUES(null);
77 INSERT INTO t1 VALUES(null);
78 SELECT * FROM t1;
79 DROP TABLE t1;
80 SHOW TABLES;
81 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
82 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
87 INSERT INTO t1 VALUES(null);
88 INSERT INTO t1 VALUES(null);
89 SELECT * FROM t1;
90 DROP TABLE t1;
91 SHOW TABLES;
92 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
93 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
98 INSERT INTO t1 VALUES(null);
99 INSERT INTO t1 VALUES(null);
100 SELECT * FROM t1;
101 DROP TABLE t1;
102 SHOW TABLES;
103 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
104 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
109 INSERT INTO t1 VALUES(null);
110 INSERT INTO t1 VALUES(null);
111 SELECT * FROM t1;
112 DROP TABLE t1;
113 SHOW TABLES;
114 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
115 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
120 INSERT INTO t1 VALUES(null);
121 INSERT INTO t1 VALUES(null);
122 SELECT * FROM t1;
123 DROP TABLE t1;
124 SHOW TABLES;
125 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
126 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
131 INSERT INTO t1 VALUES(null);
132 INSERT INTO t1 VALUES(null);
133 SELECT * FROM t1;
134 DROP TABLE t1;
135 SHOW TABLES;
136 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
137 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
142 INSERT INTO t1 VALUES(null);
143 INSERT INTO t1 VALUES(null);
144 SELECT * FROM t1;
145 DROP TABLE t1;
146 SHOW TABLES;
147 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
148 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
153 INSERT INTO t1 VALUES(null);
154 INSERT INTO t1 VALUES(null);
155 SELECT * FROM t1;
156 DROP TABLE t1;
157 SHOW TABLES;
158 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
159 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
164 INSERT INTO t1 VALUES(null);
165 INSERT INTO t1 VALUES(null);
166 SELECT * FROM t1;
167 DROP TABLE t1;
168 SHOW TABLES;
169 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
170 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
175 INSERT INTO t1 VALUES(null);
176 INSERT INTO t1 VALUES(null);
177 SELECT * FROM t1;
178 DROP TABLE t1;
179 SHOW TABLES;
180 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
181 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
186 INSERT INTO t1 VALUES(null);
187 INSERT INTO t1 VALUES(null);
188 SELECT * FROM t1;
189 DROP TABLE t1;
190 SHOW TABLES;
191 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
192 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
197 INSERT INTO t1 VALUES(null);
198 INSERT INTO t1 VALUES(null);
199 SELECT * FROM t1;
200 DROP TABLE t1;
201 SHOW TABLES;
202 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
203 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
208 INSERT INTO t1 VALUES(null);
209 INSERT INTO t1 VALUES(null);
210 SELECT * FROM t1;
211 DROP TABLE t1;
212 SHOW TABLES;
213 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
214 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
219 INSERT INTO t1 VALUES(null);
220 INSERT INTO t1 VALUES(null);
221 SELECT * FROM t1;
222 DROP TABLE t1;
223 SHOW TABLES;
224 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
225 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
230 INSERT INTO t1 VALUES(null);
231 INSERT INTO t1 VALUES(null);
232 SELECT * FROM t1;
233 DROP TABLE t1;
234 SHOW TABLES;
235 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
236 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
241 INSERT INTO t1 VALUES(null);
242 INSERT INTO t1 VALUES(null);
243 SELECT * FROM t1;
244 DROP TABLE t1;
245 SHOW TABLES;
246 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
247 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
252 INSERT INTO t1 VALUES(null);
253 INSERT INTO t1 VALUES(null);
254 SELECT * FROM t1;
255 DROP TABLE t1;
256 SHOW TABLES;
257 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
258 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
263 INSERT INTO t1 VALUES(null);
264 INSERT INTO t1 VALUES(null);
265 SELECT * FROM t1;
266 DROP TABLE t1;
267 SHOW TABLES;
268 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
269 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
274 INSERT INTO t1 VALUES(null);
275 INSERT INTO t1 VALUES(null);
276 SELECT * FROM t1;
277 DROP TABLE t1;
278 SHOW TABLES;
279 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
280 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
285 INSERT INTO t1 VALUES(null);
286 INSERT INTO t1 VALUES(null);
287 SELECT * FROM t1;
288 DROP TABLE t1;
289 SHOW TABLES;
290 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
291 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
296 INSERT INTO t1 VALUES(null);
297 INSERT INTO t1 VALUES(null);
298 SELECT * FROM t1;
299 DROP TABLE t1;
300 SHOW TABLES;
301 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
302 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
307 INSERT INTO t1 VALUES(null);
308 INSERT INTO t1 VALUES(null);
309 SELECT * FROM t1;
310 DROP TABLE t1;
311 SHOW TABLES;
312 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
313 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
318 INSERT INTO t1 VALUES(null);
319 INSERT INTO t1 VALUES(null);
320 SELECT * FROM t1;
321 DROP TABLE t1;
322 SHOW TABLES;
323 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
324 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
329 INSERT INTO t1 VALUES(null);
330 INSERT INTO t1 VALUES(null);
331 SELECT * FROM t1;
332 DROP TABLE t1;
333 SHOW TABLES;
334 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
335 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
340 INSERT INTO t1 VALUES(null);
341 INSERT INTO t1 VALUES(null);
342 SELECT * FROM t1;
343 DROP TABLE t1;
344 SHOW TABLES;
345 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
346 ALTER TABLE t1 AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
351 INSERT INTO t1 VALUES(null);
352 INSERT INTO t1 VALUES(null);
353 SELECT * FROM t1;
354 DROP TABLE t1;
355 SHOW TABLES;
356 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
357 ALTER TABLE t1 AUTO_INCREMENT=10;
358 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
359 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
360 SHOW CREATE TABLE t1;
361 INSERT INTO t1 VALUES(null);
362 INSERT INTO t1 VALUES(null);
363 INSERT INTO t1 VALUES(null);
364 SELECT * FROM t1;
365 DROP TABLE t1;
366 SHOW TABLES;
367 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
368 ALTER TABLE t1 AUTO_INCREMENT=10;
369 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
370 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
371 SHOW CREATE TABLE t1;
372 INSERT INTO t1 VALUES(null);
373 INSERT INTO t1 VALUES(null);
374 INSERT INTO t1 VALUES(null);
375 SELECT * FROM t1;
376 DROP TABLE t1;
377 SHOW TABLES;
378 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
379 ALTER TABLE t1 AUTO_INCREMENT=10;
380 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
381 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
382 SHOW CREATE TABLE t1;
383 INSERT INTO t1 VALUES(null);
384 INSERT INTO t1 VALUES(null);
385 INSERT INTO t1 VALUES(null);
386 SELECT * FROM t1;
387 DROP TABLE t1;
388 SHOW TABLES;
389 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
390 ALTER TABLE t1 AUTO_INCREMENT=10;
391 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
392 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
393 SHOW CREATE TABLE t1;
394 INSERT INTO t1 VALUES(null);
395 INSERT INTO t1 VALUES(null);
396 INSERT INTO t1 VALUES(null);
397 SELECT * FROM t1;
398 DROP TABLE t1;
399 SHOW TABLES;
400 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
401 ALTER TABLE t1 AUTO_INCREMENT=10;
402 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
403 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
404 SHOW CREATE TABLE t1;
405 INSERT INTO t1 VALUES(null);
406 INSERT INTO t1 VALUES(null);
407 INSERT INTO t1 VALUES(null);
408 SELECT * FROM t1;
409 DROP TABLE t1;
410 SHOW TABLES;
411 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
412 ALTER TABLE t1 AUTO_INCREMENT=10;
413 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
414 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
415 SHOW CREATE TABLE t1;
416 INSERT INTO t1 VALUES(null);
417 INSERT INTO t1 VALUES(null);
418 INSERT INTO t1 VALUES(null);
419 SELECT * FROM t1;
420 DROP TABLE t1;
421 SHOW TABLES;
422 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
423 ALTER TABLE t1 AUTO_INCREMENT=10;
424 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
425 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
426 SHOW CREATE TABLE t1;
427 INSERT INTO t1 VALUES(null);
428 INSERT INTO t1 VALUES(null);
429 INSERT INTO t1 VALUES(null);
430 SELECT * FROM t1;
431 DROP TABLE t1;
432 SHOW TABLES;
433 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
434 ALTER TABLE t1 AUTO_INCREMENT=10;
435 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
436 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
437 SHOW CREATE TABLE t1;
438 INSERT INTO t1 VALUES(null);
439 INSERT INTO t1 VALUES(null);
440 INSERT INTO t1 VALUES(null);
441 SELECT * FROM t1;
442 DROP TABLE t1;
443 SHOW TABLES;
444 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
445 ALTER TABLE t1 AUTO_INCREMENT=10;
446 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
447 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
448 SHOW CREATE TABLE t1;
449 INSERT INTO t1 VALUES(null);
450 INSERT INTO t1 VALUES(null);
451 INSERT INTO t1 VALUES(null);
452 SELECT * FROM t1;
453 DROP TABLE t1;
454 SHOW TABLES;
455 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
456 ALTER TABLE t1 AUTO_INCREMENT=10;
457 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
458 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
459 SHOW CREATE TABLE t1;
460 INSERT INTO t1 VALUES(null);
461 INSERT INTO t1 VALUES(null);
462 INSERT INTO t1 VALUES(null);
463 SELECT * FROM t1;
464 DROP TABLE t1;
465 SHOW TABLES;
466 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
467 ALTER TABLE t1 AUTO_INCREMENT=10;
468 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
469 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
470 SHOW CREATE TABLE t1;
471 INSERT INTO t1 VALUES(null);
472 INSERT INTO t1 VALUES(null);
473 INSERT INTO t1 VALUES(null);
474 SELECT * FROM t1;
475 DROP TABLE t1;
476 SHOW TABLES;
477 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
478 ALTER TABLE t1 AUTO_INCREMENT=10;
479 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
480 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
481 SHOW CREATE TABLE t1;
482 INSERT INTO t1 VALUES(null);
483 INSERT INTO t1 VALUES(null);
484 INSERT INTO t1 VALUES(null);
485 SELECT * FROM t1;
486 DROP TABLE t1;
487 SHOW TABLES;
488 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
489 ALTER TABLE t1 AUTO_INCREMENT=10;
490 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
491 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
492 SHOW CREATE TABLE t1;
493 INSERT INTO t1 VALUES(null);
494 INSERT INTO t1 VALUES(null);
495 INSERT INTO t1 VALUES(null);
496 SELECT * FROM t1;
497 DROP TABLE t1;
498 SHOW TABLES;
499 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
500 ALTER TABLE t1 AUTO_INCREMENT=10;
501 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
502 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
503 SHOW CREATE TABLE t1;
504 INSERT INTO t1 VALUES(null);
505 INSERT INTO t1 VALUES(null);
506 INSERT INTO t1 VALUES(null);
507 SELECT * FROM t1;
508 DROP TABLE t1;
509 SHOW TABLES;
510 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
511 ALTER TABLE t1 AUTO_INCREMENT=10;
512 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
513 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
514 SHOW CREATE TABLE t1;
515 INSERT INTO t1 VALUES(null);
516 INSERT INTO t1 VALUES(null);
517 INSERT INTO t1 VALUES(null);
518 SELECT * FROM t1;
519 DROP TABLE t1;
520 SHOW TABLES;
521 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
522 ALTER TABLE t1 AUTO_INCREMENT=10;
523 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
524 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
525 SHOW CREATE TABLE t1;
526 INSERT INTO t1 VALUES(null);
527 INSERT INTO t1 VALUES(null);
528 INSERT INTO t1 VALUES(null);
529 SELECT * FROM t1;
530 DROP TABLE t1;
531 SHOW TABLES;
532 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
533 ALTER TABLE t1 AUTO_INCREMENT=10;
534 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
535 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
536 SHOW CREATE TABLE t1;
537 INSERT INTO t1 VALUES(null);
538 INSERT INTO t1 VALUES(null);
539 INSERT INTO t1 VALUES(null);
540 SELECT * FROM t1;
541 DROP TABLE t1;
542 SHOW TABLES;
543 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
544 ALTER TABLE t1 AUTO_INCREMENT=10;
545 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
546 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
547 SHOW CREATE TABLE t1;
548 INSERT INTO t1 VALUES(null);
549 INSERT INTO t1 VALUES(null);
550 INSERT INTO t1 VALUES(null);
551 SELECT * FROM t1;
552 DROP TABLE t1;
553 SHOW TABLES;
554 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
555 ALTER TABLE t1 AUTO_INCREMENT=10;
556 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
557 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
558 SHOW CREATE TABLE t1;
559 INSERT INTO t1 VALUES(null);
560 INSERT INTO t1 VALUES(null);
561 INSERT INTO t1 VALUES(null);
562 SELECT * FROM t1;
563 DROP TABLE t1;
564 SHOW TABLES;
565 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
566 ALTER TABLE t1 AUTO_INCREMENT=10;
567 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
568 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
569 SHOW CREATE TABLE t1;
570 INSERT INTO t1 VALUES(null);
571 INSERT INTO t1 VALUES(null);
572 INSERT INTO t1 VALUES(null);
573 SELECT * FROM t1;
574 DROP TABLE t1;
575 SHOW TABLES;
576 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
577 ALTER TABLE t1 AUTO_INCREMENT=10;
578 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
579 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
580 SHOW CREATE TABLE t1;
581 INSERT INTO t1 VALUES(null);
582 INSERT INTO t1 VALUES(null);
583 INSERT INTO t1 VALUES(null);
584 SELECT * FROM t1;
585 DROP TABLE t1;
586 SHOW TABLES;
587 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
588 ALTER TABLE t1 AUTO_INCREMENT=10;
589 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
590 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
591 SHOW CREATE TABLE t1;
592 INSERT INTO t1 VALUES(null);
593 INSERT INTO t1 VALUES(null);
594 INSERT INTO t1 VALUES(null);
595 SELECT * FROM t1;
596 DROP TABLE t1;
597 SHOW TABLES;
598 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
599 ALTER TABLE t1 AUTO_INCREMENT=10;
600 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
601 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
602 SHOW CREATE TABLE t1;
603 INSERT INTO t1 VALUES(null);
604 INSERT INTO t1 VALUES(null);
605 INSERT INTO t1 VALUES(null);
606 SELECT * FROM t1;
607 DROP TABLE t1;
608 SHOW TABLES;
609 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
610 ALTER TABLE t1 AUTO_INCREMENT=10;
611 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
612 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
613 SHOW CREATE TABLE t1;
614 INSERT INTO t1 VALUES(null);
615 INSERT INTO t1 VALUES(null);
616 INSERT INTO t1 VALUES(null);
617 SELECT * FROM t1;
618 DROP TABLE t1;
619 SHOW TABLES;
620 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
621 ALTER TABLE t1 AUTO_INCREMENT=10;
622 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
623 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
624 SHOW CREATE TABLE t1;
625 INSERT INTO t1 VALUES(null);
626 INSERT INTO t1 VALUES(null);
627 INSERT INTO t1 VALUES(null);
628 SELECT * FROM t1;
629 DROP TABLE t1;
630 SHOW TABLES;
631 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
632 ALTER TABLE t1 AUTO_INCREMENT=10;
633 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
634 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
635 SHOW CREATE TABLE t1;
636 INSERT INTO t1 VALUES(null);
637 INSERT INTO t1 VALUES(null);
638 INSERT INTO t1 VALUES(null);
639 SELECT * FROM t1;
640 DROP TABLE t1;
641 SHOW TABLES;
642 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
643 ALTER TABLE t1 AUTO_INCREMENT=10;
644 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
645 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
646 SHOW CREATE TABLE t1;
647 INSERT INTO t1 VALUES(null);
648 INSERT INTO t1 VALUES(null);
649 INSERT INTO t1 VALUES(null);
650 SELECT * FROM t1;
651 DROP TABLE t1;
652 SHOW TABLES;
653 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
654 ALTER TABLE t1 AUTO_INCREMENT=10;
655 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
656 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
657 SHOW CREATE TABLE t1;
658 INSERT INTO t1 VALUES(null);
659 INSERT INTO t1 VALUES(null);
660 INSERT INTO t1 VALUES(null);
661 SELECT * FROM t1;
662 DROP TABLE t1;
663 SHOW TABLES;
664