Debian Codegraph @

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

raw
1 CREATE TABLE t1(id INT PRIMARY KEY, v INT NOT NULL) ENGINE=InnoDB;
2 # Adding debug point 'trx_sys_rw_trx_add_rc' to @@GLOBAL.debug
3 CREATE PROCEDURE create_rw_transactions(k INT)
4 BEGIN
5 WHILE 1 DO
6 START TRANSACTION;
7 UPDATE t1 SET v=v+1 WHERE id=k;
8 COMMIT;
9 END WHILE;
10 END|
11 INSERT INTO t1 (id,v) VALUES (0,0);
12 CALL create_rw_transactions(0);
13 INSERT INTO t1 (id,v) VALUES (1,0);
14 CALL create_rw_transactions(1);
15 INSERT INTO t1 (id,v) VALUES (2,0);
16 CALL create_rw_transactions(2);
17 INSERT INTO t1 (id,v) VALUES (3,0);
18 CALL create_rw_transactions(3);
19 INSERT INTO t1 (id,v) VALUES (4,0);
20 CALL create_rw_transactions(4);
21 INSERT INTO t1 (id,v) VALUES (5,0);
22 CALL create_rw_transactions(5);
23 INSERT INTO t1 (id,v) VALUES (6,0);
24 CALL create_rw_transactions(6);
25 INSERT INTO t1 (id,v) VALUES (7,0);
26 CALL create_rw_transactions(7);
27 INSERT INTO t1 (id,v) VALUES (8,0);
28 CALL create_rw_transactions(8);
29 INSERT INTO t1 (id,v) VALUES (9,0);
30 CALL create_rw_transactions(9);
31 INSERT INTO t1 (id,v) VALUES (10,0);
32 CALL create_rw_transactions(10);
33 INSERT INTO t1 (id,v) VALUES (11,0);
34 CALL create_rw_transactions(11);
35 INSERT INTO t1 (id,v) VALUES (12,0);
36 CALL create_rw_transactions(12);
37 INSERT INTO t1 (id,v) VALUES (13,0);
38 CALL create_rw_transactions(13);
39 INSERT INTO t1 (id,v) VALUES (14,0);
40 CALL create_rw_transactions(14);
41 INSERT INTO t1 (id,v) VALUES (15,0);
42 CALL create_rw_transactions(15);
43 INSERT INTO t1 (id,v) VALUES (16,0);
44 CALL create_rw_transactions(16);
45 INSERT INTO t1 (id,v) VALUES (17,0);
46 CALL create_rw_transactions(17);
47 INSERT INTO t1 (id,v) VALUES (18,0);
48 CALL create_rw_transactions(18);
49 INSERT INTO t1 (id,v) VALUES (19,0);
50 CALL create_rw_transactions(19);
51 INSERT INTO t1 (id,v) VALUES (20,0);
52 CALL create_rw_transactions(20);
53 INSERT INTO t1 (id,v) VALUES (21,0);
54 CALL create_rw_transactions(21);
55 INSERT INTO t1 (id,v) VALUES (22,0);
56 CALL create_rw_transactions(22);
57 INSERT INTO t1 (id,v) VALUES (23,0);
58 CALL create_rw_transactions(23);
59 INSERT INTO t1 (id,v) VALUES (24,0);
60 CALL create_rw_transactions(24);
61 INSERT INTO t1 (id,v) VALUES (25,0);
62 CALL create_rw_transactions(25);
63 INSERT INTO t1 (id,v) VALUES (26,0);
64 CALL create_rw_transactions(26);
65 INSERT INTO t1 (id,v) VALUES (27,0);
66 CALL create_rw_transactions(27);
67 INSERT INTO t1 (id,v) VALUES (28,0);
68 CALL create_rw_transactions(28);
69 INSERT INTO t1 (id,v) VALUES (29,0);
70 CALL create_rw_transactions(29);
71 INSERT INTO t1 (id,v) VALUES (30,0);
72 CALL create_rw_transactions(30);
73 INSERT INTO t1 (id,v) VALUES (31,0);
74 CALL create_rw_transactions(31);
75 INSERT INTO t1 (id,v) VALUES (32,0);
76 CALL create_rw_transactions(32);
77 INSERT INTO t1 (id,v) VALUES (33,0);
78 CALL create_rw_transactions(33);
79 INSERT INTO t1 (id,v) VALUES (34,0);
80 CALL create_rw_transactions(34);
81 INSERT INTO t1 (id,v) VALUES (35,0);
82 CALL create_rw_transactions(35);
83 INSERT INTO t1 (id,v) VALUES (36,0);
84 CALL create_rw_transactions(36);
85 INSERT INTO t1 (id,v) VALUES (37,0);
86 CALL create_rw_transactions(37);
87 INSERT INTO t1 (id,v) VALUES (38,0);
88 CALL create_rw_transactions(38);
89 INSERT INTO t1 (id,v) VALUES (39,0);
90 CALL create_rw_transactions(39);
91 INSERT INTO t1 (id,v) VALUES (40,0);
92 CALL create_rw_transactions(40);
93 INSERT INTO t1 (id,v) VALUES (41,0);
94 CALL create_rw_transactions(41);
95 INSERT INTO t1 (id,v) VALUES (42,0);
96 CALL create_rw_transactions(42);
97 INSERT INTO t1 (id,v) VALUES (43,0);
98 CALL create_rw_transactions(43);
99 INSERT INTO t1 (id,v) VALUES (44,0);
100 CALL create_rw_transactions(44);
101 INSERT INTO t1 (id,v) VALUES (45,0);
102 CALL create_rw_transactions(45);
103 INSERT INTO t1 (id,v) VALUES (46,0);
104 CALL create_rw_transactions(46);
105 INSERT INTO t1 (id,v) VALUES (47,0);
106 CALL create_rw_transactions(47);
107 INSERT INTO t1 (id,v) VALUES (48,0);
108 CALL create_rw_transactions(48);
109 INSERT INTO t1 (id,v) VALUES (49,0);
110 CALL create_rw_transactions(49);
111 INSERT INTO t1 (id,v) VALUES (50,0);
112 CALL create_rw_transactions(50);
113 INSERT INTO t1 (id,v) VALUES (51,0);
114 CALL create_rw_transactions(51);
115 INSERT INTO t1 (id,v) VALUES (52,0);
116 CALL create_rw_transactions(52);
117 INSERT INTO t1 (id,v) VALUES (53,0);
118 CALL create_rw_transactions(53);
119 INSERT INTO t1 (id,v) VALUES (54,0);
120 CALL create_rw_transactions(54);
121 INSERT INTO t1 (id,v) VALUES (55,0);
122 CALL create_rw_transactions(55);
123 INSERT INTO t1 (id,v) VALUES (56,0);
124 CALL create_rw_transactions(56);
125 INSERT INTO t1 (id,v) VALUES (57,0);
126 CALL create_rw_transactions(57);
127 INSERT INTO t1 (id,v) VALUES (58,0);
128 CALL create_rw_transactions(58);
129 INSERT INTO t1 (id,v) VALUES (59,0);
130 CALL create_rw_transactions(59);
131 INSERT INTO t1 (id,v) VALUES (60,0);
132 CALL create_rw_transactions(60);
133 INSERT INTO t1 (id,v) VALUES (61,0);
134 CALL create_rw_transactions(61);
135 INSERT INTO t1 (id,v) VALUES (62,0);
136 CALL create_rw_transactions(62);
137 INSERT INTO t1 (id,v) VALUES (63,0);
138 CALL create_rw_transactions(63);
139 INSERT INTO t1 (id,v) VALUES (64,0);
140 CALL create_rw_transactions(64);
141 INSERT INTO t1 (id,v) VALUES (65,0);
142 CALL create_rw_transactions(65);
143 INSERT INTO t1 (id,v) VALUES (66,0);
144 CALL create_rw_transactions(66);
145 INSERT INTO t1 (id,v) VALUES (67,0);
146 CALL create_rw_transactions(67);
147 INSERT INTO t1 (id,v) VALUES (68,0);
148 CALL create_rw_transactions(68);
149 INSERT INTO t1 (id,v) VALUES (69,0);
150 CALL create_rw_transactions(69);
151 INSERT INTO t1 (id,v) VALUES (70,0);
152 CALL create_rw_transactions(70);
153 INSERT INTO t1 (id,v) VALUES (71,0);
154 CALL create_rw_transactions(71);
155 INSERT INTO t1 (id,v) VALUES (72,0);
156 CALL create_rw_transactions(72);
157 INSERT INTO t1 (id,v) VALUES (73,0);
158 CALL create_rw_transactions(73);
159 INSERT INTO t1 (id,v) VALUES (74,0);
160 CALL create_rw_transactions(74);
161 INSERT INTO t1 (id,v) VALUES (75,0);
162 CALL create_rw_transactions(75);
163 INSERT INTO t1 (id,v) VALUES (76,0);
164 CALL create_rw_transactions(76);
165 INSERT INTO t1 (id,v) VALUES (77,0);
166 CALL create_rw_transactions(77);
167 INSERT INTO t1 (id,v) VALUES (78,0);
168 CALL create_rw_transactions(78);
169 INSERT INTO t1 (id,v) VALUES (79,0);
170 CALL create_rw_transactions(79);
171 INSERT INTO t1 (id,v) VALUES (80,0);
172 CALL create_rw_transactions(80);
173 INSERT INTO t1 (id,v) VALUES (81,0);
174 CALL create_rw_transactions(81);
175 INSERT INTO t1 (id,v) VALUES (82,0);
176 CALL create_rw_transactions(82);
177 INSERT INTO t1 (id,v) VALUES (83,0);
178 CALL create_rw_transactions(83);
179 INSERT INTO t1 (id,v) VALUES (84,0);
180 CALL create_rw_transactions(84);
181 INSERT INTO t1 (id,v) VALUES (85,0);
182 CALL create_rw_transactions(85);
183 INSERT INTO t1 (id,v) VALUES (86,0);
184 CALL create_rw_transactions(86);
185 INSERT INTO t1 (id,v) VALUES (87,0);
186 CALL create_rw_transactions(87);
187 INSERT INTO t1 (id,v) VALUES (88,0);
188 CALL create_rw_transactions(88);
189 INSERT INTO t1 (id,v) VALUES (89,0);
190 CALL create_rw_transactions(89);
191 INSERT INTO t1 (id,v) VALUES (90,0);
192 CALL create_rw_transactions(90);
193 INSERT INTO t1 (id,v) VALUES (91,0);
194 CALL create_rw_transactions(91);
195 INSERT INTO t1 (id,v) VALUES (92,0);
196 CALL create_rw_transactions(92);
197 INSERT INTO t1 (id,v) VALUES (93,0);
198 CALL create_rw_transactions(93);
199 INSERT INTO t1 (id,v) VALUES (94,0);
200 CALL create_rw_transactions(94);
201 INSERT INTO t1 (id,v) VALUES (95,0);
202 CALL create_rw_transactions(95);
203 INSERT INTO t1 (id,v) VALUES (96,0);
204 CALL create_rw_transactions(96);
205 INSERT INTO t1 (id,v) VALUES (97,0);
206 CALL create_rw_transactions(97);
207 INSERT INTO t1 (id,v) VALUES (98,0);
208 CALL create_rw_transactions(98);
209 INSERT INTO t1 (id,v) VALUES (99,0);
210 CALL create_rw_transactions(99);
211 INSERT INTO t1 (id,v) VALUES (100,0);
212 CALL create_rw_transactions(100);
213 INSERT INTO t1 (id,v) VALUES (101,0);
214 CALL create_rw_transactions(101);
215 INSERT INTO t1 (id,v) VALUES (102,0);
216 CALL create_rw_transactions(102);
217 INSERT INTO t1 (id,v) VALUES (103,0);
218 CALL create_rw_transactions(103);
219 INSERT INTO t1 (id,v) VALUES (104,0);
220 CALL create_rw_transactions(104);
221 INSERT INTO t1 (id,v) VALUES (105,0);
222 CALL create_rw_transactions(105);
223 INSERT INTO t1 (id,v) VALUES (106,0);
224 CALL create_rw_transactions(106);
225 INSERT INTO t1 (id,v) VALUES (107,0);
226 CALL create_rw_transactions(107);
227 INSERT INTO t1 (id,v) VALUES (108,0);
228 CALL create_rw_transactions(108);
229 INSERT INTO t1 (id,v) VALUES (109,0);
230 CALL create_rw_transactions(109);
231 INSERT INTO t1 (id,v) VALUES (110,0);
232 CALL create_rw_transactions(110);
233 INSERT INTO t1 (id,v) VALUES (111,0);
234 CALL create_rw_transactions(111);
235 INSERT INTO t1 (id,v) VALUES (112,0);
236 CALL create_rw_transactions(112);
237 INSERT INTO t1 (id,v) VALUES (113,0);
238 CALL create_rw_transactions(113);
239 INSERT INTO t1 (id,v) VALUES (114,0);
240 CALL create_rw_transactions(114);
241 INSERT INTO t1 (id,v) VALUES (115,0);
242 CALL create_rw_transactions(115);
243 INSERT INTO t1 (id,v) VALUES (116,0);
244 CALL create_rw_transactions(116);
245 INSERT INTO t1 (id,v) VALUES (117,0);
246 CALL create_rw_transactions(117);
247 INSERT INTO t1 (id,v) VALUES (118,0);
248 CALL create_rw_transactions(118);
249 INSERT INTO t1 (id,v) VALUES (119,0);
250 CALL create_rw_transactions(119);
251 DROP PROCEDURE create_rw_transactions;
252 DROP TABLE t1;
253 # Removing debug point 'trx_sys_rw_trx_add_rc' from @@GLOBAL.debug