1
SET GLOBAL tx_isolation='REPEATABLE-READ';
3
a INT AUTO_INCREMENT PRIMARY KEY,
8
INSERT INTO bug56680 VALUES(0,'x',1);
10
SELECT b FROM bug56680;
14
UPDATE bug56680 SET b='X';
15
SELECT b FROM bug56680;
18
SELECT * FROM bug56680;
22
SELECT b FROM bug56680;
25
SET GLOBAL tx_isolation='READ-UNCOMMITTED';
26
INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
27
INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
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;
38
SELECT b FROM bug56680 LIMIT 2;
43
DELETE FROM bug56680 WHERE a=1;
44
INSERT INTO bug56680 VALUES(1,'X',1);
45
SELECT b FROM bug56680 LIMIT 3;
50
SELECT b FROM bug56680 LIMIT 2;
55
Table Op Msg_type Msg_text
56
test.bug56680 check status OK
58
SELECT b FROM bug56680 LIMIT 2;
63
Table Op Msg_type Msg_text
64
test.bug56680 check status OK
65
SELECT b FROM bug56680 LIMIT 2;
69
CREATE TABLE bug56680_2(
70
a INT AUTO_INCREMENT PRIMARY KEY,
71
b VARCHAR(2) CHARSET latin1 COLLATE latin1_german2_ci,
75
INSERT INTO bug56680_2 SELECT 0,_latin1 0xdf,c FROM bug56680;
77
SELECT HEX(b) FROM bug56680_2 LIMIT 2;
81
DELETE FROM bug56680_2 WHERE a=1;
82
INSERT INTO bug56680_2 VALUES(1,'SS',1);
83
SELECT HEX(b) FROM bug56680_2 LIMIT 3;
88
CHECK TABLE bug56680_2;
89
Table Op Msg_type Msg_text
90
test.bug56680_2 check status OK
91
DELETE FROM bug56680_2 WHERE a=1;
92
INSERT INTO bug56680_2 VALUES(1,_latin1 0xdf,1);
93
SELECT HEX(b) FROM bug56680_2 LIMIT 3;
98
CHECK TABLE bug56680_2;
99
Table Op Msg_type Msg_text
100
test.bug56680_2 check status OK
101
DROP TABLE bug56680_2;