Debian Codegraph @

mysql-test/suite/innodb_zip/r/bug56680.result

raw
1 SET GLOBAL transaction_isolation='REPEATABLE-READ';
2 CREATE TABLE bug56680(
3 a INT AUTO_INCREMENT PRIMARY KEY,
4 b CHAR(1),
5 c INT,
6 INDEX(b))
7 ENGINE=InnoDB STATS_PERSISTENT=0;
8 INSERT INTO bug56680 VALUES(0,'x',1);
9 BEGIN;
10 SELECT b FROM bug56680;
11 b
12 x
13 connect con1,localhost,root,,;
14 connection con1;
15 BEGIN;
16 UPDATE bug56680 SET b='X';
17 connection default;
18 SELECT b FROM bug56680;
19 b
20 x
21 SELECT * FROM bug56680;
22 a b c
23 1 x 1
24 connection con1;
25 ROLLBACK;
26 disconnect con1;
27 connection default;
28 SELECT b FROM bug56680;
29 b
30 x
31 SET GLOBAL transaction_isolation='READ-UNCOMMITTED';
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;
39 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
40 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
41 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
42 INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
43 BEGIN;
44 SELECT b FROM bug56680 LIMIT 2;
45 b
46 x
47 x
48 connect con1,localhost,root,,;
49 connection con1;
50 BEGIN;
51 DELETE FROM bug56680 WHERE a=1;
52 INSERT INTO bug56680 VALUES(1,'X',1);
53 SELECT b FROM bug56680 LIMIT 3;
54 b
55 X
56 x
57 x
58 connection default;
59 SELECT b FROM bug56680 LIMIT 2;
60 b
61 x
62 x
63 CHECK TABLE bug56680;
64 Table Op Msg_type Msg_text
65 test.bug56680 check status OK
66 connection con1;
67 ROLLBACK;
68 SELECT b FROM bug56680 LIMIT 2;
69 b
70 x
71 x
72 CHECK TABLE bug56680;
73 Table Op Msg_type Msg_text
74 test.bug56680 check status OK
75 connection default;
76 disconnect con1;
77 SELECT b FROM bug56680 LIMIT 2;
78 b
79 x
80 x
81 CREATE TABLE bug56680_2(
82 a INT AUTO_INCREMENT PRIMARY KEY,
83 b VARCHAR(2) CHARSET latin1 COLLATE latin1_german2_ci,
84 c INT,
85 INDEX(b))
86 ENGINE=InnoDB STATS_PERSISTENT=0;
87 INSERT INTO bug56680_2 SELECT 0,_latin1 0xdf,c FROM bug56680;
88 BEGIN;
89 SELECT HEX(b) FROM bug56680_2 LIMIT 2;
90 HEX(b)
91 DF
92 DF
93 DELETE FROM bug56680_2 WHERE a=1;
94 INSERT INTO bug56680_2 VALUES(1,'SS',1);
95 SELECT HEX(b) FROM bug56680_2 LIMIT 3;
96 HEX(b)
97 5353
98 DF
99 DF
100 CHECK TABLE bug56680_2;
101 Table Op Msg_type Msg_text
102 test.bug56680_2 check status OK
103 ALTER TABLE bug56680_2 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
104 SELECT HEX(b) FROM bug56680_2 LIMIT 2;
105 HEX(b)
106 5353
107 DF
108 DELETE FROM bug56680_2 WHERE a=1;
109 INSERT INTO bug56680_2 VALUES(1,_latin1 0xdf,1);
110 SELECT HEX(b) FROM bug56680_2 LIMIT 3;
111 HEX(b)
112 DF
113 DF
114 DF
115 CHECK TABLE bug56680_2;
116 Table Op Msg_type Msg_text
117 test.bug56680_2 check status OK
118 # restart
119 CHECK TABLE bug56680_2;
120 Table Op Msg_type Msg_text
121 test.bug56680_2 check status OK
122 DROP TABLE bug56680_2;
123 DROP TABLE bug56680;