Debian Codegraph @

mysql-test/suite/galera/r/galera_fk_multibyte.result

raw
1 connection node_2;
2 connection node_1;
3 create table p (i varchar(100) primary key, j int) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4 create table c1 (i int primary key auto_increment, j varchar(100), k int, key(j), constraint fk1 foreign key (j) references p(i)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5 create table c2 (i int primary key auto_increment, j varchar(100), k int, key(j), constraint fk2 foreign key (j) references p(i)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
6 insert into p values('sippo',1);
7 insert into c1 values(1,'sippo',1);
8 insert into c2 values(1,'sippo',1);
9 update c1 set k = 100 where j = 'sippo';
10 insert into c1 values(2,'sippo',1);
11 select * from p;
12 i j
13 sippo 1
14 select * from c1;
15 i j k
16 1 sippo 100
17 2 sippo 1
18 select * from c2;
19 i j k
20 1 sippo 1
21 connection node_2;
22 select * from p;
23 i j
24 sippo 1
25 select * from c1;
26 i j k
27 1 sippo 100
28 2 sippo 1
29 select * from c2;
30 i j k
31 1 sippo 1
32 connection node_1;
33 drop table c1;
34 drop table c2;
35 drop table p;