Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_reset_by_truncate.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 --sorted_result
15 SELECT * FROM t1;
16 TRUNCATE TABLE t1;
17 INSERT INTO t1 VALUES(null);
18 --sorted_result
19 SELECT * FROM t1;
20 ALTER TABLE t1 AUTO_INCREMENT=10;
21 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
22 SHOW CREATE TABLE t1;
23 INSERT INTO t1 VALUES(null);
24 INSERT INTO t1 VALUES(null);
25 INSERT INTO t1 VALUES(null);
26 --sorted_result
27 SELECT * FROM t1;
28 TRUNCATE TABLE t1;
29 INSERT INTO t1 VALUES(null);
30 --sorted_result
31 SELECT * FROM t1;
32 DROP TABLE t1;
33 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
35 SHOW CREATE TABLE t1;
36 INSERT INTO t1 VALUES(null);
37 INSERT INTO t1 VALUES(null);
38 INSERT INTO t1 VALUES(null);
39 --sorted_result
40 SELECT * FROM t1;
41 TRUNCATE TABLE t1;
42 INSERT INTO t1 VALUES(null);
43 --sorted_result
44 SELECT * FROM t1;
45 ALTER TABLE t1 AUTO_INCREMENT=10;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t1;
48 INSERT INTO t1 VALUES(null);
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
51 --sorted_result
52 SELECT * FROM t1;
53 TRUNCATE TABLE t1;
54 INSERT INTO t1 VALUES(null);
55 --sorted_result
56 SELECT * FROM t1;
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
60 SHOW CREATE TABLE t1;
61 INSERT INTO t1 VALUES(null);
62 INSERT INTO t1 VALUES(null);
63 INSERT INTO t1 VALUES(null);
64 --sorted_result
65 SELECT * FROM t1;
66 TRUNCATE TABLE t1;
67 INSERT INTO t1 VALUES(null);
68 --sorted_result
69 SELECT * FROM t1;
70 ALTER TABLE t1 AUTO_INCREMENT=10;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE t1;
73 INSERT INTO t1 VALUES(null);
74 INSERT INTO t1 VALUES(null);
75 INSERT INTO t1 VALUES(null);
76 --sorted_result
77 SELECT * FROM t1;
78 TRUNCATE TABLE t1;
79 INSERT INTO t1 VALUES(null);
80 --sorted_result
81 SELECT * FROM t1;
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
84 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
85 SHOW CREATE TABLE t1;
86 INSERT INTO t1 VALUES(null);
87 INSERT INTO t1 VALUES(null);
88 INSERT INTO t1 VALUES(null);
89 --sorted_result
90 SELECT * FROM t1;
91 TRUNCATE TABLE t1;
92 INSERT INTO t1 VALUES(null);
93 --sorted_result
94 SELECT * FROM t1;
95 ALTER TABLE t1 AUTO_INCREMENT=10;
96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
97 SHOW CREATE TABLE t1;
98 INSERT INTO t1 VALUES(null);
99 INSERT INTO t1 VALUES(null);
100 INSERT INTO t1 VALUES(null);
101 --sorted_result
102 SELECT * FROM t1;
103 TRUNCATE TABLE t1;
104 INSERT INTO t1 VALUES(null);
105 --sorted_result
106 SELECT * FROM t1;
107 DROP TABLE t1;
108 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
109 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
110 SHOW CREATE TABLE t1;
111 INSERT INTO t1 VALUES(null);
112 INSERT INTO t1 VALUES(null);
113 INSERT INTO t1 VALUES(null);
114 --sorted_result
115 SELECT * FROM t1;
116 TRUNCATE TABLE t1;
117 INSERT INTO t1 VALUES(null);
118 --sorted_result
119 SELECT * FROM t1;
120 ALTER TABLE t1 AUTO_INCREMENT=10;
121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
122 SHOW CREATE TABLE t1;
123 INSERT INTO t1 VALUES(null);
124 INSERT INTO t1 VALUES(null);
125 INSERT INTO t1 VALUES(null);
126 --sorted_result
127 SELECT * FROM t1;
128 TRUNCATE TABLE t1;
129 INSERT INTO t1 VALUES(null);
130 --sorted_result
131 SELECT * FROM t1;
132 DROP TABLE t1;
133 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
135 SHOW CREATE TABLE t1;
136 INSERT INTO t1 VALUES(null);
137 INSERT INTO t1 VALUES(null);
138 INSERT INTO t1 VALUES(null);
139 --sorted_result
140 SELECT * FROM t1;
141 TRUNCATE TABLE t1;
142 INSERT INTO t1 VALUES(null);
143 --sorted_result
144 SELECT * FROM t1;
145 ALTER TABLE t1 AUTO_INCREMENT=10;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147 SHOW CREATE TABLE t1;
148 INSERT INTO t1 VALUES(null);
149 INSERT INTO t1 VALUES(null);
150 INSERT INTO t1 VALUES(null);
151 --sorted_result
152 SELECT * FROM t1;
153 TRUNCATE TABLE t1;
154 INSERT INTO t1 VALUES(null);
155 --sorted_result
156 SELECT * FROM t1;
157 DROP TABLE t1;
158 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
159 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
160 SHOW CREATE TABLE t1;
161 INSERT INTO t1 VALUES(null);
162 INSERT INTO t1 VALUES(null);
163 INSERT INTO t1 VALUES(null);
164 --sorted_result
165 SELECT * FROM t1;
166 TRUNCATE TABLE t1;
167 INSERT INTO t1 VALUES(null);
168 --sorted_result
169 SELECT * FROM t1;
170 ALTER TABLE t1 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 --sorted_result
177 SELECT * FROM t1;
178 TRUNCATE TABLE t1;
179 INSERT INTO t1 VALUES(null);
180 --sorted_result
181 SELECT * FROM t1;
182 DROP TABLE t1;
183 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
185 SHOW CREATE TABLE t1;
186 INSERT INTO t1 VALUES(null);
187 INSERT INTO t1 VALUES(null);
188 INSERT INTO t1 VALUES(null);
189 --sorted_result
190 SELECT * FROM t1;
191 TRUNCATE TABLE t1;
192 INSERT INTO t1 VALUES(null);
193 --sorted_result
194 SELECT * FROM t1;
195 ALTER TABLE t1 AUTO_INCREMENT=10;
196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
197 SHOW CREATE TABLE t1;
198 INSERT INTO t1 VALUES(null);
199 INSERT INTO t1 VALUES(null);
200 INSERT INTO t1 VALUES(null);
201 --sorted_result
202 SELECT * FROM t1;
203 TRUNCATE TABLE t1;
204 INSERT INTO t1 VALUES(null);
205 --sorted_result
206 SELECT * FROM t1;
207 DROP TABLE t1;
208 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
210 SHOW CREATE TABLE t1;
211 INSERT INTO t1 VALUES(null);
212 INSERT INTO t1 VALUES(null);
213 INSERT INTO t1 VALUES(null);
214 --sorted_result
215 SELECT * FROM t1;
216 TRUNCATE TABLE t1;
217 INSERT INTO t1 VALUES(null);
218 --sorted_result
219 SELECT * FROM t1;
220 ALTER TABLE t1 AUTO_INCREMENT=10;
221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
222 SHOW CREATE TABLE t1;
223 INSERT INTO t1 VALUES(null);
224 INSERT INTO t1 VALUES(null);
225 INSERT INTO t1 VALUES(null);
226 --sorted_result
227 SELECT * FROM t1;
228 TRUNCATE TABLE t1;
229 INSERT INTO t1 VALUES(null);
230 --sorted_result
231 SELECT * FROM t1;
232 DROP TABLE t1;
233 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL 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 --sorted_result
240 SELECT * FROM t1;
241 TRUNCATE TABLE t1;
242 INSERT INTO t1 VALUES(null);
243 --sorted_result
244 SELECT * FROM t1;
245 ALTER TABLE t1 AUTO_INCREMENT=10;
246 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
247 SHOW CREATE TABLE t1;
248 INSERT INTO t1 VALUES(null);
249 INSERT INTO t1 VALUES(null);
250 INSERT INTO t1 VALUES(null);
251 --sorted_result
252 SELECT * FROM t1;
253 TRUNCATE TABLE t1;
254 INSERT INTO t1 VALUES(null);
255 --sorted_result
256 SELECT * FROM t1;
257 DROP TABLE t1;
258 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
260 SHOW CREATE TABLE t1;
261 INSERT INTO t1 VALUES(null);
262 INSERT INTO t1 VALUES(null);
263 INSERT INTO t1 VALUES(null);
264 --sorted_result
265 SELECT * FROM t1;
266 TRUNCATE TABLE t1;
267 INSERT INTO t1 VALUES(null);
268 --sorted_result
269 SELECT * FROM t1;
270 ALTER TABLE t1 AUTO_INCREMENT=10;
271 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
272 SHOW CREATE TABLE t1;
273 INSERT INTO t1 VALUES(null);
274 INSERT INTO t1 VALUES(null);
275 INSERT INTO t1 VALUES(null);
276 --sorted_result
277 SELECT * FROM t1;
278 TRUNCATE TABLE t1;
279 INSERT INTO t1 VALUES(null);
280 --sorted_result
281 SELECT * FROM t1;
282 DROP TABLE t1;
283 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
285 SHOW CREATE TABLE t1;
286 INSERT INTO t1 VALUES(null);
287 INSERT INTO t1 VALUES(null);
288 INSERT INTO t1 VALUES(null);
289 --sorted_result
290 SELECT * FROM t1;
291 TRUNCATE TABLE t1;
292 INSERT INTO t1 VALUES(null);
293 --sorted_result
294 SELECT * FROM t1;
295 ALTER TABLE t1 AUTO_INCREMENT=10;
296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
297 SHOW CREATE TABLE t1;
298 INSERT INTO t1 VALUES(null);
299 INSERT INTO t1 VALUES(null);
300 INSERT INTO t1 VALUES(null);
301 --sorted_result
302 SELECT * FROM t1;
303 TRUNCATE TABLE t1;
304 INSERT INTO t1 VALUES(null);
305 --sorted_result
306 SELECT * FROM t1;
307 DROP TABLE t1;
308 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
309 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
310 SHOW CREATE TABLE t1;
311 INSERT INTO t1 VALUES(null);
312 INSERT INTO t1 VALUES(null);
313 INSERT INTO t1 VALUES(null);
314 --sorted_result
315 SELECT * FROM t1;
316 TRUNCATE TABLE t1;
317 INSERT INTO t1 VALUES(null);
318 --sorted_result
319 SELECT * FROM t1;
320 ALTER TABLE t1 AUTO_INCREMENT=10;
321 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
322 SHOW CREATE TABLE t1;
323 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
325 INSERT INTO t1 VALUES(null);
326 --sorted_result
327 SELECT * FROM t1;
328 TRUNCATE TABLE t1;
329 INSERT INTO t1 VALUES(null);
330 --sorted_result
331 SELECT * FROM t1;
332 DROP TABLE t1;
333 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
334 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
335 SHOW CREATE TABLE t1;
336 INSERT INTO t1 VALUES(null);
337 INSERT INTO t1 VALUES(null);
338 INSERT INTO t1 VALUES(null);
339 --sorted_result
340 SELECT * FROM t1;
341 TRUNCATE TABLE t1;
342 INSERT INTO t1 VALUES(null);
343 --sorted_result
344 SELECT * FROM t1;
345 ALTER TABLE t1 AUTO_INCREMENT=10;
346 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
347 SHOW CREATE TABLE t1;
348 INSERT INTO t1 VALUES(null);
349 INSERT INTO t1 VALUES(null);
350 INSERT INTO t1 VALUES(null);
351 --sorted_result
352 SELECT * FROM t1;
353 TRUNCATE TABLE t1;
354 INSERT INTO t1 VALUES(null);
355 --sorted_result
356 SELECT * FROM t1;
357 DROP TABLE t1;
358 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
359 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
360 SHOW CREATE TABLE t1;
361 INSERT INTO t1 VALUES(null);
362 INSERT INTO t1 VALUES(null);
363 INSERT INTO t1 VALUES(null);
364 --sorted_result
365 SELECT * FROM t1;
366 TRUNCATE TABLE t1;
367 INSERT INTO t1 VALUES(null);
368 --sorted_result
369 SELECT * FROM t1;
370 ALTER TABLE t1 AUTO_INCREMENT=10;
371 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
372 SHOW CREATE TABLE t1;
373 INSERT INTO t1 VALUES(null);
374 INSERT INTO t1 VALUES(null);
375 INSERT INTO t1 VALUES(null);
376 --sorted_result
377 SELECT * FROM t1;
378 TRUNCATE TABLE t1;
379 INSERT INTO t1 VALUES(null);
380 --sorted_result
381 SELECT * FROM t1;
382 DROP TABLE t1;
383 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
385 SHOW CREATE TABLE t1;
386 INSERT INTO t1 VALUES(null);
387 INSERT INTO t1 VALUES(null);
388 INSERT INTO t1 VALUES(null);
389 --sorted_result
390 SELECT * FROM t1;
391 TRUNCATE TABLE t1;
392 INSERT INTO t1 VALUES(null);
393 --sorted_result
394 SELECT * FROM t1;
395 ALTER TABLE t1 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 --sorted_result
402 SELECT * FROM t1;
403 TRUNCATE TABLE t1;
404 INSERT INTO t1 VALUES(null);
405 --sorted_result
406 SELECT * FROM t1;
407 DROP TABLE t1;
408 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
409 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
410 SHOW CREATE TABLE t1;
411 INSERT INTO t1 VALUES(null);
412 INSERT INTO t1 VALUES(null);
413 INSERT INTO t1 VALUES(null);
414 --sorted_result
415 SELECT * FROM t1;
416 TRUNCATE TABLE t1;
417 INSERT INTO t1 VALUES(null);
418 --sorted_result
419 SELECT * FROM t1;
420 ALTER TABLE t1 AUTO_INCREMENT=10;
421 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
422 SHOW CREATE TABLE t1;
423 INSERT INTO t1 VALUES(null);
424 INSERT INTO t1 VALUES(null);
425 INSERT INTO t1 VALUES(null);
426 --sorted_result
427 SELECT * FROM t1;
428 TRUNCATE TABLE t1;
429 INSERT INTO t1 VALUES(null);
430 --sorted_result
431 SELECT * FROM t1;
432 DROP TABLE t1;
433 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
434 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
435 SHOW CREATE TABLE t1;
436 INSERT INTO t1 VALUES(null);
437 INSERT INTO t1 VALUES(null);
438 INSERT INTO t1 VALUES(null);
439 --sorted_result
440 SELECT * FROM t1;
441 TRUNCATE TABLE t1;
442 INSERT INTO t1 VALUES(null);
443 --sorted_result
444 SELECT * FROM t1;
445 ALTER TABLE t1 AUTO_INCREMENT=10;
446 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
447 SHOW CREATE TABLE t1;
448 INSERT INTO t1 VALUES(null);
449 INSERT INTO t1 VALUES(null);
450 INSERT INTO t1 VALUES(null);
451 --sorted_result
452 SELECT * FROM t1;
453 TRUNCATE TABLE t1;
454 INSERT INTO t1 VALUES(null);
455 --sorted_result
456 SELECT * FROM t1;
457 DROP TABLE t1;
458 CREATE TABLE t1(c1 TINYINT 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 --sorted_result
465 SELECT * FROM t1;
466 TRUNCATE TABLE t1;
467 INSERT INTO t1 VALUES(null);
468 --sorted_result
469 SELECT * FROM t1;
470 ALTER TABLE t1 AUTO_INCREMENT=10;
471 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
472 SHOW CREATE TABLE t1;
473 INSERT INTO t1 VALUES(null);
474 INSERT INTO t1 VALUES(null);
475 INSERT INTO t1 VALUES(null);
476 --sorted_result
477 SELECT * FROM t1;
478 TRUNCATE TABLE t1;
479 INSERT INTO t1 VALUES(null);
480 --sorted_result
481 SELECT * FROM t1;
482 DROP TABLE t1;
483 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
485 SHOW CREATE TABLE t1;
486 INSERT INTO t1 VALUES(null);
487 INSERT INTO t1 VALUES(null);
488 INSERT INTO t1 VALUES(null);
489 --sorted_result
490 SELECT * FROM t1;
491 TRUNCATE TABLE t1;
492 INSERT INTO t1 VALUES(null);
493 --sorted_result
494 SELECT * FROM t1;
495 ALTER TABLE t1 AUTO_INCREMENT=10;
496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
497 SHOW CREATE TABLE t1;
498 INSERT INTO t1 VALUES(null);
499 INSERT INTO t1 VALUES(null);
500 INSERT INTO t1 VALUES(null);
501 --sorted_result
502 SELECT * FROM t1;
503 TRUNCATE TABLE t1;
504 INSERT INTO t1 VALUES(null);
505 --sorted_result
506 SELECT * FROM t1;
507 DROP TABLE t1;
508 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
509 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
510 SHOW CREATE TABLE t1;
511 INSERT INTO t1 VALUES(null);
512 INSERT INTO t1 VALUES(null);
513 INSERT INTO t1 VALUES(null);
514 --sorted_result
515 SELECT * FROM t1;
516 TRUNCATE TABLE t1;
517 INSERT INTO t1 VALUES(null);
518 --sorted_result
519 SELECT * FROM t1;
520 ALTER TABLE t1 AUTO_INCREMENT=10;
521 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
522 SHOW CREATE TABLE t1;
523 INSERT INTO t1 VALUES(null);
524 INSERT INTO t1 VALUES(null);
525 INSERT INTO t1 VALUES(null);
526 --sorted_result
527 SELECT * FROM t1;
528 TRUNCATE TABLE t1;
529 INSERT INTO t1 VALUES(null);
530 --sorted_result
531 SELECT * FROM t1;
532 DROP TABLE t1;
533 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
534 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
535 SHOW CREATE TABLE t1;
536 INSERT INTO t1 VALUES(null);
537 INSERT INTO t1 VALUES(null);
538 INSERT INTO t1 VALUES(null);
539 --sorted_result
540 SELECT * FROM t1;
541 TRUNCATE TABLE t1;
542 INSERT INTO t1 VALUES(null);
543 --sorted_result
544 SELECT * FROM t1;
545 ALTER TABLE t1 AUTO_INCREMENT=10;
546 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
547 SHOW CREATE TABLE t1;
548 INSERT INTO t1 VALUES(null);
549 INSERT INTO t1 VALUES(null);
550 INSERT INTO t1 VALUES(null);
551 --sorted_result
552 SELECT * FROM t1;
553 TRUNCATE TABLE t1;
554 INSERT INTO t1 VALUES(null);
555 --sorted_result
556 SELECT * FROM t1;
557 DROP TABLE t1;
558 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
559 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
560 SHOW CREATE TABLE t1;
561 INSERT INTO t1 VALUES(null);
562 INSERT INTO t1 VALUES(null);
563 INSERT INTO t1 VALUES(null);
564 --sorted_result
565 SELECT * FROM t1;
566 TRUNCATE TABLE t1;
567 INSERT INTO t1 VALUES(null);
568 --sorted_result
569 SELECT * FROM t1;
570 ALTER TABLE t1 AUTO_INCREMENT=10;
571 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
572 SHOW CREATE TABLE t1;
573 INSERT INTO t1 VALUES(null);
574 INSERT INTO t1 VALUES(null);
575 INSERT INTO t1 VALUES(null);
576 --sorted_result
577 SELECT * FROM t1;
578 TRUNCATE TABLE t1;
579 INSERT INTO t1 VALUES(null);
580 --sorted_result
581 SELECT * FROM t1;
582 DROP TABLE t1;
583 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
584 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
585 SHOW CREATE TABLE t1;
586 INSERT INTO t1 VALUES(null);
587 INSERT INTO t1 VALUES(null);
588 INSERT INTO t1 VALUES(null);
589 --sorted_result
590 SELECT * FROM t1;
591 TRUNCATE TABLE t1;
592 INSERT INTO t1 VALUES(null);
593 --sorted_result
594 SELECT * FROM t1;
595 ALTER TABLE t1 AUTO_INCREMENT=10;
596 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
597 SHOW CREATE TABLE t1;
598 INSERT INTO t1 VALUES(null);
599 INSERT INTO t1 VALUES(null);
600 INSERT INTO t1 VALUES(null);
601 --sorted_result
602 SELECT * FROM t1;
603 TRUNCATE TABLE t1;
604 INSERT INTO t1 VALUES(null);
605 --sorted_result
606 SELECT * FROM t1;
607 DROP TABLE t1;
608 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
609 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
610 SHOW CREATE TABLE t1;
611 INSERT INTO t1 VALUES(null);
612 INSERT INTO t1 VALUES(null);
613 INSERT INTO t1 VALUES(null);
614 --sorted_result
615 SELECT * FROM t1;
616 TRUNCATE TABLE t1;
617 INSERT INTO t1 VALUES(null);
618 --sorted_result
619 SELECT * FROM t1;
620 ALTER TABLE t1 AUTO_INCREMENT=10;
621 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
622 SHOW CREATE TABLE t1;
623 INSERT INTO t1 VALUES(null);
624 INSERT INTO t1 VALUES(null);
625 INSERT INTO t1 VALUES(null);
626 --sorted_result
627 SELECT * FROM t1;
628 TRUNCATE TABLE t1;
629 INSERT INTO t1 VALUES(null);
630 --sorted_result
631 SELECT * FROM t1;
632 DROP TABLE t1;
633 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
634 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
635 SHOW CREATE TABLE t1;
636 INSERT INTO t1 VALUES(null);
637 INSERT INTO t1 VALUES(null);
638 INSERT INTO t1 VALUES(null);
639 --sorted_result
640 SELECT * FROM t1;
641 TRUNCATE TABLE t1;
642 INSERT INTO t1 VALUES(null);
643 --sorted_result
644 SELECT * FROM t1;
645 ALTER TABLE t1 AUTO_INCREMENT=10;
646 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
647 SHOW CREATE TABLE t1;
648 INSERT INTO t1 VALUES(null);
649 INSERT INTO t1 VALUES(null);
650 INSERT INTO t1 VALUES(null);
651 --sorted_result
652 SELECT * FROM t1;
653 TRUNCATE TABLE t1;
654 INSERT INTO t1 VALUES(null);
655 --sorted_result
656 SELECT * FROM t1;
657 DROP TABLE t1;
658 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
659 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
660 SHOW CREATE TABLE t1;
661 INSERT INTO t1 VALUES(null);
662 INSERT INTO t1 VALUES(null);
663 INSERT INTO t1 VALUES(null);
664 --sorted_result
665 SELECT * FROM t1;
666 TRUNCATE TABLE t1;
667 INSERT INTO t1 VALUES(null);
668 --sorted_result
669 SELECT * FROM t1;
670 ALTER TABLE t1 AUTO_INCREMENT=10;
671 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
672 SHOW CREATE TABLE t1;
673 INSERT INTO t1 VALUES(null);
674 INSERT INTO t1 VALUES(null);
675 INSERT INTO t1 VALUES(null);
676 --sorted_result
677 SELECT * FROM t1;
678 TRUNCATE TABLE t1;
679 INSERT INTO t1 VALUES(null);
680 --sorted_result
681 SELECT * FROM t1;
682 DROP TABLE t1;
683 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
684 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
685 SHOW CREATE TABLE t1;
686 INSERT INTO t1 VALUES(null);
687 INSERT INTO t1 VALUES(null);
688 INSERT INTO t1 VALUES(null);
689 --sorted_result
690 SELECT * FROM t1;
691 TRUNCATE TABLE t1;
692 INSERT INTO t1 VALUES(null);
693 --sorted_result
694 SELECT * FROM t1;
695 ALTER TABLE t1 AUTO_INCREMENT=10;
696 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
697 SHOW CREATE TABLE t1;
698 INSERT INTO t1 VALUES(null);
699 INSERT INTO t1 VALUES(null);
700 INSERT INTO t1 VALUES(null);
701 --sorted_result
702 SELECT * FROM t1;
703 TRUNCATE TABLE t1;
704 INSERT INTO t1 VALUES(null);
705 --sorted_result
706 SELECT * FROM t1;
707 DROP TABLE t1;
708 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
709 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
710 SHOW CREATE TABLE t1;
711 INSERT INTO t1 VALUES(null);
712 INSERT INTO t1 VALUES(null);
713 INSERT INTO t1 VALUES(null);
714 --sorted_result
715 SELECT * FROM t1;
716 TRUNCATE TABLE t1;
717 INSERT INTO t1 VALUES(null);
718 --sorted_result
719 SELECT * FROM t1;
720 ALTER TABLE t1 AUTO_INCREMENT=10;
721 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
722 SHOW CREATE TABLE t1;
723 INSERT INTO t1 VALUES(null);
724 INSERT INTO t1 VALUES(null);
725 INSERT INTO t1 VALUES(null);
726 --sorted_result
727 SELECT * FROM t1;
728 TRUNCATE TABLE t1;
729 INSERT INTO t1 VALUES(null);
730 --sorted_result
731 SELECT * FROM t1;
732 DROP TABLE t1;
733 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
734 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
735 SHOW CREATE TABLE t1;
736 INSERT INTO t1 VALUES(null);
737 INSERT INTO t1 VALUES(null);
738 INSERT INTO t1 VALUES(null);
739 --sorted_result
740 SELECT * FROM t1;
741 TRUNCATE TABLE t1;
742 INSERT INTO t1 VALUES(null);
743 --sorted_result
744 SELECT * FROM t1;
745 ALTER TABLE t1 AUTO_INCREMENT=10;
746 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
747 SHOW CREATE TABLE t1;
748 INSERT INTO t1 VALUES(null);
749 INSERT INTO t1 VALUES(null);
750 INSERT INTO t1 VALUES(null);
751 --sorted_result
752 SELECT * FROM t1;
753 TRUNCATE TABLE t1;
754 INSERT INTO t1 VALUES(null);
755 --sorted_result
756 SELECT * FROM t1;
757 DROP TABLE t1;
758 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
759 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
760 SHOW CREATE TABLE t1;
761 INSERT INTO t1 VALUES(null);
762 INSERT INTO t1 VALUES(null);
763 INSERT INTO t1 VALUES(null);
764 --sorted_result
765 SELECT * FROM t1;
766 TRUNCATE TABLE t1;
767 INSERT INTO t1 VALUES(null);
768 --sorted_result
769 SELECT * FROM t1;
770 ALTER TABLE t1 AUTO_INCREMENT=10;
771 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
772 SHOW CREATE TABLE t1;
773 INSERT INTO t1 VALUES(null);
774 INSERT INTO t1 VALUES(null);
775 INSERT INTO t1 VALUES(null);
776 --sorted_result
777 SELECT * FROM t1;
778 TRUNCATE TABLE t1;
779 INSERT INTO t1 VALUES(null);
780 --sorted_result
781 SELECT * FROM t1;
782 DROP TABLE t1;
783 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
784 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
785 SHOW CREATE TABLE t1;
786 INSERT INTO t1 VALUES(null);
787 INSERT INTO t1 VALUES(null);
788 INSERT INTO t1 VALUES(null);
789 --sorted_result
790 SELECT * FROM t1;
791 TRUNCATE TABLE t1;
792 INSERT INTO t1 VALUES(null);
793 --sorted_result
794 SELECT * FROM t1;
795 ALTER TABLE t1 AUTO_INCREMENT=10;
796 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
797 SHOW CREATE TABLE t1;
798 INSERT INTO t1 VALUES(null);
799 INSERT INTO t1 VALUES(null);
800 INSERT INTO t1 VALUES(null);
801 --sorted_result
802 SELECT * FROM t1;
803 TRUNCATE TABLE t1;
804 INSERT INTO t1 VALUES(null);
805 --sorted_result
806 SELECT * FROM t1;
807 DROP TABLE t1;
808 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
809 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
810 SHOW CREATE TABLE t1;
811 INSERT INTO t1 VALUES(null);
812 INSERT INTO t1 VALUES(null);
813 INSERT INTO t1 VALUES(null);
814 --sorted_result
815 SELECT * FROM t1;
816 TRUNCATE TABLE t1;
817 INSERT INTO t1 VALUES(null);
818 --sorted_result
819 SELECT * FROM t1;
820 ALTER TABLE t1 AUTO_INCREMENT=10;
821 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
822 SHOW CREATE TABLE t1;
823 INSERT INTO t1 VALUES(null);
824 INSERT INTO t1 VALUES(null);
825 INSERT INTO t1 VALUES(null);
826 --sorted_result
827 SELECT * FROM t1;
828 TRUNCATE TABLE t1;
829 INSERT INTO t1 VALUES(null);
830 --sorted_result
831 SELECT * FROM t1;
832 DROP TABLE t1;
833 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
834 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
835 SHOW CREATE TABLE t1;
836 INSERT INTO t1 VALUES(null);
837 INSERT INTO t1 VALUES(null);
838 INSERT INTO t1 VALUES(null);
839 --sorted_result
840 SELECT * FROM t1;
841 TRUNCATE TABLE t1;
842 INSERT INTO t1 VALUES(null);
843 --sorted_result
844 SELECT * FROM t1;
845 ALTER TABLE t1 AUTO_INCREMENT=10;
846 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
847 SHOW CREATE TABLE t1;
848 INSERT INTO t1 VALUES(null);
849 INSERT INTO t1 VALUES(null);
850 INSERT INTO t1 VALUES(null);
851 --sorted_result
852 SELECT * FROM t1;
853 TRUNCATE TABLE t1;
854 INSERT INTO t1 VALUES(null);
855 --sorted_result
856 SELECT * FROM t1;
857 DROP TABLE t1;
858 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
859 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
860 SHOW CREATE TABLE t1;
861 INSERT INTO t1 VALUES(null);
862 INSERT INTO t1 VALUES(null);
863 INSERT INTO t1 VALUES(null);
864 --sorted_result
865 SELECT * FROM t1;
866 TRUNCATE TABLE t1;
867 INSERT INTO t1 VALUES(null);
868 --sorted_result
869 SELECT * FROM t1;
870 ALTER TABLE t1 AUTO_INCREMENT=10;
871 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
872 SHOW CREATE TABLE t1;
873 INSERT INTO t1 VALUES(null);
874 INSERT INTO t1 VALUES(null);
875 INSERT INTO t1 VALUES(null);
876 --sorted_result
877 SELECT * FROM t1;
878 TRUNCATE TABLE t1;
879 INSERT INTO t1 VALUES(null);
880 --sorted_result
881 SELECT * FROM t1;
882 DROP TABLE t1;
883 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
884 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
885 SHOW CREATE TABLE t1;
886 INSERT INTO t1 VALUES(null);
887 INSERT INTO t1 VALUES(null);
888 INSERT INTO t1 VALUES(null);
889 --sorted_result
890 SELECT * FROM t1;
891 TRUNCATE TABLE t1;
892 INSERT INTO t1 VALUES(null);
893 --sorted_result
894 SELECT * FROM t1;
895 ALTER TABLE t1 AUTO_INCREMENT=10;
896 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
897 SHOW CREATE TABLE t1;
898 INSERT INTO t1 VALUES(null);
899 INSERT INTO t1 VALUES(null);
900 INSERT INTO t1 VALUES(null);
901 --sorted_result
902 SELECT * FROM t1;
903 TRUNCATE TABLE t1;
904 INSERT INTO t1 VALUES(null);
905 --sorted_result
906 SELECT * FROM t1;
907 DROP TABLE t1;
908 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
909 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
910 SHOW CREATE TABLE t1;
911 INSERT INTO t1 VALUES(null);
912 INSERT INTO t1 VALUES(null);
913 INSERT INTO t1 VALUES(null);
914 --sorted_result
915 SELECT * FROM t1;
916 TRUNCATE TABLE t1;
917 INSERT INTO t1 VALUES(null);
918 --sorted_result
919 SELECT * FROM t1;
920 ALTER TABLE t1 AUTO_INCREMENT=10;
921 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
922 SHOW CREATE TABLE t1;
923 INSERT INTO t1 VALUES(null);
924 INSERT INTO t1 VALUES(null);
925 INSERT INTO t1 VALUES(null);
926 --sorted_result
927 SELECT * FROM t1;
928 TRUNCATE TABLE t1;
929 INSERT INTO t1 VALUES(null);
930 --sorted_result
931 SELECT * FROM t1;
932 DROP TABLE t1;
933 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
934 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
935 SHOW CREATE TABLE t1;
936 INSERT INTO t1 VALUES(null);
937 INSERT INTO t1 VALUES(null);
938 INSERT INTO t1 VALUES(null);
939 --sorted_result
940 SELECT * FROM t1;
941 TRUNCATE TABLE t1;
942 INSERT INTO t1 VALUES(null);
943 --sorted_result
944 SELECT * FROM t1;
945 ALTER TABLE t1 AUTO_INCREMENT=10;
946 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
947 SHOW CREATE TABLE t1;
948 INSERT INTO t1 VALUES(null);
949 INSERT INTO t1 VALUES(null);
950 INSERT INTO t1 VALUES(null);
951 --sorted_result
952 SELECT * FROM t1;
953 TRUNCATE TABLE t1;
954 INSERT INTO t1 VALUES(null);
955 --sorted_result
956 SELECT * FROM t1;
957 DROP TABLE t1;
958 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
959 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
960 SHOW CREATE TABLE t1;
961 INSERT INTO t1 VALUES(null);
962 INSERT INTO t1 VALUES(null);
963 INSERT INTO t1 VALUES(null);
964 --sorted_result
965 SELECT * FROM t1;
966 TRUNCATE TABLE t1;
967 INSERT INTO t1 VALUES(null);
968 --sorted_result
969 SELECT * FROM t1;
970 ALTER TABLE t1 AUTO_INCREMENT=10;
971 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
972 SHOW CREATE TABLE t1;
973 INSERT INTO t1 VALUES(null);
974 INSERT INTO t1 VALUES(null);
975 INSERT INTO t1 VALUES(null);
976 --sorted_result
977 SELECT * FROM t1;
978 TRUNCATE TABLE t1;
979 INSERT INTO t1 VALUES(null);
980 --sorted_result
981 SELECT * FROM t1;
982 DROP TABLE t1;
983 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
984 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
985 SHOW CREATE TABLE t1;
986 INSERT INTO t1 VALUES(null);
987 INSERT INTO t1 VALUES(null);
988 INSERT INTO t1 VALUES(null);
989 --sorted_result
990 SELECT * FROM t1;
991 TRUNCATE TABLE t1;
992 INSERT INTO t1 VALUES(null);
993 --sorted_result
994 SELECT * FROM t1;
995 ALTER TABLE t1 AUTO_INCREMENT=10;
996 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
997 SHOW CREATE TABLE t1;
998 INSERT INTO t1 VALUES(null);
999 INSERT INTO t1 VALUES(null);
1000 INSERT INTO t1 VALUES(null);
1001 --sorted_result
1002 SELECT * FROM t1;
1003 TRUNCATE TABLE t1;
1004 INSERT INTO t1 VALUES(null);
1005 --sorted_result
1006 SELECT * FROM t1;
1007 DROP TABLE t1;
1008 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1009 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1010 SHOW CREATE TABLE t1;
1011 INSERT INTO t1 VALUES(null);
1012 INSERT INTO t1 VALUES(null);
1013 INSERT INTO t1 VALUES(null);
1014 --sorted_result
1015 SELECT * FROM t1;
1016 TRUNCATE TABLE t1;
1017 INSERT INTO t1 VALUES(null);
1018 --sorted_result
1019 SELECT * FROM t1;
1020 ALTER TABLE t1 AUTO_INCREMENT=10;
1021 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1022 SHOW CREATE TABLE t1;
1023 INSERT INTO t1 VALUES(null);
1024 INSERT INTO t1 VALUES(null);
1025 INSERT INTO t1 VALUES(null);
1026 --sorted_result
1027 SELECT * FROM t1;
1028 TRUNCATE TABLE t1;
1029 INSERT INTO t1 VALUES(null);
1030 --sorted_result
1031 SELECT * FROM t1;
1032 DROP TABLE t1;
1033 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
1034 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1035 SHOW CREATE TABLE t1;
1036 INSERT INTO t1 VALUES(null);
1037 INSERT INTO t1 VALUES(null);
1038 INSERT INTO t1 VALUES(null);
1039 --sorted_result
1040 SELECT * FROM t1;
1041 TRUNCATE TABLE t1;
1042 INSERT INTO t1 VALUES(null);
1043 --sorted_result
1044 SELECT * FROM t1;
1045 ALTER TABLE t1 AUTO_INCREMENT=10;
1046 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1047 SHOW CREATE TABLE t1;
1048 INSERT INTO t1 VALUES(null);
1049 INSERT INTO t1 VALUES(null);
1050 INSERT INTO t1 VALUES(null);
1051 --sorted_result
1052 SELECT * FROM t1;
1053 TRUNCATE TABLE t1;
1054 INSERT INTO t1 VALUES(null);
1055 --sorted_result
1056 SELECT * FROM t1;
1057 DROP TABLE t1;
1058 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1059 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1060 SHOW CREATE TABLE t1;
1061 INSERT INTO t1 VALUES(null);
1062 INSERT INTO t1 VALUES(null);
1063 INSERT INTO t1 VALUES(null);
1064 --sorted_result
1065 SELECT * FROM t1;
1066 TRUNCATE TABLE t1;
1067 INSERT INTO t1 VALUES(null);
1068 --sorted_result
1069 SELECT * FROM t1;
1070 ALTER TABLE t1 AUTO_INCREMENT=10;
1071 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1072 SHOW CREATE TABLE t1;
1073 INSERT INTO t1 VALUES(null);
1074 INSERT INTO t1 VALUES(null);
1075 INSERT INTO t1 VALUES(null);
1076 --sorted_result
1077 SELECT * FROM t1;
1078 TRUNCATE TABLE t1;
1079 INSERT INTO t1 VALUES(null);
1080 --sorted_result
1081 SELECT * FROM t1;
1082 DROP TABLE t1;
1083 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1084 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1085 SHOW CREATE TABLE t1;
1086 INSERT INTO t1 VALUES(null);
1087 INSERT INTO t1 VALUES(null);
1088 INSERT INTO t1 VALUES(null);
1089 --sorted_result
1090 SELECT * FROM t1;
1091 TRUNCATE TABLE t1;
1092 INSERT INTO t1 VALUES(null);
1093 --sorted_result
1094 SELECT * FROM t1;
1095 ALTER TABLE t1 AUTO_INCREMENT=10;
1096 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1097 SHOW CREATE TABLE t1;
1098 INSERT INTO t1 VALUES(null);
1099 INSERT INTO t1 VALUES(null);
1100 INSERT INTO t1 VALUES(null);
1101 --sorted_result
1102 SELECT * FROM t1;
1103 TRUNCATE TABLE t1;
1104 INSERT INTO t1 VALUES(null);
1105 --sorted_result
1106 SELECT * FROM t1;
1107 DROP TABLE t1;
1108 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1109 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1110 SHOW CREATE TABLE t1;
1111 INSERT INTO t1 VALUES(null);
1112 INSERT INTO t1 VALUES(null);
1113 INSERT INTO t1 VALUES(null);
1114 --sorted_result
1115 SELECT * FROM t1;
1116 TRUNCATE TABLE t1;
1117 INSERT INTO t1 VALUES(null);
1118 --sorted_result
1119 SELECT * FROM t1;
1120 ALTER TABLE t1 AUTO_INCREMENT=10;
1121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1122 SHOW CREATE TABLE t1;
1123 INSERT INTO t1 VALUES(null);
1124 INSERT INTO t1 VALUES(null);
1125 INSERT INTO t1 VALUES(null);
1126 --sorted_result
1127 SELECT * FROM t1;
1128 TRUNCATE TABLE t1;
1129 INSERT INTO t1 VALUES(null);
1130 --sorted_result
1131 SELECT * FROM t1;
1132 DROP TABLE t1;
1133 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1135 SHOW CREATE TABLE t1;
1136 INSERT INTO t1 VALUES(null);
1137 INSERT INTO t1 VALUES(null);
1138 INSERT INTO t1 VALUES(null);
1139 --sorted_result
1140 SELECT * FROM t1;
1141 TRUNCATE TABLE t1;
1142 INSERT INTO t1 VALUES(null);
1143 --sorted_result
1144 SELECT * FROM t1;
1145 ALTER TABLE t1 AUTO_INCREMENT=10;
1146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1147 SHOW CREATE TABLE t1;
1148 INSERT INTO t1 VALUES(null);
1149 INSERT INTO t1 VALUES(null);
1150 INSERT INTO t1 VALUES(null);
1151 --sorted_result
1152 SELECT * FROM t1;
1153 TRUNCATE TABLE t1;
1154 INSERT INTO t1 VALUES(null);
1155 --sorted_result
1156 SELECT * FROM t1;
1157 DROP TABLE t1;
1158 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1159 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1160 SHOW CREATE TABLE t1;
1161 INSERT INTO t1 VALUES(null);
1162 INSERT INTO t1 VALUES(null);
1163 INSERT INTO t1 VALUES(null);
1164 --sorted_result
1165 SELECT * FROM t1;
1166 TRUNCATE TABLE t1;
1167 INSERT INTO t1 VALUES(null);
1168 --sorted_result
1169 SELECT * FROM t1;
1170 ALTER TABLE t1 AUTO_INCREMENT=10;
1171 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1172 SHOW CREATE TABLE t1;
1173 INSERT INTO t1 VALUES(null);
1174 INSERT INTO t1 VALUES(null);
1175 INSERT INTO t1 VALUES(null);
1176 --sorted_result
1177 SELECT * FROM t1;
1178 TRUNCATE TABLE t1;
1179 INSERT INTO t1 VALUES(null);
1180 --sorted_result
1181 SELECT * FROM t1;
1182 DROP TABLE t1;
1183 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1184 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1185 SHOW CREATE TABLE t1;
1186 INSERT INTO t1 VALUES(null);
1187 INSERT INTO t1 VALUES(null);
1188 INSERT INTO t1 VALUES(null);
1189 --sorted_result
1190 SELECT * FROM t1;
1191 TRUNCATE TABLE t1;
1192 INSERT INTO t1 VALUES(null);
1193 --sorted_result
1194 SELECT * FROM t1;
1195 ALTER TABLE t1 AUTO_INCREMENT=10;
1196 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1197 SHOW CREATE TABLE t1;
1198 INSERT INTO t1 VALUES(null);
1199 INSERT INTO t1 VALUES(null);
1200 INSERT INTO t1 VALUES(null);
1201 --sorted_result
1202 SELECT * FROM t1;
1203 TRUNCATE TABLE t1;
1204 INSERT INTO t1 VALUES(null);
1205 --sorted_result
1206 SELECT * FROM t1;
1207 DROP TABLE t1;
1208 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1210 SHOW CREATE TABLE t1;
1211 INSERT INTO t1 VALUES(null);
1212 INSERT INTO t1 VALUES(null);
1213 INSERT INTO t1 VALUES(null);
1214 --sorted_result
1215 SELECT * FROM t1;
1216 TRUNCATE TABLE t1;
1217 INSERT INTO t1 VALUES(null);
1218 --sorted_result
1219 SELECT * FROM t1;
1220 ALTER TABLE t1 AUTO_INCREMENT=10;
1221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1222 SHOW CREATE TABLE t1;
1223 INSERT INTO t1 VALUES(null);
1224 INSERT INTO t1 VALUES(null);
1225 INSERT INTO t1 VALUES(null);
1226 --sorted_result
1227 SELECT * FROM t1;
1228 TRUNCATE TABLE t1;
1229 INSERT INTO t1 VALUES(null);
1230 --sorted_result
1231 SELECT * FROM t1;
1232 DROP TABLE t1;
1233 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1234 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1235 SHOW CREATE TABLE t1;
1236 INSERT INTO t1 VALUES(null);
1237 INSERT INTO t1 VALUES(null);
1238 INSERT INTO t1 VALUES(null);
1239 --sorted_result
1240 SELECT * FROM t1;
1241 TRUNCATE TABLE t1;
1242 INSERT INTO t1 VALUES(null);
1243 --sorted_result
1244 SELECT * FROM t1;
1245 ALTER TABLE t1 AUTO_INCREMENT=10;
1246 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1247 SHOW CREATE TABLE t1;
1248 INSERT INTO t1 VALUES(null);
1249 INSERT INTO t1 VALUES(null);
1250 INSERT INTO t1 VALUES(null);
1251 --sorted_result
1252 SELECT * FROM t1;
1253 TRUNCATE TABLE t1;
1254 INSERT INTO t1 VALUES(null);
1255 --sorted_result
1256 SELECT * FROM t1;
1257 DROP TABLE t1;
1258 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1259 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1260 SHOW CREATE TABLE t1;
1261 INSERT INTO t1 VALUES(null);
1262 INSERT INTO t1 VALUES(null);
1263 INSERT INTO t1 VALUES(null);
1264 --sorted_result
1265 SELECT * FROM t1;
1266 TRUNCATE TABLE t1;
1267 INSERT INTO t1 VALUES(null);
1268 --sorted_result
1269 SELECT * FROM t1;
1270 ALTER TABLE t1 AUTO_INCREMENT=10;
1271 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1272 SHOW CREATE TABLE t1;
1273 INSERT INTO t1 VALUES(null);
1274 INSERT INTO t1 VALUES(null);
1275 INSERT INTO t1 VALUES(null);
1276 --sorted_result
1277 SELECT * FROM t1;
1278 TRUNCATE TABLE t1;
1279 INSERT INTO t1 VALUES(null);
1280 --sorted_result
1281 SELECT * FROM t1;
1282 DROP TABLE t1;
1283 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1284 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1285 SHOW CREATE TABLE t1;
1286 INSERT INTO t1 VALUES(null);
1287 INSERT INTO t1 VALUES(null);
1288 INSERT INTO t1 VALUES(null);
1289 --sorted_result
1290 SELECT * FROM t1;
1291 TRUNCATE TABLE t1;
1292 INSERT INTO t1 VALUES(null);
1293 --sorted_result
1294 SELECT * FROM t1;
1295 ALTER TABLE t1 AUTO_INCREMENT=10;
1296 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1297 SHOW CREATE TABLE t1;
1298 INSERT INTO t1 VALUES(null);
1299 INSERT INTO t1 VALUES(null);
1300 INSERT INTO t1 VALUES(null);
1301 --sorted_result
1302 SELECT * FROM t1;
1303 TRUNCATE TABLE t1;
1304 INSERT INTO t1 VALUES(null);
1305 --sorted_result
1306 SELECT * FROM t1;
1307 DROP TABLE t1;
1308 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1309 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1310 SHOW CREATE TABLE t1;
1311 INSERT INTO t1 VALUES(null);
1312 INSERT INTO t1 VALUES(null);
1313 INSERT INTO t1 VALUES(null);
1314 --sorted_result
1315 SELECT * FROM t1;
1316 TRUNCATE TABLE t1;
1317 INSERT INTO t1 VALUES(null);
1318 --sorted_result
1319 SELECT * FROM t1;
1320 ALTER TABLE t1 AUTO_INCREMENT=10;
1321 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1322 SHOW CREATE TABLE t1;
1323 INSERT INTO t1 VALUES(null);
1324 INSERT INTO t1 VALUES(null);
1325 INSERT INTO t1 VALUES(null);
1326 --sorted_result
1327 SELECT * FROM t1;
1328 TRUNCATE TABLE t1;
1329 INSERT INTO t1 VALUES(null);
1330 --sorted_result
1331 SELECT * FROM t1;
1332 DROP TABLE t1;
1333 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
1334 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1335 SHOW CREATE TABLE t1;
1336 INSERT INTO t1 VALUES(null);
1337 INSERT INTO t1 VALUES(null);
1338 INSERT INTO t1 VALUES(null);
1339 --sorted_result
1340 SELECT * FROM t1;
1341 TRUNCATE TABLE t1;
1342 INSERT INTO t1 VALUES(null);
1343 --sorted_result
1344 SELECT * FROM t1;
1345 ALTER TABLE t1 AUTO_INCREMENT=10;
1346 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1347 SHOW CREATE TABLE t1;
1348 INSERT INTO t1 VALUES(null);
1349 INSERT INTO t1 VALUES(null);
1350 INSERT INTO t1 VALUES(null);
1351 --sorted_result
1352 SELECT * FROM t1;
1353 TRUNCATE TABLE t1;
1354 INSERT INTO t1 VALUES(null);
1355 --sorted_result
1356 SELECT * FROM t1;
1357 DROP TABLE t1;
1358 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1359 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1360 SHOW CREATE TABLE t1;
1361 INSERT INTO t1 VALUES(null);
1362 INSERT INTO t1 VALUES(null);
1363 INSERT INTO t1 VALUES(null);
1364 --sorted_result
1365 SELECT * FROM t1;
1366 TRUNCATE TABLE t1;
1367 INSERT INTO t1 VALUES(null);
1368 --sorted_result
1369 SELECT * FROM t1;
1370 ALTER TABLE t1 AUTO_INCREMENT=10;
1371 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1372 SHOW CREATE TABLE t1;
1373 INSERT INTO t1 VALUES(null);
1374 INSERT INTO t1 VALUES(null);
1375 INSERT INTO t1 VALUES(null);
1376 --sorted_result
1377 SELECT * FROM t1;
1378 TRUNCATE TABLE t1;
1379 INSERT INTO t1 VALUES(null);
1380 --sorted_result
1381 SELECT * FROM t1;
1382 DROP TABLE t1;
1383 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1384 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1385 SHOW CREATE TABLE t1;
1386 INSERT INTO t1 VALUES(null);
1387 INSERT INTO t1 VALUES(null);
1388 INSERT INTO t1 VALUES(null);
1389 --sorted_result
1390 SELECT * FROM t1;
1391 TRUNCATE TABLE t1;
1392 INSERT INTO t1 VALUES(null);
1393 --sorted_result
1394 SELECT * FROM t1;
1395 ALTER TABLE t1 AUTO_INCREMENT=10;
1396 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1397 SHOW CREATE TABLE t1;
1398 INSERT INTO t1 VALUES(null);
1399 INSERT INTO t1 VALUES(null);
1400 INSERT INTO t1 VALUES(null);
1401 --sorted_result
1402 SELECT * FROM t1;
1403 TRUNCATE TABLE t1;
1404 INSERT INTO t1 VALUES(null);
1405 --sorted_result
1406 SELECT * FROM t1;
1407 DROP TABLE t1;
1408 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1409 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1410 SHOW CREATE TABLE t1;
1411 INSERT INTO t1 VALUES(null);
1412 INSERT INTO t1 VALUES(null);
1413 INSERT INTO t1 VALUES(null);
1414 --sorted_result
1415 SELECT * FROM t1;
1416 TRUNCATE TABLE t1;
1417 INSERT INTO t1 VALUES(null);
1418 --sorted_result
1419 SELECT * FROM t1;
1420 ALTER TABLE t1 AUTO_INCREMENT=10;
1421 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1422 SHOW CREATE TABLE t1;
1423 INSERT INTO t1 VALUES(null);
1424 INSERT INTO t1 VALUES(null);
1425 INSERT INTO t1 VALUES(null);
1426 --sorted_result
1427 SELECT * FROM t1;
1428 TRUNCATE TABLE t1;
1429 INSERT INTO t1 VALUES(null);
1430 --sorted_result
1431 SELECT * FROM t1;
1432 DROP TABLE t1;
1433 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1434 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1435 SHOW CREATE TABLE t1;
1436 INSERT INTO t1 VALUES(null);
1437 INSERT INTO t1 VALUES(null);
1438 INSERT INTO t1 VALUES(null);
1439 --sorted_result
1440 SELECT * FROM t1;
1441 TRUNCATE TABLE t1;
1442 INSERT INTO t1 VALUES(null);
1443 --sorted_result
1444 SELECT * FROM t1;
1445 ALTER TABLE t1 AUTO_INCREMENT=10;
1446 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1447 SHOW CREATE TABLE t1;
1448 INSERT INTO t1 VALUES(null);
1449 INSERT INTO t1 VALUES(null);
1450 INSERT INTO t1 VALUES(null);
1451 --sorted_result
1452 SELECT * FROM t1;
1453 TRUNCATE TABLE t1;
1454 INSERT INTO t1 VALUES(null);
1455 --sorted_result
1456 SELECT * FROM t1;
1457 DROP TABLE t1;
1458 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1459 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1460 SHOW CREATE TABLE t1;
1461 INSERT INTO t1 VALUES(null);
1462 INSERT INTO t1 VALUES(null);
1463 INSERT INTO t1 VALUES(null);
1464 --sorted_result
1465 SELECT * FROM t1;
1466 TRUNCATE TABLE t1;
1467 INSERT INTO t1 VALUES(null);
1468 --sorted_result
1469 SELECT * FROM t1;
1470 ALTER TABLE t1 AUTO_INCREMENT=10;
1471 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1472 SHOW CREATE TABLE t1;
1473 INSERT INTO t1 VALUES(null);
1474 INSERT INTO t1 VALUES(null);
1475 INSERT INTO t1 VALUES(null);
1476 --sorted_result
1477 SELECT * FROM t1;
1478 TRUNCATE TABLE t1;
1479 INSERT INTO t1 VALUES(null);
1480 --sorted_result
1481 SELECT * FROM t1;
1482 DROP TABLE t1;
1483 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
1484 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1485 SHOW CREATE TABLE t1;
1486 INSERT INTO t1 VALUES(null);
1487 INSERT INTO t1 VALUES(null);
1488 INSERT INTO t1 VALUES(null);
1489 --sorted_result
1490 SELECT * FROM t1;
1491 TRUNCATE TABLE t1;
1492 INSERT INTO t1 VALUES(null);
1493 --sorted_result
1494 SELECT * FROM t1;
1495 ALTER TABLE t1 AUTO_INCREMENT=10;
1496 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1497 SHOW CREATE TABLE t1;
1498 INSERT INTO t1 VALUES(null);
1499 INSERT INTO t1 VALUES(null);
1500 INSERT INTO t1 VALUES(null);
1501 --sorted_result
1502 SELECT * FROM t1;
1503 TRUNCATE TABLE t1;
1504 INSERT INTO t1 VALUES(null);
1505 --sorted_result
1506 SELECT * FROM t1;
1507 DROP TABLE t1;