Debian Codegraph @

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

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