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 'T1'
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 'T2'
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 'T3'
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 'T1'
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 'T2'
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 'T3'
64 SET DEBUG_SYNC='row_search_for_mysql_before_return WAIT_FOR waiting1';
65 SELECT * FROM t1;;
66 'T2'
67 SET DEBUG_SYNC='now SIGNAL waiting1';
68 'Signalled T3'
69 'T3'
70 c1 c2
71 0 0
72 1 1
73 2 2
74 3 3
75 'T3'
76 SET DEBUG_SYNC='row_search_for_mysql_before_return WAIT_FOR waiting1';
77 SELECT * FROM t2;;
78 'T2'
79 SET DEBUG_SYNC='now SIGNAL waiting1';
80 'Signalled T3'
81 'T3'
82 c1 c2
83 0 a
84 1 b
85 2 c
86 3 d
87 'T1'
88 SET AUTOCOMMIT=0;
89 BEGIN;
90 SELECT * FROM t1;
91 c1 c2
92 100 0
93 101 1
94 102 2
95 103 3
96 'T2'
97 SET AUTOCOMMIT=0;
98 BEGIN;
99 SELECT * FROM t2;
100 c1 c2
101 100 a
102 101 b
103 102 c
104 103 d
105 UPDATE t2 SET c1 = c1 + 100;
106 SELECT * FROM t2;
107 c1 c2
108 200 a
109 201 b
110 202 c
111 203 d
112 COMMIT;
113 'T3'
114 SET AUTOCOMMIT=0;
115 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
116 BEGIN;
117 SELECT * FROM t1;
118 c1 c2
119 100 0
120 101 1
121 102 2
122 103 3
123 SELECT * FROM t2;
124 c1 c2
125 200 a
126 201 b
127 202 c
128 203 d
129 'T1'
130 UPDATE t1 SET c1 = c1 + 100;
131 SELECT * FROM t1;
132 c1 c2
133 200 0
134 201 1
135 202 2
136 203 3
137 COMMIT;
138 'T3'
139 SET DEBUG_SYNC='row_select_wait WAIT_FOR waiting1';
140 SELECT * FROM t1;;
141 'T2'
142 SET DEBUG_SYNC='now SIGNAL waiting1';
143 'Signalled T3'
144 'T3'
145 c1 c2
146 100 0
147 101 1
148 102 2
149 103 3
150 'T3'
151 SET DEBUG_SYNC='row_select_wait WAIT_FOR waiting1';
152 SELECT * FROM t2;;
153 'T2'
154 SET DEBUG_SYNC='now SIGNAL waiting1';
155 'Signalled T3'
156 'T3'
157 c1 c2
158 200 a
159 201 b
160 202 c
161 203 d
162 DROP TABLE t1;
163 DROP TABLE t2;
164 #
165 # Bug 21433768: NON-REPEATABLE READ WITH REPEATABLE READ ISOLATION
166 #
167 # connection con1
168 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 INT) ENGINE = InnoDB;
169 INSERT INTO t1 values (1, 0), (2, 0);
170 SELECT * FROM t1 ORDER BY col1;
171 col1 col2
172 1 0
173 2 0
174 START TRANSACTION;
175 UPDATE t1 SET col2 = 100;
176 SET DEBUG_SYNC = 'after_trx_committed_in_memory SIGNAL s1 WAIT_FOR s2';
177 COMMIT;;
178 # connection default
179 SET DEBUG_SYNC = 'now WAIT_FOR s1';
180 UPDATE t1 SET col2 = col2 + 10 where col1 = 1;
181 COMMIT;
182 SELECT * FROM t1 ORDER BY col1;
183 col1 col2
184 1 110
185 2 100
186 SET DEBUG_SYNC = 'now SIGNAL s2';
187 # connection con1
188 # reap COMMIT for con1
189 # connection default
190 DROP TABLE t1;
191 SET DEBUG_SYNC= 'RESET';