1drop table if exists t1;
2SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
3CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
4INSERT INTO t1 VALUES (null);
5SHOW CREATE TABLE t1;
6Table	Create Table
7t1	CREATE TABLE `t1` (
8  `c1` int(11) NOT NULL AUTO_INCREMENT,
9  PRIMARY KEY (`c1`)
10) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
11DELETE FROM t1;
12OPTIMIZE TABLE t1;
13Table	Op	Msg_type	Msg_text
14test.t1	optimize	note	Table does not support optimize, doing recreate + analyze instead
15test.t1	optimize	status	OK
16SHOW CREATE TABLE t1;
17Table	Create Table
18t1	CREATE TABLE `t1` (
19  `c1` int(11) NOT NULL AUTO_INCREMENT,
20  PRIMARY KEY (`c1`)
21) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
22INSERT INTO t1 VALUES(null);
23SELECT * FROM t1;
24c1
252
26DROP TABLE t1;
27