diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-04-24 12:03:11 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-04-24 12:03:11 +0300 |
| commit | bfb0726fc24acb896e54bc7ef7536ad1aab9d574 (patch) | |
| tree | a48e5d91d8427fefe2121128a4b3416d8d76e8a3 /mysql-test/suite/innodb/t/foreign_key.test | |
| parent | 9dcfd6be94bd83d14fd48d69ce487eb0ea3fe37f (diff) | |
| parent | d5da8ae04d57556f517c0f03afeafe73c6cc75d1 (diff) | |
| download | mariadb-git-bfb0726fc24acb896e54bc7ef7536ad1aab9d574.tar.gz | |
Merge 5.5 into 10.1
Diffstat (limited to 'mysql-test/suite/innodb/t/foreign_key.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/foreign_key.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/foreign_key.test b/mysql-test/suite/innodb/t/foreign_key.test index f4117d2d780..08fe44911b5 100644 --- a/mysql-test/suite/innodb/t/foreign_key.test +++ b/mysql-test/suite/innodb/t/foreign_key.test @@ -125,3 +125,12 @@ ALTER IGNORE TABLE t1 ADD FOREIGN KEY (a) REFERENCES t2 (b); --replace_regex /#sql-[0-9_a-f-]*/#sql-temporary/ SHOW WARNINGS; DROP TABLE t1; + +--echo # +--echo # MDEV-18139 ALTER IGNORE ... ADD FOREIGN KEY causes bogus error +--echo # +CREATE TABLE t1 (f1 INT, f2 INT, f3 INT, KEY(f1)) ENGINE=InnoDB; +CREATE TABLE t2 (f INT, KEY(f)) ENGINE=InnoDB; +ALTER TABLE t1 ADD FOREIGN KEY (f2) REFERENCES t2 (f); +ALTER IGNORE TABLE t1 ADD FOREIGN KEY (f3) REFERENCES t1 (f1); +DROP TABLE t1, t2; |