Debian Codegraph @

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

raw
1 # bug#18082045 - TESTFK CREATEDROPWITHDATA NEED HIGH MAXNOOFCONCURRENTSCANS
2 create table t1 (
3 a1 int not null,
4 primary key using hash (a1)
5 ) engine ndb;
6 create table t2 (
7 a2 int not null,
8 b2 int not null,
9 primary key using hash (a2),
10 key t2x1 (b2),
11 -- cascade is not essential to demo the bug
12 foreign key t2fk1 (b2) references t1 (a1) on delete cascade
13 ) engine ndb;
14 begin;
15 delete from t1;
16 rollback;
17 select count(*) from t1;
18 count(*)
19 1024
20 select count(*) from t2;
21 count(*)
22 1024
23 delete from t1;
24 select count(*) from t1;
25 count(*)
26 0
27 select count(*) from t2;
28 count(*)
29 0
30 begin; delete from t1 where a1 in (0,256,255,254,253,252,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,235,234,233,232,231,230,229,228,227,226,225,224,223,222,221,220,219,218,217,216,215,214,213,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,194,193,192,191,190,189,188,187,186,185,184,183,182,181,180,179,178,177,176,175,174,173,172,171,170,169,168,167,166,165,164,163,162,161,160,159,158,157,156,155,154,153,152,151,150,149,148,147,146,145,144,143,142,141,140,139,138,137,136,135,134,133,132,131,130,129,128,127,126,125,124,123,122,121,120,119,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1); rollback;
31 select count(*) from t1;
32 count(*)
33 256
34 select count(*) from t2;
35 count(*)
36 256
37 delete from t1 where a1 in (0,256,255,254,253,252,251,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,235,234,233,232,231,230,229,228,227,226,225,224,223,222,221,220,219,218,217,216,215,214,213,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,194,193,192,191,190,189,188,187,186,185,184,183,182,181,180,179,178,177,176,175,174,173,172,171,170,169,168,167,166,165,164,163,162,161,160,159,158,157,156,155,154,153,152,151,150,149,148,147,146,145,144,143,142,141,140,139,138,137,136,135,134,133,132,131,130,129,128,127,126,125,124,123,122,121,120,119,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1);
38 select count(*) from t1;
39 count(*)
40 0
41 select count(*) from t2;
42 count(*)
43 0
44 drop table t2, t1;