Debian Codegraph @

mysql-test/suite/wsrep/r/foreign_key.result

raw
1 USE test;
2 create table p(v varchar(20), i int, primary key(v,i)) engine=innodb character set = utf8;
3 create table c(k int primary key, v varchar(20), i int, foreign key(v,i) references p(v,i)) engine=innodb character set = utf8;
4 insert into p values (_utf32 0x000004100000041100000412, 1);
5 insert into c values (1, _utf32 0x000004100000041100000412, 1);
6 SELECT * FROM test.p;
7 v i
8 ??? 1
9 SELECT * FROM test.c;
10 k v i
11 1 ??? 1
12 SELECT * FROM test.p;
13 v i
14 ??? 1
15 SELECT * FROM test.c;
16 k v i
17 1 ??? 1
18 DROP TABLE c;
19 DROP TABLE p;