1 -- source include/have_innodb_plugin.inc
2 # embedded server ignores 'delayed', so skip this
3 -- source include/not_embedded.inc
6 drop table if exists t1;
10 # Bug #18274 InnoDB auto_increment field reset on OPTIMIZE TABLE
11 SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
12 CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (null);
18 INSERT INTO t1 VALUES(null);