SET GLOBAL tx_isolation='REPEATABLE-READ'; CREATE TABLE bug56680( a INT AUTO_INCREMENT PRIMARY KEY, b CHAR(1), c INT, INDEX(b)) ENGINE=InnoDB; INSERT INTO bug56680 VALUES(0,'x',1); BEGIN; SELECT b FROM bug56680; b x BEGIN; UPDATE bug56680 SET b='X'; SELECT b FROM bug56680; b x SELECT * FROM bug56680; a b c 1 x 1 ROLLBACK; SELECT b FROM bug56680; b x SET GLOBAL tx_isolation='READ-UNCOMMITTED'; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; INSERT INTO bug56680 SELECT 0,b,c FROM bug56680; BEGIN; SELECT b FROM bug56680 LIMIT 2; b x x BEGIN; DELETE FROM bug56680 WHERE a=1; INSERT INTO bug56680 VALUES(1,'X',1); SELECT b FROM bug56680 LIMIT 3; b X x x SELECT b FROM bug56680 LIMIT 2; b x x CHECK TABLE bug56680; Table Op Msg_type Msg_text test.bug56680 check status OK ROLLBACK; SELECT b FROM bug56680 LIMIT 2; b x x CHECK TABLE bug56680; Table Op Msg_type Msg_text test.bug56680 check status OK SELECT b FROM bug56680 LIMIT 2; b x x CREATE TABLE bug56680_2( a INT AUTO_INCREMENT PRIMARY KEY, b VARCHAR(2) CHARSET latin1 COLLATE latin1_german2_ci, c INT, INDEX(b)) ENGINE=InnoDB; INSERT INTO bug56680_2 SELECT 0,_latin1 0xdf,c FROM bug56680; BEGIN; SELECT HEX(b) FROM bug56680_2 LIMIT 2; HEX(b) DF DF DELETE FROM bug56680_2 WHERE a=1; INSERT INTO bug56680_2 VALUES(1,'SS',1); SELECT HEX(b) FROM bug56680_2 LIMIT 3; HEX(b) 5353 DF DF CHECK TABLE bug56680_2; Table Op Msg_type Msg_text test.bug56680_2 check status OK DELETE FROM bug56680_2 WHERE a=1; INSERT INTO bug56680_2 VALUES(1,_latin1 0xdf,1); SELECT HEX(b) FROM bug56680_2 LIMIT 3; HEX(b) DF DF DF CHECK TABLE bug56680_2; Table Op Msg_type Msg_text test.bug56680_2 check status OK DROP TABLE bug56680_2; DROP TABLE bug56680;