Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_init_create_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 ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
9 INSERT INTO t1 VALUES(null);
10 INSERT INTO t1 VALUES(null);
11 SELECT * FROM t1;
12 DROP TABLE t1;
13 SHOW TABLES;
14 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
15 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
17 SHOW CREATE TABLE t1;
18 INSERT INTO t1 VALUES(null);
19 INSERT INTO t1 VALUES(null);
20 INSERT INTO t1 VALUES(null);
21 SELECT * FROM t1;
22 DROP TABLE t1;
23 SHOW TABLES;
24 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
25 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
27 SHOW CREATE TABLE t1;
28 INSERT INTO t1 VALUES(null);
29 INSERT INTO t1 VALUES(null);
30 INSERT INTO t1 VALUES(null);
31 SELECT * FROM t1;
32 DROP TABLE t1;
33 SHOW TABLES;
34 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
35 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 NULL KEY ) AUTO_INCREMENT=10;
45 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
47 SHOW CREATE TABLE t1;
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
51 SELECT * FROM t1;
52 DROP TABLE t1;
53 SHOW TABLES;
54 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
55 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
57 SHOW CREATE TABLE t1;
58 INSERT INTO t1 VALUES(null);
59 INSERT INTO t1 VALUES(null);
60 INSERT INTO t1 VALUES(null);
61 SELECT * FROM t1;
62 DROP TABLE t1;
63 SHOW TABLES;
64 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
65 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
66 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
67 SHOW CREATE TABLE t1;
68 INSERT INTO t1 VALUES(null);
69 INSERT INTO t1 VALUES(null);
70 INSERT INTO t1 VALUES(null);
71 SELECT * FROM t1;
72 DROP TABLE t1;
73 SHOW TABLES;
74 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
75 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
76 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
77 SHOW CREATE TABLE t1;
78 INSERT INTO t1 VALUES(null);
79 INSERT INTO t1 VALUES(null);
80 INSERT INTO t1 VALUES(null);
81 SELECT * FROM t1;
82 DROP TABLE t1;
83 SHOW TABLES;
84 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
85 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
87 SHOW CREATE TABLE t1;
88 INSERT INTO t1 VALUES(null);
89 INSERT INTO t1 VALUES(null);
90 INSERT INTO t1 VALUES(null);
91 SELECT * FROM t1;
92 DROP TABLE t1;
93 SHOW TABLES;
94 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
95 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
97 SHOW CREATE TABLE t1;
98 INSERT INTO t1 VALUES(null);
99 INSERT INTO t1 VALUES(null);
100 INSERT INTO t1 VALUES(null);
101 SELECT * FROM t1;
102 DROP TABLE t1;
103 SHOW TABLES;
104 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) 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 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
119 INSERT INTO t1 VALUES(null);
120 INSERT INTO t1 VALUES(null);
121 SELECT * FROM t1;
122 DROP TABLE t1;
123 SHOW TABLES;
124 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
125 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
126 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
135 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
136 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
137 SHOW CREATE TABLE t1;
138 INSERT INTO t1 VALUES(null);
139 INSERT INTO t1 VALUES(null);
140 INSERT INTO t1 VALUES(null);
141 SELECT * FROM t1;
142 DROP TABLE t1;
143 SHOW TABLES;
144 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
145 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
147 SHOW CREATE TABLE t1;
148 INSERT INTO t1 VALUES(null);
149 INSERT INTO t1 VALUES(null);
150 INSERT INTO t1 VALUES(null);
151 SELECT * FROM t1;
152 DROP TABLE t1;
153 SHOW TABLES;
154 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
155 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
156 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
157 SHOW CREATE TABLE t1;
158 INSERT INTO t1 VALUES(null);
159 INSERT INTO t1 VALUES(null);
160 INSERT INTO t1 VALUES(null);
161 SELECT * FROM t1;
162 DROP TABLE t1;
163 SHOW TABLES;
164 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
165 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
166 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
167 SHOW CREATE TABLE t1;
168 INSERT INTO t1 VALUES(null);
169 INSERT INTO t1 VALUES(null);
170 INSERT INTO t1 VALUES(null);
171 SELECT * FROM t1;
172 DROP TABLE t1;
173 SHOW TABLES;
174 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
175 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
177 SHOW CREATE TABLE t1;
178 INSERT INTO t1 VALUES(null);
179 INSERT INTO t1 VALUES(null);
180 INSERT INTO t1 VALUES(null);
181 SELECT * FROM t1;
182 DROP TABLE t1;
183 SHOW TABLES;
184 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
185 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
186 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
187 SHOW CREATE TABLE t1;
188 INSERT INTO t1 VALUES(null);
189 INSERT INTO t1 VALUES(null);
190 INSERT INTO t1 VALUES(null);
191 SELECT * FROM t1;
192 DROP TABLE t1;
193 SHOW TABLES;
194 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
195 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
197 SHOW CREATE TABLE t1;
198 INSERT INTO t1 VALUES(null);
199 INSERT INTO t1 VALUES(null);
200 INSERT INTO t1 VALUES(null);
201 SELECT * FROM t1;
202 DROP TABLE t1;
203 SHOW TABLES;
204 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
205 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
206 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
207 SHOW CREATE TABLE t1;
208 INSERT INTO t1 VALUES(null);
209 INSERT INTO t1 VALUES(null);
210 INSERT INTO t1 VALUES(null);
211 SELECT * FROM t1;
212 DROP TABLE t1;
213 SHOW TABLES;
214 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) 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 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
229 INSERT INTO t1 VALUES(null);
230 INSERT INTO t1 VALUES(null);
231 SELECT * FROM t1;
232 DROP TABLE t1;
233 SHOW TABLES;
234 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
235 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
236 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
237 SHOW CREATE TABLE t1;
238 INSERT INTO t1 VALUES(null);
239 INSERT INTO t1 VALUES(null);
240 INSERT INTO t1 VALUES(null);
241 SELECT * FROM t1;
242 DROP TABLE t1;
243 SHOW TABLES;
244 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
245 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
246 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
247 SHOW CREATE TABLE t1;
248 INSERT INTO t1 VALUES(null);
249 INSERT INTO t1 VALUES(null);
250 INSERT INTO t1 VALUES(null);
251 SELECT * FROM t1;
252 DROP TABLE t1;
253 SHOW TABLES;
254 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
255 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
256 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
257 SHOW CREATE TABLE t1;
258 INSERT INTO t1 VALUES(null);
259 INSERT INTO t1 VALUES(null);
260 INSERT INTO t1 VALUES(null);
261 SELECT * FROM t1;
262 DROP TABLE t1;
263 SHOW TABLES;
264 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
265 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
266 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
267 SHOW CREATE TABLE t1;
268 INSERT INTO t1 VALUES(null);
269 INSERT INTO t1 VALUES(null);
270 INSERT INTO t1 VALUES(null);
271 SELECT * FROM t1;
272 DROP TABLE t1;
273 SHOW TABLES;
274 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
275 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
276 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
277 SHOW CREATE TABLE t1;
278 INSERT INTO t1 VALUES(null);
279 INSERT INTO t1 VALUES(null);
280 INSERT INTO t1 VALUES(null);
281 SELECT * FROM t1;
282 DROP TABLE t1;
283 SHOW TABLES;
284 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
285 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
286 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
287 SHOW CREATE TABLE t1;
288 INSERT INTO t1 VALUES(null);
289 INSERT INTO t1 VALUES(null);
290 INSERT INTO t1 VALUES(null);
291 SELECT * FROM t1;
292 DROP TABLE t1;
293 SHOW TABLES;
294 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
295 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
297 SHOW CREATE TABLE t1;
298 INSERT INTO t1 VALUES(null);
299 INSERT INTO t1 VALUES(null);
300 INSERT INTO t1 VALUES(null);
301 SELECT * FROM t1;
302 DROP TABLE t1;
303 SHOW TABLES;
304 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
305 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
306 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
315 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
316 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
317 SHOW CREATE TABLE t1;
318 INSERT INTO t1 VALUES(null);
319 INSERT INTO t1 VALUES(null);
320 INSERT INTO t1 VALUES(null);
321 SELECT * FROM t1;
322 DROP TABLE t1;
323 SHOW TABLES;
324 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY ) 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 INT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
339 INSERT INTO t1 VALUES(null);
340 INSERT INTO t1 VALUES(null);
341 SELECT * FROM t1;
342 DROP TABLE t1;
343 SHOW TABLES;
344 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
345 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
346 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
347 SHOW CREATE TABLE t1;
348 INSERT INTO t1 VALUES(null);
349 INSERT INTO t1 VALUES(null);
350 INSERT INTO t1 VALUES(null);
351 SELECT * FROM t1;
352 DROP TABLE t1;
353 SHOW TABLES;
354 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
355 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
356 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
357 SHOW CREATE TABLE t1;
358 INSERT INTO t1 VALUES(null);
359 INSERT INTO t1 VALUES(null);
360 INSERT INTO t1 VALUES(null);
361 SELECT * FROM t1;
362 DROP TABLE t1;
363 SHOW TABLES;
364 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
365 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
366 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
367 SHOW CREATE TABLE t1;
368 INSERT INTO t1 VALUES(null);
369 INSERT INTO t1 VALUES(null);
370 INSERT INTO t1 VALUES(null);
371 SELECT * FROM t1;
372 DROP TABLE t1;
373 SHOW TABLES;
374 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
375 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
376 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
377 SHOW CREATE TABLE t1;
378 INSERT INTO t1 VALUES(null);
379 INSERT INTO t1 VALUES(null);
380 INSERT INTO t1 VALUES(null);
381 SELECT * FROM t1;
382 DROP TABLE t1;
383 SHOW TABLES;
384 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
385 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
386 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
387 SHOW CREATE TABLE t1;
388 INSERT INTO t1 VALUES(null);
389 INSERT INTO t1 VALUES(null);
390 INSERT INTO t1 VALUES(null);
391 SELECT * FROM t1;
392 DROP TABLE t1;
393 SHOW TABLES;
394 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
395 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
405 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
406 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
407 SHOW CREATE TABLE t1;
408 INSERT INTO t1 VALUES(null);
409 INSERT INTO t1 VALUES(null);
410 INSERT INTO t1 VALUES(null);
411 SELECT * FROM t1;
412 DROP TABLE t1;
413 SHOW TABLES;
414 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
415 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
416 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
417 SHOW CREATE TABLE t1;
418 INSERT INTO t1 VALUES(null);
419 INSERT INTO t1 VALUES(null);
420 INSERT INTO t1 VALUES(null);
421 SELECT * FROM t1;
422 DROP TABLE t1;
423 SHOW TABLES;
424 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
425 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
426 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
427 SHOW CREATE TABLE t1;
428 INSERT INTO t1 VALUES(null);
429 INSERT INTO t1 VALUES(null);
430 INSERT INTO t1 VALUES(null);
431 SELECT * FROM t1;
432 DROP TABLE t1;
433 SHOW TABLES;
434 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) 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 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
449 INSERT INTO t1 VALUES(null);
450 INSERT INTO t1 VALUES(null);
451 SELECT * FROM t1;
452 DROP TABLE t1;
453 SHOW TABLES;
454 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
455 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
456 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
457 SHOW CREATE TABLE t1;
458 INSERT INTO t1 VALUES(null);
459 INSERT INTO t1 VALUES(null);
460 INSERT INTO t1 VALUES(null);
461 SELECT * FROM t1;
462 DROP TABLE t1;
463 SHOW TABLES;
464 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
465 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
466 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
467 SHOW CREATE TABLE t1;
468 INSERT INTO t1 VALUES(null);
469 INSERT INTO t1 VALUES(null);
470 INSERT INTO t1 VALUES(null);
471 SELECT * FROM t1;
472 DROP TABLE t1;
473 SHOW TABLES;
474 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
475 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
476 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
477 SHOW CREATE TABLE t1;
478 INSERT INTO t1 VALUES(null);
479 INSERT INTO t1 VALUES(null);
480 INSERT INTO t1 VALUES(null);
481 SELECT * FROM t1;
482 DROP TABLE t1;
483 SHOW TABLES;
484 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
485 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
486 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
495 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
497 SHOW CREATE TABLE t1;
498 INSERT INTO t1 VALUES(null);
499 INSERT INTO t1 VALUES(null);
500 INSERT INTO t1 VALUES(null);
501 SELECT * FROM t1;
502 DROP TABLE t1;
503 SHOW TABLES;
504 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
505 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
506 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
507 SHOW CREATE TABLE t1;
508 INSERT INTO t1 VALUES(null);
509 INSERT INTO t1 VALUES(null);
510 INSERT INTO t1 VALUES(null);
511 SELECT * FROM t1;
512 DROP TABLE t1;
513 SHOW TABLES;
514 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
515 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
516 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
517 SHOW CREATE TABLE t1;
518 INSERT INTO t1 VALUES(null);
519 INSERT INTO t1 VALUES(null);
520 INSERT INTO t1 VALUES(null);
521 SELECT * FROM t1;
522 DROP TABLE t1;
523 SHOW TABLES;
524 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
525 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
526 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
527 SHOW CREATE TABLE t1;
528 INSERT INTO t1 VALUES(null);
529 INSERT INTO t1 VALUES(null);
530 INSERT INTO t1 VALUES(null);
531 SELECT * FROM t1;
532 DROP TABLE t1;
533 SHOW TABLES;
534 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
535 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
536 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
537 SHOW CREATE TABLE t1;
538 INSERT INTO t1 VALUES(null);
539 INSERT INTO t1 VALUES(null);
540 INSERT INTO t1 VALUES(null);
541 SELECT * FROM t1;
542 DROP TABLE t1;
543 SHOW TABLES;
544 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) 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 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
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 INSERT INTO t1 VALUES(null);
559 INSERT INTO t1 VALUES(null);
560 INSERT INTO t1 VALUES(null);
561 SELECT * FROM t1;
562 DROP TABLE t1;
563 SHOW TABLES;
564 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
565 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
566 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
567 SHOW CREATE TABLE t1;
568 INSERT INTO t1 VALUES(null);
569 INSERT INTO t1 VALUES(null);
570 INSERT INTO t1 VALUES(null);
571 SELECT * FROM t1;
572 DROP TABLE t1;
573 SHOW TABLES;
574 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
575 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
576 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
577 SHOW CREATE TABLE t1;
578 INSERT INTO t1 VALUES(null);
579 INSERT INTO t1 VALUES(null);
580 INSERT INTO t1 VALUES(null);
581 SELECT * FROM t1;
582 DROP TABLE t1;
583 SHOW TABLES;
584 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
585 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
586 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
587 SHOW CREATE TABLE t1;
588 INSERT INTO t1 VALUES(null);
589 INSERT INTO t1 VALUES(null);
590 INSERT INTO t1 VALUES(null);
591 SELECT * FROM t1;
592 DROP TABLE t1;
593 SHOW TABLES;
594 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
595 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
596 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
597 SHOW CREATE TABLE t1;
598 INSERT INTO t1 VALUES(null);
599 INSERT INTO t1 VALUES(null);
600 INSERT INTO t1 VALUES(null);
601 SELECT * FROM t1;
602 DROP TABLE t1;
603 SHOW TABLES;
604