mysql-test/suite/innodb/t/innodb-autoinc-optimize.test
raw| 1 | |
| 2 | --disable_warnings |
| 3 | drop table if exists t1; |
| 4 | --enable_warnings |
| 5 | |
| 6 | # |
| 7 | # Bug 34286 |
| 8 | # |
| 9 | create table t1(a int not null auto_increment primary key) engine=innodb; |
| 10 | insert into t1 set a = -1; |
| 11 | # NOTE: The database needs to be shutdown and restarted (here) for |
| 12 | # the test to work. It's included for reference only. |
| 13 | optimize table t1; |
| 14 | |
| 15 | --echo ==== clean up ==== |
| 16 | DROP TABLE t1; |