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;