Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_init_create_table.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 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
9 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
10 SHOW CREATE TABLE t1;
11 INSERT INTO t1 VALUES(null);
12 INSERT INTO t1 VALUES(null);
13 INSERT INTO t1 VALUES(null);
14 SELECT * FROM t1;
15 DROP TABLE t1;
16 SHOW TABLES;
17 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 NOT NULL KEY ) AUTO_INCREMENT=10;
27 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28 SHOW CREATE TABLE t1;
29 INSERT INTO t1 VALUES(null);
30 INSERT INTO t1 VALUES(null);
31 INSERT INTO t1 VALUES(null);
32 SELECT * FROM t1;
33 DROP TABLE t1;
34 SHOW TABLES;
35 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t1;
38 INSERT INTO t1 VALUES(null);
39 INSERT INTO t1 VALUES(null);
40 INSERT INTO t1 VALUES(null);
41 SELECT * FROM t1;
42 DROP TABLE t1;
43 SHOW TABLES;
44 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
45 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
46 SHOW CREATE TABLE t1;
47 INSERT INTO t1 VALUES(null);
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 SELECT * FROM t1;
51 DROP TABLE t1;
52 SHOW TABLES;
53 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
54 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
55 SHOW CREATE TABLE t1;
56 INSERT INTO t1 VALUES(null);
57 INSERT INTO t1 VALUES(null);
58 INSERT INTO t1 VALUES(null);
59 SELECT * FROM t1;
60 DROP TABLE t1;
61 SHOW TABLES;
62 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
63 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
64 SHOW CREATE TABLE t1;
65 INSERT INTO t1 VALUES(null);
66 INSERT INTO t1 VALUES(null);
67 INSERT INTO t1 VALUES(null);
68 SELECT * FROM t1;
69 DROP TABLE t1;
70 SHOW TABLES;
71 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73 SHOW CREATE TABLE t1;
74 INSERT INTO t1 VALUES(null);
75 INSERT INTO t1 VALUES(null);
76 INSERT INTO t1 VALUES(null);
77 SELECT * FROM t1;
78 DROP TABLE t1;
79 SHOW TABLES;
80 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
82 SHOW CREATE TABLE t1;
83 INSERT INTO t1 VALUES(null);
84 INSERT INTO t1 VALUES(null);
85 INSERT INTO t1 VALUES(null);
86 SELECT * FROM t1;
87 DROP TABLE t1;
88 SHOW TABLES;
89 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
90 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
91 SHOW CREATE TABLE t1;
92 INSERT INTO t1 VALUES(null);
93 INSERT INTO t1 VALUES(null);
94 INSERT INTO t1 VALUES(null);
95 SELECT * FROM t1;
96 DROP TABLE t1;
97 SHOW TABLES;
98 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
99 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
100 SHOW CREATE TABLE t1;
101 INSERT INTO t1 VALUES(null);
102 INSERT INTO t1 VALUES(null);
103 INSERT INTO t1 VALUES(null);
104 SELECT * FROM t1;
105 DROP TABLE t1;
106 SHOW TABLES;
107 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE t1;
110 INSERT INTO t1 VALUES(null);
111 INSERT INTO t1 VALUES(null);
112 INSERT INTO t1 VALUES(null);
113 SELECT * FROM t1;
114 DROP TABLE t1;
115 SHOW TABLES;
116 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
117 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
126 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
127 SHOW CREATE TABLE t1;
128 INSERT INTO t1 VALUES(null);
129 INSERT INTO t1 VALUES(null);
130 INSERT INTO t1 VALUES(null);
131 SELECT * FROM t1;
132 DROP TABLE t1;
133 SHOW TABLES;
134 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
135 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
136 SHOW CREATE TABLE t1;
137 INSERT INTO t1 VALUES(null);
138 INSERT INTO t1 VALUES(null);
139 INSERT INTO t1 VALUES(null);
140 SELECT * FROM t1;
141 DROP TABLE t1;
142 SHOW TABLES;
143 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
144 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
145 SHOW CREATE TABLE t1;
146 INSERT INTO t1 VALUES(null);
147 INSERT INTO t1 VALUES(null);
148 INSERT INTO t1 VALUES(null);
149 SELECT * FROM t1;
150 DROP TABLE t1;
151 SHOW TABLES;
152 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
153 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
154 SHOW CREATE TABLE t1;
155 INSERT INTO t1 VALUES(null);
156 INSERT INTO t1 VALUES(null);
157 INSERT INTO t1 VALUES(null);
158 SELECT * FROM t1;
159 DROP TABLE t1;
160 SHOW TABLES;
161 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163 SHOW CREATE TABLE t1;
164 INSERT INTO t1 VALUES(null);
165 INSERT INTO t1 VALUES(null);
166 INSERT INTO t1 VALUES(null);
167 SELECT * FROM t1;
168 DROP TABLE t1;
169 SHOW TABLES;
170 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
171 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
172 SHOW CREATE TABLE t1;
173 INSERT INTO t1 VALUES(null);
174 INSERT INTO t1 VALUES(null);
175 INSERT INTO t1 VALUES(null);
176 SELECT * FROM t1;
177 DROP TABLE t1;
178 SHOW TABLES;
179 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
180 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
181 SHOW CREATE TABLE t1;
182 INSERT INTO t1 VALUES(null);
183 INSERT INTO t1 VALUES(null);
184 INSERT INTO t1 VALUES(null);
185 SELECT * FROM t1;
186 DROP TABLE t1;
187 SHOW TABLES;
188 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
189 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
190 SHOW CREATE TABLE t1;
191 INSERT INTO t1 VALUES(null);
192 INSERT INTO t1 VALUES(null);
193 INSERT INTO t1 VALUES(null);
194 SELECT * FROM t1;
195 DROP TABLE t1;
196 SHOW TABLES;
197 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
198 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
199 SHOW CREATE TABLE t1;
200 INSERT INTO t1 VALUES(null);
201 INSERT INTO t1 VALUES(null);
202 INSERT INTO t1 VALUES(null);
203 SELECT * FROM t1;
204 DROP TABLE t1;
205 SHOW TABLES;
206 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
207 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
208 SHOW CREATE TABLE t1;
209 INSERT INTO t1 VALUES(null);
210 INSERT INTO t1 VALUES(null);
211 INSERT INTO t1 VALUES(null);
212 SELECT * FROM t1;
213 DROP TABLE t1;
214 SHOW TABLES;
215 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
216 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
225 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
226 SHOW CREATE TABLE t1;
227 INSERT INTO t1 VALUES(null);
228 INSERT INTO t1 VALUES(null);
229 INSERT INTO t1 VALUES(null);
230 SELECT * FROM t1;
231 DROP TABLE t1;
232 SHOW TABLES;
233 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
234 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
235 SHOW CREATE TABLE t1;
236 INSERT INTO t1 VALUES(null);
237 INSERT INTO t1 VALUES(null);
238 INSERT INTO t1 VALUES(null);
239 SELECT * FROM t1;
240 DROP TABLE t1;
241 SHOW TABLES;
242 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
243 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
244 SHOW CREATE TABLE t1;
245 INSERT INTO t1 VALUES(null);
246 INSERT INTO t1 VALUES(null);
247 INSERT INTO t1 VALUES(null);
248 SELECT * FROM t1;
249 DROP TABLE t1;
250 SHOW TABLES;
251 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
253 SHOW CREATE TABLE t1;
254 INSERT INTO t1 VALUES(null);
255 INSERT INTO t1 VALUES(null);
256 INSERT INTO t1 VALUES(null);
257 SELECT * FROM t1;
258 DROP TABLE t1;
259 SHOW TABLES;
260 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
261 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
262 SHOW CREATE TABLE t1;
263 INSERT INTO t1 VALUES(null);
264 INSERT INTO t1 VALUES(null);
265 INSERT INTO t1 VALUES(null);
266 SELECT * FROM t1;
267 DROP TABLE t1;
268 SHOW TABLES;
269 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
270 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
271 SHOW CREATE TABLE t1;
272 INSERT INTO t1 VALUES(null);
273 INSERT INTO t1 VALUES(null);
274 INSERT INTO t1 VALUES(null);
275 SELECT * FROM t1;
276 DROP TABLE t1;
277 SHOW TABLES;
278 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
279 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
280 SHOW CREATE TABLE t1;
281 INSERT INTO t1 VALUES(null);
282 INSERT INTO t1 VALUES(null);
283 INSERT INTO t1 VALUES(null);
284 SELECT * FROM t1;
285 DROP TABLE t1;
286 SHOW TABLES;
287 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
288 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
289 SHOW CREATE TABLE t1;
290 INSERT INTO t1 VALUES(null);
291 INSERT INTO t1 VALUES(null);
292 INSERT INTO t1 VALUES(null);
293 SELECT * FROM t1;
294 DROP TABLE t1;
295 SHOW TABLES;
296 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
297 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
298 SHOW CREATE TABLE t1;
299 INSERT INTO t1 VALUES(null);
300 INSERT INTO t1 VALUES(null);
301 INSERT INTO t1 VALUES(null);
302 SELECT * FROM t1;
303 DROP TABLE t1;
304 SHOW TABLES;
305 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
306 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
307 SHOW CREATE TABLE t1;
308 INSERT INTO t1 VALUES(null);
309 INSERT INTO t1 VALUES(null);
310 INSERT INTO t1 VALUES(null);
311 SELECT * FROM t1;
312 DROP TABLE t1;
313 SHOW TABLES;
314 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
315 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
324 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
325 SHOW CREATE TABLE t1;
326 INSERT INTO t1 VALUES(null);
327 INSERT INTO t1 VALUES(null);
328 INSERT INTO t1 VALUES(null);
329 SELECT * FROM t1;
330 DROP TABLE t1;
331 SHOW TABLES;
332 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
333 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
334 SHOW CREATE TABLE t1;
335 INSERT INTO t1 VALUES(null);
336 INSERT INTO t1 VALUES(null);
337 INSERT INTO t1 VALUES(null);
338 SELECT * FROM t1;
339 DROP TABLE t1;
340 SHOW TABLES;
341 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
342 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
343 SHOW CREATE TABLE t1;
344 INSERT INTO t1 VALUES(null);
345 INSERT INTO t1 VALUES(null);
346 INSERT INTO t1 VALUES(null);
347 SELECT * FROM t1;
348 DROP TABLE t1;
349 SHOW TABLES;
350 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
351 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
352 SHOW CREATE TABLE t1;
353 INSERT INTO t1 VALUES(null);
354 INSERT INTO t1 VALUES(null);
355 INSERT INTO t1 VALUES(null);
356 SELECT * FROM t1;
357 DROP TABLE t1;
358 SHOW TABLES;
359 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
360 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
361 SHOW CREATE TABLE t1;
362 INSERT INTO t1 VALUES(null);
363 INSERT INTO t1 VALUES(null);
364 INSERT INTO t1 VALUES(null);
365 SELECT * FROM t1;
366 DROP TABLE t1;
367 SHOW TABLES;
368 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
370 SHOW CREATE TABLE t1;
371 INSERT INTO t1 VALUES(null);
372 INSERT INTO t1 VALUES(null);
373 INSERT INTO t1 VALUES(null);
374 SELECT * FROM t1;
375 DROP TABLE t1;
376 SHOW TABLES;
377 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
378 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
379 SHOW CREATE TABLE t1;
380 INSERT INTO t1 VALUES(null);
381 INSERT INTO t1 VALUES(null);
382 INSERT INTO t1 VALUES(null);
383 SELECT * FROM t1;
384 DROP TABLE t1;
385 SHOW TABLES;
386 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
387 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
388 SHOW CREATE TABLE t1;
389 INSERT INTO t1 VALUES(null);
390 INSERT INTO t1 VALUES(null);
391 INSERT INTO t1 VALUES(null);
392 SELECT * FROM t1;
393 DROP TABLE t1;
394 SHOW TABLES;
395 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
397 SHOW CREATE TABLE t1;
398 INSERT INTO t1 VALUES(null);
399 INSERT INTO t1 VALUES(null);
400 INSERT INTO t1 VALUES(null);
401 SELECT * FROM t1;
402 DROP TABLE t1;
403 SHOW TABLES;
404 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
405 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
406 SHOW CREATE TABLE t1;
407 INSERT INTO t1 VALUES(null);
408 INSERT INTO t1 VALUES(null);
409 INSERT INTO t1 VALUES(null);
410 SELECT * FROM t1;
411 DROP TABLE t1;
412 SHOW TABLES;
413 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
414 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
423 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
424 SHOW CREATE TABLE t1;
425 INSERT INTO t1 VALUES(null);
426 INSERT INTO t1 VALUES(null);
427 INSERT INTO t1 VALUES(null);
428 SELECT * FROM t1;
429 DROP TABLE t1;
430 SHOW TABLES;
431 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
432 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
433 SHOW CREATE TABLE t1;
434 INSERT INTO t1 VALUES(null);
435 INSERT INTO t1 VALUES(null);
436 INSERT INTO t1 VALUES(null);
437 SELECT * FROM t1;
438 DROP TABLE t1;
439 SHOW TABLES;
440 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
441 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
442 SHOW CREATE TABLE t1;
443 INSERT INTO t1 VALUES(null);
444 INSERT INTO t1 VALUES(null);
445 INSERT INTO t1 VALUES(null);
446 SELECT * FROM t1;
447 DROP TABLE t1;
448 SHOW TABLES;
449 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
450 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
451 SHOW CREATE TABLE t1;
452 INSERT INTO t1 VALUES(null);
453 INSERT INTO t1 VALUES(null);
454 INSERT INTO t1 VALUES(null);
455 SELECT * FROM t1;
456 DROP TABLE t1;
457 SHOW TABLES;
458 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
459 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
460 SHOW CREATE TABLE t1;
461 INSERT INTO t1 VALUES(null);
462 INSERT INTO t1 VALUES(null);
463 INSERT INTO t1 VALUES(null);
464 SELECT * FROM t1;
465 DROP TABLE t1;
466 SHOW TABLES;
467 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
469 SHOW CREATE TABLE t1;
470 INSERT INTO t1 VALUES(null);
471 INSERT INTO t1 VALUES(null);
472 INSERT INTO t1 VALUES(null);
473 SELECT * FROM t1;
474 DROP TABLE t1;
475 SHOW TABLES;
476 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
477 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
478 SHOW CREATE TABLE t1;
479 INSERT INTO t1 VALUES(null);
480 INSERT INTO t1 VALUES(null);
481 INSERT INTO t1 VALUES(null);
482 SELECT * FROM t1;
483 DROP TABLE t1;
484 SHOW TABLES;
485 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
486 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
487 SHOW CREATE TABLE t1;
488 INSERT INTO t1 VALUES(null);
489 INSERT INTO t1 VALUES(null);
490 INSERT INTO t1 VALUES(null);
491 SELECT * FROM t1;
492 DROP TABLE t1;
493 SHOW TABLES;
494 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
495 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
496 SHOW CREATE TABLE t1;
497 INSERT INTO t1 VALUES(null);
498 INSERT INTO t1 VALUES(null);
499 INSERT INTO t1 VALUES(null);
500 SELECT * FROM t1;
501 DROP TABLE t1;
502 SHOW TABLES;
503 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
504 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
505 SHOW CREATE TABLE t1;
506 INSERT INTO t1 VALUES(null);
507 INSERT INTO t1 VALUES(null);
508 INSERT INTO t1 VALUES(null);
509 SELECT * FROM t1;
510 DROP TABLE t1;
511 SHOW TABLES;
512 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
513 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
522 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
523 SHOW CREATE TABLE t1;
524 INSERT INTO t1 VALUES(null);
525 INSERT INTO t1 VALUES(null);
526 INSERT INTO t1 VALUES(null);
527 SELECT * FROM t1;
528 DROP TABLE t1;
529 SHOW TABLES;
530 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
531 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
532 SHOW CREATE TABLE t1;
533 INSERT INTO t1 VALUES(null);
534 INSERT INTO t1 VALUES(null);
535 INSERT INTO t1 VALUES(null);
536 SELECT * FROM t1;
537 DROP TABLE t1;
538 SHOW TABLES;
539 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
540 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
541 SHOW CREATE TABLE t1;
542 INSERT INTO t1 VALUES(null);
543 INSERT INTO t1 VALUES(null);
544 INSERT INTO t1 VALUES(null);
545 SELECT * FROM t1;
546 DROP TABLE t1;
547 SHOW TABLES;