Debian Codegraph @

mysql-test/suite/ndb/r/ndb_tc_state.result

raw
1 use test;
2 create table parent (a int primary key, b int) engine=ndb;
3 create table child (a int primary key, b int, foreign key (a) references
4 parent(a)) engine=ndb;
5 create table t1 (a int primary key, b int, c int, unique(b)) engine=ndb;
6 insert into parent values (1,1);
7 Testing case 0 : update t1 set c=10 where a=
8 begin;
9 select * from child where a=10;
10 a b
11 insert into child values (1,1);
12 insert into child values (1,1);
13 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
14 begin;
15 select * from child where a=9;
16 a b
17 insert into child values (1,1);
18 insert into child values (1,1);
19 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
20 begin;
21 select * from child where a=8;
22 a b
23 insert into child values (1,1);
24 insert into child values (1,1);
25 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
26 begin;
27 select * from child where a=7;
28 a b
29 insert into child values (1,1);
30 insert into child values (1,1);
31 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
32 begin;
33 select * from child where a=6;
34 a b
35 insert into child values (1,1);
36 insert into child values (1,1);
37 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
38 begin;
39 select * from child where a=5;
40 a b
41 insert into child values (1,1);
42 insert into child values (1,1);
43 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
44 begin;
45 select * from child where a=4;
46 a b
47 insert into child values (1,1);
48 insert into child values (1,1);
49 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
50 begin;
51 select * from child where a=3;
52 a b
53 insert into child values (1,1);
54 insert into child values (1,1);
55 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
56 begin;
57 select * from child where a=2;
58 a b
59 insert into child values (1,1);
60 insert into child values (1,1);
61 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
62 begin;
63 select * from child where a=1;
64 a b
65 insert into child values (1,1);
66 insert into child values (1,1);
67 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
68 update t1 set c=10 where a=10;
69 update t1 set c=10 where a=9;
70 update t1 set c=10 where a=8;
71 update t1 set c=10 where a=7;
72 update t1 set c=10 where a=6;
73 update t1 set c=10 where a=5;
74 update t1 set c=10 where a=4;
75 update t1 set c=10 where a=3;
76 update t1 set c=10 where a=2;
77 update t1 set c=10 where a=1;
78 Testing case 1 : delete from t1 where a=
79 begin;
80 select * from child where a=10;
81 a b
82 insert into child values (1,1);
83 insert into child values (1,1);
84 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
85 begin;
86 select * from child where a=9;
87 a b
88 insert into child values (1,1);
89 insert into child values (1,1);
90 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
91 begin;
92 select * from child where a=8;
93 a b
94 insert into child values (1,1);
95 insert into child values (1,1);
96 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
97 begin;
98 select * from child where a=7;
99 a b
100 insert into child values (1,1);
101 insert into child values (1,1);
102 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
103 begin;
104 select * from child where a=6;
105 a b
106 insert into child values (1,1);
107 insert into child values (1,1);
108 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
109 begin;
110 select * from child where a=5;
111 a b
112 insert into child values (1,1);
113 insert into child values (1,1);
114 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
115 begin;
116 select * from child where a=4;
117 a b
118 insert into child values (1,1);
119 insert into child values (1,1);
120 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
121 begin;
122 select * from child where a=3;
123 a b
124 insert into child values (1,1);
125 insert into child values (1,1);
126 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
127 begin;
128 select * from child where a=2;
129 a b
130 insert into child values (1,1);
131 insert into child values (1,1);
132 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
133 begin;
134 select * from child where a=1;
135 a b
136 insert into child values (1,1);
137 insert into child values (1,1);
138 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
139 delete from t1 where a=10;
140 delete from t1 where a=9;
141 delete from t1 where a=8;
142 delete from t1 where a=7;
143 delete from t1 where a=6;
144 delete from t1 where a=5;
145 delete from t1 where a=4;
146 delete from t1 where a=3;
147 delete from t1 where a=2;
148 delete from t1 where a=1;
149 Testing case 2 : select c from t1 where a=
150 begin;
151 select * from child where a=10;
152 a b
153 insert into child values (1,1);
154 insert into child values (1,1);
155 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
156 begin;
157 select * from child where a=9;
158 a b
159 insert into child values (1,1);
160 insert into child values (1,1);
161 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
162 begin;
163 select * from child where a=8;
164 a b
165 insert into child values (1,1);
166 insert into child values (1,1);
167 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
168 begin;
169 select * from child where a=7;
170 a b
171 insert into child values (1,1);
172 insert into child values (1,1);
173 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
174 begin;
175 select * from child where a=6;
176 a b
177 insert into child values (1,1);
178 insert into child values (1,1);
179 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
180 begin;
181 select * from child where a=5;
182 a b
183 insert into child values (1,1);
184 insert into child values (1,1);
185 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
186 begin;
187 select * from child where a=4;
188 a b
189 insert into child values (1,1);
190 insert into child values (1,1);
191 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
192 begin;
193 select * from child where a=3;
194 a b
195 insert into child values (1,1);
196 insert into child values (1,1);
197 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
198 begin;
199 select * from child where a=2;
200 a b
201 insert into child values (1,1);
202 insert into child values (1,1);
203 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
204 begin;
205 select * from child where a=1;
206 a b
207 insert into child values (1,1);
208 insert into child values (1,1);
209 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
210 select c from t1 where a=10;
211 c
212 select c from t1 where a=9;
213 c
214 select c from t1 where a=8;
215 c
216 select c from t1 where a=7;
217 c
218 select c from t1 where a=6;
219 c
220 select c from t1 where a=5;
221 c
222 select c from t1 where a=4;
223 c
224 select c from t1 where a=3;
225 c
226 select c from t1 where a=2;
227 c
228 select c from t1 where a=1;
229 c
230 Testing case 3 : update t1 set c=20 where b=
231 begin;
232 select * from child where a=10;
233 a b
234 insert into child values (1,1);
235 insert into child values (1,1);
236 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
237 begin;
238 select * from child where a=9;
239 a b
240 insert into child values (1,1);
241 insert into child values (1,1);
242 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
243 begin;
244 select * from child where a=8;
245 a b
246 insert into child values (1,1);
247 insert into child values (1,1);
248 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
249 begin;
250 select * from child where a=7;
251 a b
252 insert into child values (1,1);
253 insert into child values (1,1);
254 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
255 begin;
256 select * from child where a=6;
257 a b
258 insert into child values (1,1);
259 insert into child values (1,1);
260 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
261 begin;
262 select * from child where a=5;
263 a b
264 insert into child values (1,1);
265 insert into child values (1,1);
266 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
267 begin;
268 select * from child where a=4;
269 a b
270 insert into child values (1,1);
271 insert into child values (1,1);
272 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
273 begin;
274 select * from child where a=3;
275 a b
276 insert into child values (1,1);
277 insert into child values (1,1);
278 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
279 begin;
280 select * from child where a=2;
281 a b
282 insert into child values (1,1);
283 insert into child values (1,1);
284 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
285 begin;
286 select * from child where a=1;
287 a b
288 insert into child values (1,1);
289 insert into child values (1,1);
290 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
291 update t1 set c=20 where b=10;
292 update t1 set c=20 where b=9;
293 update t1 set c=20 where b=8;
294 update t1 set c=20 where b=7;
295 update t1 set c=20 where b=6;
296 update t1 set c=20 where b=5;
297 update t1 set c=20 where b=4;
298 update t1 set c=20 where b=3;
299 update t1 set c=20 where b=2;
300 update t1 set c=20 where b=1;
301 Testing case 4 : delete from t1 where b=
302 begin;
303 select * from child where a=10;
304 a b
305 insert into child values (1,1);
306 insert into child values (1,1);
307 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
308 begin;
309 select * from child where a=9;
310 a b
311 insert into child values (1,1);
312 insert into child values (1,1);
313 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
314 begin;
315 select * from child where a=8;
316 a b
317 insert into child values (1,1);
318 insert into child values (1,1);
319 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
320 begin;
321 select * from child where a=7;
322 a b
323 insert into child values (1,1);
324 insert into child values (1,1);
325 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
326 begin;
327 select * from child where a=6;
328 a b
329 insert into child values (1,1);
330 insert into child values (1,1);
331 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
332 begin;
333 select * from child where a=5;
334 a b
335 insert into child values (1,1);
336 insert into child values (1,1);
337 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
338 begin;
339 select * from child where a=4;
340 a b
341 insert into child values (1,1);
342 insert into child values (1,1);
343 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
344 begin;
345 select * from child where a=3;
346 a b
347 insert into child values (1,1);
348 insert into child values (1,1);
349 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
350 begin;
351 select * from child where a=2;
352 a b
353 insert into child values (1,1);
354 insert into child values (1,1);
355 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
356 begin;
357 select * from child where a=1;
358 a b
359 insert into child values (1,1);
360 insert into child values (1,1);
361 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
362 delete from t1 where b=10;
363 delete from t1 where b=9;
364 delete from t1 where b=8;
365 delete from t1 where b=7;
366 delete from t1 where b=6;
367 delete from t1 where b=5;
368 delete from t1 where b=4;
369 delete from t1 where b=3;
370 delete from t1 where b=2;
371 delete from t1 where b=1;
372 Testing case 5 : select c from t1 where b=
373 begin;
374 select * from child where a=10;
375 a b
376 insert into child values (1,1);
377 insert into child values (1,1);
378 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
379 begin;
380 select * from child where a=9;
381 a b
382 insert into child values (1,1);
383 insert into child values (1,1);
384 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
385 begin;
386 select * from child where a=8;
387 a b
388 insert into child values (1,1);
389 insert into child values (1,1);
390 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
391 begin;
392 select * from child where a=7;
393 a b
394 insert into child values (1,1);
395 insert into child values (1,1);
396 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
397 begin;
398 select * from child where a=6;
399 a b
400 insert into child values (1,1);
401 insert into child values (1,1);
402 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
403 begin;
404 select * from child where a=5;
405 a b
406 insert into child values (1,1);
407 insert into child values (1,1);
408 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
409 begin;
410 select * from child where a=4;
411 a b
412 insert into child values (1,1);
413 insert into child values (1,1);
414 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
415 begin;
416 select * from child where a=3;
417 a b
418 insert into child values (1,1);
419 insert into child values (1,1);
420 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
421 begin;
422 select * from child where a=2;
423 a b
424 insert into child values (1,1);
425 insert into child values (1,1);
426 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
427 begin;
428 select * from child where a=1;
429 a b
430 insert into child values (1,1);
431 insert into child values (1,1);
432 ERROR 23000: Duplicate entry '1' for key 'child.PRIMARY'
433 select c from t1 where b=10;
434 c
435 select c from t1 where b=9;
436 c
437 select c from t1 where b=8;
438 c
439 select c from t1 where b=7;
440 c
441 select c from t1 where b=6;
442 c
443 select c from t1 where b=5;
444 c
445 select c from t1 where b=4;
446 c
447 select c from t1 where b=3;
448 c
449 select c from t1 where b=2;
450 c
451 select c from t1 where b=1;
452 c
453 drop table t1;
454 drop table child;
455 drop table parent;