diff options
| author | Mattias Jonsson <mattias.jonsson@sun.com> | 2010-03-11 14:25:33 +0100 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2010-03-11 14:25:33 +0100 |
| commit | 8e2ea6efa965a66485e07619beeaca7a7de99ea4 (patch) | |
| tree | d05bb9256a2eb7c2a4e81f4cad6a5b382c5e23c6 /mysql-test/r | |
| parent | cb6d0e3cac9744e042c311d945f65e367e27005b (diff) | |
| parent | 6e7539de29b2225c742a87b1866b631e15ab9b5f (diff) | |
| download | mariadb-git-8e2ea6efa965a66485e07619beeaca7a7de99ea4.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/partition_innodb.result | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/mysql-test/r/partition_innodb.result b/mysql-test/r/partition_innodb.result index f2f6ef138ff..6167b4cef95 100644 --- a/mysql-test/r/partition_innodb.result +++ b/mysql-test/r/partition_innodb.result @@ -1,4 +1,24 @@ -drop table if exists t1; +drop table if exists t1, t2; +# +# Bug#50104: Partitioned table with just 1 partion works with fk +# +CREATE TABLE t2 ( +id INT, +PRIMARY KEY (id) +) ENGINE=InnoDB ; +CREATE TABLE t1 ( +id INT NOT NULL AUTO_INCREMENT, +parent_id INT DEFAULT NULL, +PRIMARY KEY (id), +KEY parent_id (parent_id) +) ENGINE=InnoDB; +ALTER TABLE t1 PARTITION BY HASH (id) PARTITIONS 1; +ALTER TABLE t1 ADD CONSTRAINT test_ibfk_1 FOREIGN KEY (parent_id) REFERENCES t2 (id); +ERROR HY000: Foreign key clause is not yet supported in conjunction with partitioning +ALTER TABLE t1 PARTITION BY HASH (id) PARTITIONS 2; +ALTER TABLE t1 ADD CONSTRAINT test_ibfk_1 FOREIGN KEY (parent_id) REFERENCES t2 (id); +ERROR HY000: Foreign key clause is not yet supported in conjunction with partitioning +DROP TABLE t1, t2; create table t1 (a int not null, b datetime not null, primary key (a,b)) |