Debian Codegraph @

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

raw
1 create table parent (
2 a int primary key auto_increment,
3 b int not null,
4 c int not null,
5 unique(b) using hash,
6 index(c)) engine = ndb;
7 create table child (
8 a int primary key auto_increment,
9 b int not null,
10 c int not null,
11 unique(b) using hash,
12 index(c)) engine = ndb;
13 alter table child add constraint fkname foreign key (a) references parent(a);
14 insert into parent values (1,1,1);
15 insert into child values (1,1,1);
16 insert into child values (2,2,2);
17 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`a`) REFERENCES `parent` (`a`) ON DELETE NO ACTION ON UPDATE NO ACTION)
18 begin;
19 delete from parent;
20 delete from child;
21 commit;
22 begin;
23 insert into child values (2,2,2);
24 insert into parent values (2,2,2);
25 commit;
26 delete from child;
27 delete from parent;
28 insert into parent values (1,1,1);
29 begin;
30 insert into child values (1,1,1);
31 begin;
32 delete from parent;
33 commit;
34 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
35 commit;
36 delete from child;
37 delete from parent;
38 alter table child drop foreign key fkname;
39 alter table child add constraint fkname foreign key (b) references parent(a);
40 insert into parent values (1,1,1);
41 insert into child values (1,1,1);
42 insert into child values (2,2,2);
43 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`b`) REFERENCES `parent` (`a`) ON DELETE NO ACTION ON UPDATE NO ACTION)
44 update child set b = 2 where a = 1;
45 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`b`) REFERENCES `parent` (`a`) ON DELETE NO ACTION ON UPDATE NO ACTION)
46 begin;
47 delete from parent;
48 delete from child;
49 commit;
50 begin;
51 insert into child values (2,2,2);
52 insert into parent values (2,2,2);
53 commit;
54 delete from child;
55 delete from parent;
56 insert into parent values (1,1,1);
57 begin;
58 insert into child values (1,1,1);
59 begin;
60 delete from parent;
61 commit;
62 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
63 commit;
64 delete from child;
65 delete from parent;
66 alter table child drop foreign key fkname;
67 alter table child add constraint fkname foreign key (a) references parent(b);
68 insert into parent values (1,1,1);
69 insert into child values (1,1,1);
70 insert into child values (2,2,2);
71 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`a`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
72 update parent set b = 2 where a = 1;
73 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`a`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
74 begin;
75 delete from parent;
76 delete from child;
77 commit;
78 begin;
79 insert into child values (2,2,2);
80 insert into parent values (2,2,2);
81 commit;
82 delete from child;
83 delete from parent;
84 insert into parent values (1,1,1);
85 begin;
86 insert into child values (1,1,1);
87 begin;
88 delete from parent;
89 commit;
90 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
91 commit;
92 delete from child;
93 delete from parent;
94 alter table child drop foreign key fkname;
95 alter table child add constraint fkname foreign key (b) references parent(b);
96 insert into parent values (1,1,1);
97 insert into child values (1,1,1);
98 update child set b = 2 where a = 1;
99 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`b`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
100 insert into child values (2,2,2);
101 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`b`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
102 update parent set b = 2 where a = 1;
103 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`b`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
104 begin;
105 delete from parent;
106 delete from child;
107 commit;
108 begin;
109 insert into child values (2,2,2);
110 insert into parent values (2,2,2);
111 commit;
112 delete from child;
113 delete from parent;
114 insert into parent values (1,1,1);
115 begin;
116 insert into child values (1,1,1);
117 begin;
118 delete from parent;
119 commit;
120 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
121 commit;
122 delete from child;
123 delete from parent;
124 alter table child drop foreign key fkname;
125 alter table child add constraint fkname foreign key (c) references parent(a);
126 insert into parent values (1,1,1);
127 insert into child values (1,1,1);
128 update child set c = 2 where a = 1;
129 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`c`) REFERENCES `parent` (`a`) ON DELETE NO ACTION ON UPDATE NO ACTION)
130 insert into child values (2,2,2);
131 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`c`) REFERENCES `parent` (`a`) ON DELETE NO ACTION ON UPDATE NO ACTION)
132 begin;
133 delete from parent;
134 delete from child;
135 commit;
136 begin;
137 insert into child values (2,2,2);
138 insert into parent values (2,2,2);
139 commit;
140 delete from child;
141 delete from parent;
142 insert into parent values (1,1,1);
143 begin;
144 insert into child values (1,1,1);
145 begin;
146 delete from parent;
147 commit;
148 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
149 commit;
150 delete from child;
151 delete from parent;
152 alter table child drop foreign key fkname;
153 alter table child add constraint fkname foreign key (c) references parent(b);
154 insert into parent values (1,1,1);
155 insert into child values (1,1,1);
156 update child set c = 2 where a = 1;
157 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`c`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
158 insert into child values (2,2,2);
159 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`c`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
160 update parent set b = 2 where a = 1;
161 ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `fkname` FOREIGN KEY (`c`) REFERENCES `parent` (`b`) ON DELETE NO ACTION ON UPDATE NO ACTION)
162 begin;
163 delete from parent;
164 delete from child;
165 commit;
166 begin;
167 insert into child values (2,2,2);
168 insert into parent values (2,2,2);
169 commit;
170 delete from child;
171 delete from parent;
172 insert into parent values (1,1,1);
173 begin;
174 insert into child values (1,1,1);
175 begin;
176 delete from parent;
177 commit;
178 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
179 commit;
180 delete from child;
181 delete from parent;
182 alter table child drop foreign key fkname;
183 drop table parent, child;