Debian Codegraph @

mysql-test/suite/innodb/r/implicit_to_explicit_conversion.result

raw
1 CREATE TABLE t1(id INT PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 (id) VALUES (1),(3);
3 BEGIN;
4 INSERT INTO t1 (id) VALUES (2);
5 BEGIN;
6 SET DEBUG_SYNC = "before_lock_rec_convert_impl_to_expl_for_trx
7 SIGNAL c2_decided
8 WAIT_FOR c2_can_convert";
9 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL c2_will_wait";
10 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
11 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
12 SET DEBUG_SYNC = "before_lock_trx_release_locks
13 SIGNAL c1_will_commit
14 WAIT_FOR c1_can_commit";
15 COMMIT;
16 BEGIN;
17 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
18 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
19 id
20 2
21 SET DEBUG_SYNC = "now SIGNAL c2_can_convert";
22 SET DEBUG_SYNC = "now WAIT_FOR c2_will_wait";
23 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
24 COMMIT;
25 id
26 2
27 COMMIT;
28 DROP TABLE t1;
29 CREATE TABLE t1(id INT PRIMARY KEY) ENGINE=InnoDB;
30 INSERT INTO t1 (id) VALUES (1),(3);
31 XA START "xid0";
32 INSERT INTO t1 (id) VALUES (2);
33 BEGIN;
34 SET DEBUG_SYNC = "before_lock_rec_convert_impl_to_expl_for_trx
35 SIGNAL c2_decided
36 WAIT_FOR c2_can_convert";
37 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL c2_will_wait";
38 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
39 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
40 SET DEBUG_SYNC = "before_lock_trx_release_locks
41 SIGNAL c1_will_commit
42 WAIT_FOR c1_can_commit";
43 XA END "xid0";
44 XA PREPARE "xid0";
45 XA COMMIT "xid0";
46 BEGIN;
47 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
48 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
49 id
50 2
51 SET DEBUG_SYNC = "now SIGNAL c2_can_convert";
52 SET DEBUG_SYNC = "now WAIT_FOR c2_will_wait";
53 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
54 COMMIT;
55 id
56 2
57 COMMIT;
58 DROP TABLE t1;
59 CREATE TABLE t1(id INT PRIMARY KEY) ENGINE=InnoDB;
60 INSERT INTO t1 (id) VALUES (1),(3);
61 BEGIN;
62 INSERT INTO t1 (id) VALUES (2);
63 BEGIN;
64 SET DEBUG_SYNC = "before_lock_rec_convert_impl_to_expl_for_trx
65 SIGNAL c2_decided
66 WAIT_FOR c2_can_convert";
67 SET DEBUG_SYNC = "after_lock_rec_convert_impl_to_expl_for_trx
68 SIGNAL c2_done_conversion";
69 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock
70 SIGNAL c2_done_locking";
71 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
72 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
73 SET DEBUG_SYNC = "before_lock_trx_release_locks
74 SIGNAL c1_will_commit
75 WAIT_FOR c1_can_commit";
76 COMMIT;
77 BEGIN;
78 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
79 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL c3_will_wait";
80 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock_impl_to_expl
81 SIGNAL c3_will_lock
82 WAIT_FOR c3_can_lock";
83 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
84 SET DEBUG_SYNC = "now WAIT_FOR c3_will_lock";
85 SET DEBUG_SYNC = "now SIGNAL c2_can_convert";
86 SET DEBUG_SYNC = "now WAIT_FOR c2_done_conversion";
87 SET DEBUG_SYNC = "now WAIT_FOR c2_done_locking";
88 SET DEBUG_SYNC = "now SIGNAL c3_can_lock";
89 SET DEBUG_SYNC = "now WAIT_FOR c3_will_wait";
90 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
91 COMMIT;
92 id
93 2
94 COMMIT;
95 id
96 2
97 COMMIT;
98 DROP TABLE t1;
99 CREATE TABLE t1(id INT PRIMARY KEY) ENGINE=InnoDB;
100 INSERT INTO t1 (id) VALUES (1),(3);
101 XA START "xid0";
102 INSERT INTO t1 (id) VALUES (2);
103 BEGIN;
104 SET DEBUG_SYNC = "before_lock_rec_convert_impl_to_expl_for_trx
105 SIGNAL c2_decided
106 WAIT_FOR c2_can_convert";
107 SET DEBUG_SYNC = "after_lock_rec_convert_impl_to_expl_for_trx
108 SIGNAL c2_done_conversion";
109 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock
110 SIGNAL c2_done_locking";
111 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
112 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
113 SET DEBUG_SYNC = "before_lock_trx_release_locks
114 SIGNAL c1_will_commit
115 WAIT_FOR c1_can_commit";
116 XA END "xid0";
117 XA PREPARE "xid0";
118 XA COMMIT "xid0";
119 BEGIN;
120 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
121 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL c3_will_wait";
122 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock_impl_to_expl
123 SIGNAL c3_will_lock
124 WAIT_FOR c3_can_lock";
125 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
126 SET DEBUG_SYNC = "now WAIT_FOR c3_will_lock";
127 SET DEBUG_SYNC = "now SIGNAL c2_can_convert";
128 SET DEBUG_SYNC = "now WAIT_FOR c2_done_conversion";
129 SET DEBUG_SYNC = "now WAIT_FOR c2_done_locking";
130 SET DEBUG_SYNC = "now SIGNAL c3_can_lock";
131 SET DEBUG_SYNC = "now WAIT_FOR c3_will_wait";
132 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
133 COMMIT;
134 id
135 2
136 COMMIT;
137 id
138 2
139 COMMIT;
140 DROP TABLE t1;
141 CREATE TABLE t1(id INT PRIMARY KEY,val INT, KEY val(val)) ENGINE=InnoDB;
142 INSERT INTO t1 (id,val) VALUES (1,1),(3,3);
143 BEGIN;
144 INSERT INTO t1 (id,val) VALUES (2,2);
145 BEGIN;
146 SET DEBUG_SYNC = "lock_rec_convert_impl_to_expl_will_validate
147 SIGNAL c2_decided
148 WAIT_FOR c2_can_validate";
149 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL c2_will_wait";
150 SELECT * FROM t1 WHERE val=2 FOR UPDATE;
151 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
152 SET DEBUG_SYNC = "before_lock_trx_release_locks
153 SIGNAL c1_will_commit
154 WAIT_FOR c1_can_commit";
155 COMMIT;
156 BEGIN;
157 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
158 SELECT * FROM t1 WHERE val=2 FOR UPDATE;
159 id val
160 2 2
161 SET DEBUG_SYNC = "now SIGNAL c2_can_validate";
162 SET DEBUG_SYNC = "now WAIT_FOR c2_will_wait";
163 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
164 COMMIT;
165 id val
166 2 2
167 COMMIT;
168 DROP TABLE t1;
169 CREATE TABLE t1(id INT PRIMARY KEY) ENGINE=InnoDB;
170 INSERT INTO t1 (id) VALUES (1),(3);
171 BEGIN;
172 INSERT INTO t1 (id) VALUES (2);
173 BEGIN;
174 INSERT INTO t1 (id) VALUES (4);
175 BEGIN;
176 SET DEBUG_SYNC = "before_lock_rec_convert_impl_to_expl_for_trx
177 SIGNAL c2_decided
178 WAIT_FOR c2_can_convert";
179 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock SIGNAL c2_will_wait";
180 SELECT * FROM t1 WHERE id=2 FOR UPDATE;
181 SET DEBUG_SYNC = "now WAIT_FOR c2_decided";
182 SET DEBUG_SYNC = "after_trx_erase_lists
183 SIGNAL c1_will_commit
184 WAIT_FOR c1_can_commit";
185 COMMIT;
186 SET DEBUG_SYNC = "now WAIT_FOR c1_will_commit";
187 SET DEBUG_SYNC = "after_lock_clust_rec_read_check_and_lock SIGNAL c2_can_convert WAIT_FOR c3_can_verify";
188 SELECT * FROM t1 WHERE id=2 FOR UPDATE;;
189 SET DEBUG_SYNC = "now WAIT_FOR c2_will_wait";
190 SET DEBUG_SYNC = "now SIGNAL c1_can_commit";
191 SET DEBUG_SYNC = "now SIGNAL c3_can_verify";
192 id
193 2
194 COMMIT;
195 id
196 2
197 COMMIT;
198 DROP TABLE t1;