Debian Codegraph @

mysql-test/suite/wsrep/t/foreign_key.test

raw
1 --source include/have_wsrep_enabled.inc
2 --source include/have_binlog_format_row.inc
3 --source include/have_innodb.inc
4
5 USE test;
6 create table p(v varchar(20), i int, primary key(v,i)) engine=innodb character set = utf8;
7 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;
8 insert into p values (_utf32 0x000004100000041100000412, 1);
9 insert into c values (1, _utf32 0x000004100000041100000412, 1);
10
11 SELECT * FROM test.p;
12 SELECT * FROM test.c;
13
14 SELECT * FROM test.p;
15 SELECT * FROM test.c;
16
17 # Cleanup
18 DROP TABLE c;
19 DROP TABLE p;