1 SET GLOBAL tx_isolation='REPEATABLE-READ';
2 SET GLOBAL innodb_file_format=Barracuda;
3 SET GLOBAL innodb_file_per_table=on;
5 a INT AUTO_INCREMENT PRIMARY KEY,
10 INSERT INTO bug56680 VALUES(0,'x',1);
12 SELECT b FROM bug56680;
16 UPDATE bug56680 SET b='X';
17 SELECT b FROM bug56680;
20 SELECT * FROM bug56680;
24 SELECT b FROM bug56680;
27 SET GLOBAL tx_isolation='READ-UNCOMMITTED';
28 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
29 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
30 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
31 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
32 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
33 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
34 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
35 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
36 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
37 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
38 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
40 SELECT b FROM bug56680 LIMIT 2;
45 DELETE FROM bug56680 WHERE a=1;
46 INSERT INTO bug56680 VALUES(1,'X',1);
47 SELECT b FROM bug56680 LIMIT 3;
52 SELECT b FROM bug56680 LIMIT 2;
57 Table Op Msg_type Msg_text
58 test.bug56680 check status OK
60 SELECT b FROM bug56680 LIMIT 2;
65 Table Op Msg_type Msg_text
66 test.bug56680 check status OK
67 SELECT b FROM bug56680 LIMIT 2;
71 CREATE TABLE bug56680_2(
72 a INT AUTO_INCREMENT PRIMARY KEY,
73 b VARCHAR(2) CHARSET latin1 COLLATE latin1_german2_ci,
77 INSERT INTO bug56680_2 SELECT 0,_latin1 0xdf,c FROM bug56680;
79 SELECT HEX(b) FROM bug56680_2 LIMIT 2;
83 DELETE FROM bug56680_2 WHERE a=1;
84 INSERT INTO bug56680_2 VALUES(1,'SS',1);
85 SELECT HEX(b) FROM bug56680_2 LIMIT 3;
90 CHECK TABLE bug56680_2;
91 Table Op Msg_type Msg_text
92 test.bug56680_2 check status OK
93 ALTER TABLE bug56680_2 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
94 SELECT HEX(b) FROM bug56680_2 LIMIT 2;
98 DELETE FROM bug56680_2 WHERE a=1;
99 INSERT INTO bug56680_2 VALUES(1,_latin1 0xdf,1);
100 SELECT HEX(b) FROM bug56680_2 LIMIT 3;
105 CHECK TABLE bug56680_2;
106 Table Op Msg_type Msg_text
107 test.bug56680_2 check status OK
108 DROP TABLE bug56680_2;