DROP DATABASE test;CREATE DATABASE test;USE test;
set global innodb_limit_optimistic_insert_debug=2;
CREATE TABLE t1(c1 INT,c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
INSERT INTO t1 VALUES(),(),(),(),(),(),(),(),(),(),(),(),(),(),();
SET innodb_fake_changes=1;
INSERT INTO t1(c1)VALUES(2);
Another testcase
DROP DATABASE test;CREATE DATABASE test;USE test; limit_optimisti c_insert_ debug=2; ),(),() ,(),(), (),(),( ),(),() ,(),(), (),(),( ); fake_changes= 1;
set global innodb_
CREATE TABLE t1(c1 INT,c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
INSERT INTO t1 VALUES(
SET innodb_
INSERT INTO t1(c1)VALUES(2);