mysql-test/suite/innodb/r/innodb-autoinc-optimize.result
raw| 1 | drop table if exists t1; |
| 2 | create table t1(a int not null auto_increment primary key) engine=innodb; |
| 3 | insert into t1 set a = -1; |
| 4 | optimize table t1; |
| 5 | Table Op Msg_type Msg_text |
| 6 | test.t1 optimize note Table does not support optimize, doing recreate + analyze instead |
| 7 | test.t1 optimize status OK |
| 8 | ==== clean up ==== |
| 9 | DROP TABLE t1; |