Self-contained testcase from duplicate bug 1067346 (s/have_innodb_plugin/have_innodb for 5.5):
--source include/have_innodb_plugin.inc
--disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
SET innodb_fake_changes=1; SELECT * FROM t1; # failed: 1180: Got error 131 during COMMIT
SET innodb_fake_changes=0; DROP TABLE t1;
Self-contained testcase from duplicate bug 1067346 (s/have_ innodb_ plugin/ have_innodb for 5.5):
--source include/ have_innodb_ plugin. inc
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
SET innodb_ fake_changes= 1;
SELECT * FROM t1; # failed: 1180: Got error 131 during COMMIT
SET innodb_ fake_changes= 0;
DROP TABLE t1;