Debian Codegraph @

mysql-test/suite/innodb/r/innodb-read-view.result

raw
1 CREATE TABLE t1 (c1 INT , c2 CHAR(10), PRIMARY KEY (c1)) ENGINE = InnoDB;
2 INSERT INTO t1 VALUES(0, "0");
3 INSERT INTO t1 VALUES(1, "1");
4 INSERT INTO t1 VALUES(2, "2");
5 INSERT INTO t1 VALUES(3, "3");
6 CREATE TABLE t2 (c1 INT , c2 CHAR(10), PRIMARY KEY (c1)) ENGINE = InnoDB;
7 INSERT INTO t2 VALUES(0, "a");
8 INSERT INTO t2 VALUES(1, "b");
9 INSERT INTO t2 VALUES(2, "c");
10 INSERT INTO t2 VALUES(3, "d");
11 connect con1,localhost,root,,;
12 SET AUTOCOMMIT=0;
13 BEGIN;
14 SELECT * FROM t2;
15 c1 c2
16 0 a
17 1 b
18 2 c
19 3 d
20 connection default;
21 SET AUTOCOMMIT=0;
22 BEGIN;
23 SELECT * FROM t1;
24 c1 c2
25 0 0
26 1 1
27 2 2
28 3 3
29 connect con2,localhost,root,,;
30 SET AUTOCOMMIT=0;
31 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
32 BEGIN;
33 SELECT * FROM t1;
34 c1 c2
35 0 0
36 1 1
37 2 2
38 3 3
39 SELECT * FROM t2;
40 c1 c2
41 0 a
42 1 b
43 2 c
44 3 d
45 connection con1;
46 UPDATE t2 SET c1 = c1 + 100;
47 SELECT * FROM t2;
48 c1 c2
49 100 a
50 101 b
51 102 c
52 103 d
53 COMMIT;
54 connection default;
55 UPDATE t1 SET c1 = c1 + 100;
56 SELECT * FROM t1;
57 c1 c2
58 100 0
59 101 1
60 102 2
61 103 3
62 COMMIT;
63 connection con2;
64 SET DEBUG_SYNC='row_search_for_mysql_before_return WAIT_FOR waiting1';
65 SELECT * FROM t1;;
66 connection default;
67 SET DEBUG_SYNC='now SIGNAL waiting1';
68 connection con2;
69 c1 c2
70 0 0
71 1 1
72 2 2
73 3 3
74 connection con2;
75 SET DEBUG_SYNC='row_search_for_mysql_before_return WAIT_FOR waiting1';
76 SELECT * FROM t2;;
77 connection default;
78 SET DEBUG_SYNC='now SIGNAL waiting1';
79 connection con2;
80 c1 c2
81 0 a
82 1 b
83 2 c
84 3 d
85 connection default;
86 connection con1;
87 SET AUTOCOMMIT=0;
88 BEGIN;
89 SELECT * FROM t1;
90 c1 c2
91 100 0
92 101 1
93 102 2
94 103 3
95 connection default;
96 SET AUTOCOMMIT=0;
97 BEGIN;
98 SELECT * FROM t2;
99 c1 c2
100 100 a
101 101 b
102 102 c
103 103 d
104 UPDATE t2 SET c1 = c1 + 100;
105 SELECT * FROM t2;
106 c1 c2
107 200 a
108 201 b
109 202 c
110 203 d
111 COMMIT;
112 connection con2;
113 SET AUTOCOMMIT=0;
114 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
115 BEGIN;
116 SELECT * FROM t1;
117 c1 c2
118 100 0
119 101 1
120 102 2
121 103 3
122 SELECT * FROM t2;
123 c1 c2
124 200 a
125 201 b
126 202 c
127 203 d
128 connection con1;
129 UPDATE t1 SET c1 = c1 + 100;
130 SELECT * FROM t1;
131 c1 c2
132 200 0
133 201 1
134 202 2
135 203 3
136 COMMIT;
137 connection con2;
138 SET DEBUG_SYNC='row_select_wait WAIT_FOR waiting1';
139 SELECT * FROM t1;;
140 connection con1;
141 SET DEBUG_SYNC='now SIGNAL waiting1';
142 connection con2;
143 c1 c2
144 100 0
145 101 1
146 102 2
147 103 3
148 SET DEBUG_SYNC='row_select_wait WAIT_FOR waiting1';
149 SELECT * FROM t2;;
150 connection default;
151 SET DEBUG_SYNC='now SIGNAL waiting1';
152 connection con2;
153 c1 c2
154 200 a
155 201 b
156 202 c
157 203 d
158 disconnect con2;
159 connection default;
160 DROP TABLE t1;
161 DROP TABLE t2;
162 #
163 # Bug 21433768: NON-REPEATABLE READ WITH REPEATABLE READ ISOLATION
164 #
165 connection con1;
166 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 INT) ENGINE = InnoDB;
167 INSERT INTO t1 values (1, 0), (2, 0);
168 SELECT * FROM t1 ORDER BY col1;
169 col1 col2
170 1 0
171 2 0
172 START TRANSACTION;
173 UPDATE t1 SET col2 = 100;
174 SET DEBUG_SYNC = 'after_trx_committed_in_memory SIGNAL s1 WAIT_FOR s2';
175 COMMIT;;
176 connection default;
177 SET DEBUG_SYNC = 'now WAIT_FOR s1';
178 UPDATE t1 SET col2 = col2 + 10 where col1 = 1;
179 COMMIT;
180 SELECT * FROM t1 ORDER BY col1;
181 col1 col2
182 1 110
183 2 100
184 SET DEBUG_SYNC = 'now SIGNAL s2';
185 connection con1;
186 disconnect con1;
187 connection default;
188 SET DEBUG_SYNC= 'RESET';
189 DROP TABLE t1;