Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_init_insert_id.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 );
9 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
10 SHOW CREATE TABLE t1;
11 SET INSERT_ID = 10;
12 INSERT INTO t1 VALUES(null);
13 INSERT INTO t1 VALUES(null);
14 INSERT INTO t1 VALUES(null);
15 SELECT * FROM t1;
16 DROP TABLE t1;
17 SHOW TABLES;
18 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
20 SHOW CREATE TABLE t1;
21 SET INSERT_ID = 10;
22 INSERT INTO t1 VALUES(null);
23 INSERT INTO t1 VALUES(null);
24 INSERT INTO t1 VALUES(null);
25 SELECT * FROM t1;
26 DROP TABLE t1;
27 SHOW TABLES;
28 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE t1;
31 SET INSERT_ID = 10;
32 INSERT INTO t1 VALUES(null);
33 INSERT INTO t1 VALUES(null);
34 INSERT INTO t1 VALUES(null);
35 SELECT * FROM t1;
36 DROP TABLE t1;
37 SHOW TABLES;
38 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
39 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
40 SHOW CREATE TABLE t1;
41 SET INSERT_ID = 10;
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 NOT NULL KEY );
49 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
50 SHOW CREATE TABLE t1;
51 SET INSERT_ID = 10;
52 INSERT INTO t1 VALUES(null);
53 INSERT INTO t1 VALUES(null);
54 INSERT INTO t1 VALUES(null);
55 SELECT * FROM t1;
56 DROP TABLE t1;
57 SHOW TABLES;
58 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
60 SHOW CREATE TABLE t1;
61 SET INSERT_ID = 10;
62 INSERT INTO t1 VALUES(null);
63 INSERT INTO t1 VALUES(null);
64 INSERT INTO t1 VALUES(null);
65 SELECT * FROM t1;
66 DROP TABLE t1;
67 SHOW TABLES;
68 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
69 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
70 SHOW CREATE TABLE t1;
71 SET INSERT_ID = 10;
72 INSERT INTO t1 VALUES(null);
73 INSERT INTO t1 VALUES(null);
74 INSERT INTO t1 VALUES(null);
75 SELECT * FROM t1;
76 DROP TABLE t1;
77 SHOW TABLES;
78 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
79 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
80 SHOW CREATE TABLE t1;
81 SET INSERT_ID = 10;
82 INSERT INTO t1 VALUES(null);
83 INSERT INTO t1 VALUES(null);
84 INSERT INTO t1 VALUES(null);
85 SELECT * FROM t1;
86 DROP TABLE t1;
87 SHOW TABLES;
88 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
89 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
90 SHOW CREATE TABLE t1;
91 SET INSERT_ID = 10;
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 INT AUTO_INCREMENT NOT NULL KEY );
99 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
100 SHOW CREATE TABLE t1;
101 SET INSERT_ID = 10;
102 INSERT INTO t1 VALUES(null);
103 INSERT INTO t1 VALUES(null);
104 INSERT INTO t1 VALUES(null);
105 SELECT * FROM t1;
106 DROP TABLE t1;
107 SHOW TABLES;
108 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
109 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
110 SHOW CREATE TABLE t1;
111 SET INSERT_ID = 10;
112 INSERT INTO t1 VALUES(null);
113 INSERT INTO t1 VALUES(null);
114 INSERT INTO t1 VALUES(null);
115 SELECT * FROM t1;
116 DROP TABLE t1;
117 SHOW TABLES;
118 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
119 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE t1;
121 SET INSERT_ID = 10;
122 INSERT INTO t1 VALUES(null);
123 INSERT INTO t1 VALUES(null);
124 INSERT INTO t1 VALUES(null);
125 SELECT * FROM t1;
126 DROP TABLE t1;
127 SHOW TABLES;
128 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
129 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
130 SHOW CREATE TABLE t1;
131 SET INSERT_ID = 10;
132 INSERT INTO t1 VALUES(null);
133 INSERT INTO t1 VALUES(null);
134 INSERT INTO t1 VALUES(null);
135 SELECT * FROM t1;
136 DROP TABLE t1;
137 SHOW TABLES;
138 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
139 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
140 SHOW CREATE TABLE t1;
141 SET INSERT_ID = 10;
142 INSERT INTO t1 VALUES(null);
143 INSERT INTO t1 VALUES(null);
144 INSERT INTO t1 VALUES(null);
145 SELECT * FROM t1;
146 DROP TABLE t1;
147 SHOW TABLES;
148 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
149 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
150 SHOW CREATE TABLE t1;
151 SET INSERT_ID = 10;
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 INT AUTO_INCREMENT NULL UNIQUE KEY );
159 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
160 SHOW CREATE TABLE t1;
161 SET INSERT_ID = 10;
162 INSERT INTO t1 VALUES(null);
163 INSERT INTO t1 VALUES(null);
164 INSERT INTO t1 VALUES(null);
165 SELECT * FROM t1;
166 DROP TABLE t1;
167 SHOW TABLES;
168 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
169 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
170 SHOW CREATE TABLE t1;
171 SET INSERT_ID = 10;
172 INSERT INTO t1 VALUES(null);
173 INSERT INTO t1 VALUES(null);
174 INSERT INTO t1 VALUES(null);
175 SELECT * FROM t1;
176 DROP TABLE t1;
177 SHOW TABLES;
178 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
179 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
180 SHOW CREATE TABLE t1;
181 SET INSERT_ID = 10;
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 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
189 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
190 SHOW CREATE TABLE t1;
191 SET INSERT_ID = 10;
192 INSERT INTO t1 VALUES(null);
193 INSERT INTO t1 VALUES(null);
194 INSERT INTO t1 VALUES(null);
195 SELECT * FROM t1;
196 DROP TABLE t1;
197 SHOW TABLES;
198 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
199 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
200 SHOW CREATE TABLE t1;
201 SET INSERT_ID = 10;
202 INSERT INTO t1 VALUES(null);
203 INSERT INTO t1 VALUES(null);
204 INSERT INTO t1 VALUES(null);
205 SELECT * FROM t1;
206 DROP TABLE t1;
207 SHOW TABLES;
208 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
210 SHOW CREATE TABLE t1;
211 SET INSERT_ID = 10;
212 INSERT INTO t1 VALUES(null);
213 INSERT INTO t1 VALUES(null);
214 INSERT INTO t1 VALUES(null);
215 SELECT * FROM t1;
216 DROP TABLE t1;
217 SHOW TABLES;
218 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
219 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
220 SHOW CREATE TABLE t1;
221 SET INSERT_ID = 10;
222 INSERT INTO t1 VALUES(null);
223 INSERT INTO t1 VALUES(null);
224 INSERT INTO t1 VALUES(null);
225 SELECT * FROM t1;
226 DROP TABLE t1;
227 SHOW TABLES;
228 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
229 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
230 SHOW CREATE TABLE t1;
231 SET INSERT_ID = 10;
232 INSERT INTO t1 VALUES(null);
233 INSERT INTO t1 VALUES(null);
234 INSERT INTO t1 VALUES(null);
235 SELECT * FROM t1;
236 DROP TABLE t1;
237 SHOW TABLES;
238 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
239 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
240 SHOW CREATE TABLE t1;
241 SET INSERT_ID = 10;
242 INSERT INTO t1 VALUES(null);
243 INSERT INTO t1 VALUES(null);
244 INSERT INTO t1 VALUES(null);
245 SELECT * FROM t1;
246 DROP TABLE t1;
247 SHOW TABLES;
248 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
249 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
250 SHOW CREATE TABLE t1;
251 SET INSERT_ID = 10;
252 INSERT INTO t1 VALUES(null);
253 INSERT INTO t1 VALUES(null);
254 INSERT INTO t1 VALUES(null);
255 SELECT * FROM t1;
256 DROP TABLE t1;
257 SHOW TABLES;
258 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
260 SHOW CREATE TABLE t1;
261 SET INSERT_ID = 10;
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 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
269 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
270 SHOW CREATE TABLE t1;
271 SET INSERT_ID = 10;
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 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
279 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
280 SHOW CREATE TABLE t1;
281 SET INSERT_ID = 10;
282 INSERT INTO t1 VALUES(null);
283 INSERT INTO t1 VALUES(null);
284 INSERT INTO t1 VALUES(null);
285 SELECT * FROM t1;
286 DROP TABLE t1;
287 SHOW TABLES;
288 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
289 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
290 SHOW CREATE TABLE t1;
291 SET INSERT_ID = 10;
292 INSERT INTO t1 VALUES(null);
293 INSERT INTO t1 VALUES(null);
294 INSERT INTO t1 VALUES(null);
295 SELECT * FROM t1;
296 DROP TABLE t1;
297 SHOW TABLES;
298 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
299 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
300 SHOW CREATE TABLE t1;
301 SET INSERT_ID = 10;
302 INSERT INTO t1 VALUES(null);
303 INSERT INTO t1 VALUES(null);
304 INSERT INTO t1 VALUES(null);
305 SELECT * FROM t1;
306 DROP TABLE t1;
307 SHOW TABLES;
308 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
309 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
310 SHOW CREATE TABLE t1;
311 SET INSERT_ID = 10;
312 INSERT INTO t1 VALUES(null);
313 INSERT INTO t1 VALUES(null);
314 INSERT INTO t1 VALUES(null);
315 SELECT * FROM t1;
316 DROP TABLE t1;
317 SHOW TABLES;
318 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
319 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
320 SHOW CREATE TABLE t1;
321 SET INSERT_ID = 10;
322 INSERT INTO t1 VALUES(null);
323 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
325 SELECT * FROM t1;
326 DROP TABLE t1;
327 SHOW TABLES;
328 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
329 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
330 SHOW CREATE TABLE t1;
331 SET INSERT_ID = 10;
332 INSERT INTO t1 VALUES(null);
333 INSERT INTO t1 VALUES(null);
334 INSERT INTO t1 VALUES(null);
335 SELECT * FROM t1;
336 DROP TABLE t1;
337 SHOW TABLES;
338 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
339 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
340 SHOW CREATE TABLE t1;
341 SET INSERT_ID = 10;
342 INSERT INTO t1 VALUES(null);
343 INSERT INTO t1 VALUES(null);
344 INSERT INTO t1 VALUES(null);
345 SELECT * FROM t1;
346 DROP TABLE t1;
347 SHOW TABLES;
348 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
349 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
350 SHOW CREATE TABLE t1;
351 SET INSERT_ID = 10;
352 INSERT INTO t1 VALUES(null);
353 INSERT INTO t1 VALUES(null);
354 INSERT INTO t1 VALUES(null);
355 SELECT * FROM t1;
356 DROP TABLE t1;
357 SHOW TABLES;
358 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
359 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
360 SHOW CREATE TABLE t1;
361 SET INSERT_ID = 10;
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 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
370 SHOW CREATE TABLE t1;
371 SET INSERT_ID = 10;
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 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
379 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
380 SHOW CREATE TABLE t1;
381 SET INSERT_ID = 10;
382 INSERT INTO t1 VALUES(null);
383 INSERT INTO t1 VALUES(null);
384 INSERT INTO t1 VALUES(null);
385 SELECT * FROM t1;
386 DROP TABLE t1;
387 SHOW TABLES;
388 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
389 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
390 SHOW CREATE TABLE t1;
391 SET INSERT_ID = 10;
392 INSERT INTO t1 VALUES(null);
393 INSERT INTO t1 VALUES(null);
394 INSERT INTO t1 VALUES(null);
395 SELECT * FROM t1;
396 DROP TABLE t1;
397 SHOW TABLES;
398 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
399 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
400 SHOW CREATE TABLE t1;
401 SET INSERT_ID = 10;
402 INSERT INTO t1 VALUES(null);
403 INSERT INTO t1 VALUES(null);
404 INSERT INTO t1 VALUES(null);
405 SELECT * FROM t1;
406 DROP TABLE t1;
407 SHOW TABLES;
408 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
409 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
410 SHOW CREATE TABLE t1;
411 SET INSERT_ID = 10;
412 INSERT INTO t1 VALUES(null);
413 INSERT INTO t1 VALUES(null);
414 INSERT INTO t1 VALUES(null);
415 SELECT * FROM t1;
416 DROP TABLE t1;
417 SHOW TABLES;
418 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
419 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
420 SHOW CREATE TABLE t1;
421 SET INSERT_ID = 10;
422 INSERT INTO t1 VALUES(null);
423 INSERT INTO t1 VALUES(null);
424 INSERT INTO t1 VALUES(null);
425 SELECT * FROM t1;
426 DROP TABLE t1;
427 SHOW TABLES;
428 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
429 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
430 SHOW CREATE TABLE t1;
431 SET INSERT_ID = 10;
432 INSERT INTO t1 VALUES(null);
433 INSERT INTO t1 VALUES(null);
434 INSERT INTO t1 VALUES(null);
435 SELECT * FROM t1;
436 DROP TABLE t1;
437 SHOW TABLES;
438 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
439 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
440 SHOW CREATE TABLE t1;
441 SET INSERT_ID = 10;
442 INSERT INTO t1 VALUES(null);
443 INSERT INTO t1 VALUES(null);
444 INSERT INTO t1 VALUES(null);
445 SELECT * FROM t1;
446 DROP TABLE t1;
447 SHOW TABLES;
448 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
449 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
450 SHOW CREATE TABLE t1;
451 SET INSERT_ID = 10;
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 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
459 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
460 SHOW CREATE TABLE t1;
461 SET INSERT_ID = 10;
462 INSERT INTO t1 VALUES(null);
463 INSERT INTO t1 VALUES(null);
464 INSERT INTO t1 VALUES(null);
465 SELECT * FROM t1;
466 DROP TABLE t1;
467 SHOW TABLES;
468 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
469 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
470 SHOW CREATE TABLE t1;
471 SET INSERT_ID = 10;
472 INSERT INTO t1 VALUES(null);
473 INSERT INTO t1 VALUES(null);
474 INSERT INTO t1 VALUES(null);
475 SELECT * FROM t1;
476 DROP TABLE t1;
477 SHOW TABLES;
478 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
479 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
480 SHOW CREATE TABLE t1;
481 SET INSERT_ID = 10;
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 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
489 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
490 SHOW CREATE TABLE t1;
491 SET INSERT_ID = 10;
492 INSERT INTO t1 VALUES(null);
493 INSERT INTO t1 VALUES(null);
494 INSERT INTO t1 VALUES(null);
495 SELECT * FROM t1;
496 DROP TABLE t1;
497 SHOW TABLES;
498 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
499 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
500 SHOW CREATE TABLE t1;
501 SET INSERT_ID = 10;
502 INSERT INTO t1 VALUES(null);
503 INSERT INTO t1 VALUES(null);
504 INSERT INTO t1 VALUES(null);
505 SELECT * FROM t1;
506 DROP TABLE t1;
507 SHOW TABLES;
508 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
509 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
510 SHOW CREATE TABLE t1;
511 SET INSERT_ID = 10;
512 INSERT INTO t1 VALUES(null);
513 INSERT INTO t1 VALUES(null);
514 INSERT INTO t1 VALUES(null);
515 SELECT * FROM t1;
516 DROP TABLE t1;
517 SHOW TABLES;
518 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
519 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
520 SHOW CREATE TABLE t1;
521 SET INSERT_ID = 10;
522 INSERT INTO t1 VALUES(null);
523 INSERT INTO t1 VALUES(null);
524 INSERT INTO t1 VALUES(null);
525 SELECT * FROM t1;
526 DROP TABLE t1;
527 SHOW TABLES;
528 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
529 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
530 SHOW CREATE TABLE t1;
531 SET INSERT_ID = 10;
532 INSERT INTO t1 VALUES(null);
533 INSERT INTO t1 VALUES(null);
534 INSERT INTO t1 VALUES(null);
535 SELECT * FROM t1;
536 DROP TABLE t1;
537 SHOW TABLES;
538 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
539 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
540 SHOW CREATE TABLE t1;
541 SET INSERT_ID = 10;
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;
548 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
549 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
550 SHOW CREATE TABLE t1;
551 SET INSERT_ID = 10;
552 INSERT INTO t1 VALUES(null);
553 INSERT INTO t1 VALUES(null);
554 INSERT INTO t1 VALUES(null);
555 SELECT * FROM t1;
556 DROP TABLE t1;
557 SHOW TABLES;
558 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
559 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
560 SHOW CREATE TABLE t1;
561 SET INSERT_ID = 10;
562 INSERT INTO t1 VALUES(null);
563 INSERT INTO t1 VALUES(null);
564 INSERT INTO t1 VALUES(null);
565 SELECT * FROM t1;
566 DROP TABLE t1;
567 SHOW TABLES;
568 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
569 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
570 SHOW CREATE TABLE t1;
571 SET INSERT_ID = 10;
572 INSERT INTO t1 VALUES(null);
573 INSERT INTO t1 VALUES(null);
574 INSERT INTO t1 VALUES(null);
575 SELECT * FROM t1;
576 DROP TABLE t1;
577 SHOW TABLES;
578 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
579 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
580 SHOW CREATE TABLE t1;
581 SET INSERT_ID = 10;
582 INSERT INTO t1 VALUES(null);
583 INSERT INTO t1 VALUES(null);
584 INSERT INTO t1 VALUES(null);
585 SELECT * FROM t1;
586 DROP TABLE t1;
587 SHOW TABLES;
588 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
589 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
590 SHOW CREATE TABLE t1;
591 SET INSERT_ID = 10;
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 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
599 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
600 SHOW CREATE TABLE t1;
601 SET INSERT_ID = 10;
602 INSERT INTO t1 VALUES(null);
603 INSERT INTO t1 VALUES(null);
604 INSERT INTO t1 VALUES(null);
605 SELECT * FROM t1;
606 DROP TABLE t1;
607 SHOW TABLES;