summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb.result
diff options
context:
space:
mode:
authorunknown <osku@127.(none)>2005-09-06 16:08:05 +0300
committerunknown <osku@127.(none)>2005-09-06 16:08:05 +0300
commitd17b361e8e2127f19930c709bfeb02f3201e6a57 (patch)
tree4901bbdd8c3923b75b0f54d7cef109b81539bb2a /mysql-test/r/innodb.result
parent2d1c26cc61f83a6d3522fa677c8e7d6d0a89732c (diff)
downloadmariadb-git-d17b361e8e2127f19930c709bfeb02f3201e6a57.tar.gz
Add testcase for bug #12084.
Diffstat (limited to 'mysql-test/r/innodb.result')
-rw-r--r--mysql-test/r/innodb.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index d7f7536d401..cc074c8ebf5 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -2527,3 +2527,15 @@ SELECT * FROM t1;
id
1
DROP TABLE t2, t1;
+CREATE TABLE t1
+(
+id INT PRIMARY KEY
+) ENGINE=InnoDB;
+CREATE TEMPORARY TABLE t2
+(
+id INT NOT NULL PRIMARY KEY,
+b INT,
+FOREIGN KEY (b) REFERENCES test.t1(id)
+) ENGINE=InnoDB;
+Got one of the listed errors
+DROP TABLE t1;