diff options
author | Jan Lindström <jplindst@mariadb.org> | 2014-07-04 11:59:09 +0300 |
---|---|---|
committer | Jan Lindström <jplindst@mariadb.org> | 2014-07-04 11:59:09 +0300 |
commit | 3d1ac121771d61f9d1c944a1caa4e449527725fc (patch) | |
tree | 954f9a1a1281c3a88126abd2fb70e1041a69f4af /mysql-test/suite/wsrep/t/foreign_key.test | |
parent | 84b3ec1fa4291c792cd63b70a4305e744b12eee4 (diff) | |
download | mariadb-git-3d1ac121771d61f9d1c944a1caa4e449527725fc.tar.gz |
Add test case for
https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1314854
Diffstat (limited to 'mysql-test/suite/wsrep/t/foreign_key.test')
-rw-r--r-- | mysql-test/suite/wsrep/t/foreign_key.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/wsrep/t/foreign_key.test b/mysql-test/suite/wsrep/t/foreign_key.test new file mode 100644 index 00000000000..87eb4a88115 --- /dev/null +++ b/mysql-test/suite/wsrep/t/foreign_key.test @@ -0,0 +1,19 @@ +--source include/have_wsrep_enabled.inc +--source include/have_innodb.inc + +USE test; +create table p(v varchar(20), i int, primary key(v,i)) engine=innodb character set = utf8; +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; +insert into p values (_utf32 0x000004100000041100000412, 1); +insert into c values (1, _utf32 0x000004100000041100000412, 1); + +SELECT * FROM test.p; +SELECT * FROM test.c; + +SELECT * FROM test.p; +SELECT * FROM test.c; + +# Cleanup +DROP TABLE c; +DROP TABLE p; + |