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);