Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_init_insert_id.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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
6 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
7 SHOW CREATE TABLE t1;
8 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
18 SHOW CREATE TABLE t1;
19 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
29 SHOW CREATE TABLE t1;
30 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
39 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 NULL KEY );
49 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
51 SHOW CREATE TABLE t1;
52 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
61 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
62 SHOW CREATE TABLE t1;
63 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
73 SHOW CREATE TABLE t1;
74 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
83 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
84 SHOW CREATE TABLE t1;
85 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
94 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
95 SHOW CREATE TABLE t1;
96 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
105 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
106 SHOW CREATE TABLE t1;
107 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
117 SHOW CREATE TABLE t1;
118 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
128 SHOW CREATE TABLE t1;
129 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
138 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
139 SHOW CREATE TABLE t1;
140 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
149 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
159 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
160 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
161 SHOW CREATE TABLE t1;
162 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
171 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
172 SHOW CREATE TABLE t1;
173 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
183 SHOW CREATE TABLE t1;
184 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
193 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
194 SHOW CREATE TABLE t1;
195 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
204 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
205 SHOW CREATE TABLE t1;
206 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
215 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
216 SHOW CREATE TABLE t1;
217 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
226 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
227 SHOW CREATE TABLE t1;
228 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
237 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
238 SHOW CREATE TABLE t1;
239 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
249 SHOW CREATE TABLE t1;
250 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
269 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
270 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
271 SHOW CREATE TABLE t1;
272 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
281 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
282 SHOW CREATE TABLE t1;
283 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
292 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
293 SHOW CREATE TABLE t1;
294 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
303 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
304 SHOW CREATE TABLE t1;
305 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
314 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
315 SHOW CREATE TABLE t1;
316 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
325 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
326 SHOW CREATE TABLE t1;
327 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
336 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
337 SHOW CREATE TABLE t1;
338 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
347 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
348 SHOW CREATE TABLE t1;
349 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
358 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
359 SHOW CREATE TABLE t1;
360 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
379 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
380 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
381 SHOW CREATE TABLE t1;
382 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
391 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
392 SHOW CREATE TABLE t1;
393 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
402 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
403 SHOW CREATE TABLE t1;
404 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
413 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
414 SHOW CREATE TABLE t1;
415 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
424 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
425 SHOW CREATE TABLE t1;
426 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
435 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
436 SHOW CREATE TABLE t1;
437 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
446 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
447 SHOW CREATE TABLE t1;
448 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
457 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
458 SHOW CREATE TABLE t1;
459 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
468 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
469 SHOW CREATE TABLE t1;
470 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
479 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
489 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
490 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
491 SHOW CREATE TABLE t1;
492 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
501 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
502 SHOW CREATE TABLE t1;
503 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
512 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
513 SHOW CREATE TABLE t1;
514 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
523 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
524 SHOW CREATE TABLE t1;
525 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
534 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
535 SHOW CREATE TABLE t1;
536 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
545 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
546 SHOW CREATE TABLE t1;
547 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
556 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
557 SHOW CREATE TABLE t1;
558 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
567 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
568 SHOW CREATE TABLE t1;
569 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
578 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
579 SHOW CREATE TABLE t1;
580 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
589 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
599 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
600 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
601 SHOW CREATE TABLE t1;
602 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
611 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
612 SHOW CREATE TABLE t1;
613 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
622 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
623 SHOW CREATE TABLE t1;
624 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
633 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
634 SHOW CREATE TABLE t1;
635 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
644 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
645 SHOW CREATE TABLE t1;
646 SET INSERT_ID = 10;
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 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
655 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
656 SHOW CREATE TABLE t1;
657 SET INSERT_ID = 10;
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