Reduced testcase
SET expand_fast_index_creation=1; CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY, INDEX c1(c1)) ENGINE=InnoDB; INSERT INTO t1 VALUES(3); OPTIMIZE TABLE t1; INSERT INTO t1 VALUES(2);
Reduced testcase
SET expand_ fast_index_ creation= 1;
CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY, INDEX c1(c1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES(3);
OPTIMIZE TABLE t1;
INSERT INTO t1 VALUES(2);