summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2017-01-10 14:30:11 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2017-01-10 14:30:11 +0200
commit5044dae239d094582879792de7a762d3428223ce (patch)
treede7baaf095317ab19949f4e7fa205cf9dce44ab8 /mysql-test/r/alter_table.result
parent4b05d60e62ef6e21d5329a9667813df890034ff0 (diff)
parent78e6fafcaa93bdd2cf793a82a812137eb7a779a7 (diff)
downloadmariadb-git-5044dae239d094582879792de7a762d3428223ce.tar.gz
Merge 10.0 into 10.1
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r--mysql-test/r/alter_table.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 921d108c404..d203c3d99bd 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -2086,6 +2086,21 @@ tab1 CREATE TABLE `tab1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE `tab1`;
#
+# MDEV-11548 Reproducible server crash after the 2nd ALTER TABLE ADD FOREIGN KEY IF NOT EXISTS
+#
+CREATE TABLE t1 (id INT UNSIGNED NOT NULL PRIMARY KEY);
+CREATE TABLE t2 (id1 INT UNSIGNED NOT NULL);
+ALTER TABLE t2
+ADD FOREIGN KEY IF NOT EXISTS (id1)
+REFERENCES t1 (id);
+ALTER TABLE t2
+ADD FOREIGN KEY IF NOT EXISTS (id1)
+REFERENCES t1 (id);
+Warnings:
+Note 1061 Duplicate key name 'id1'
+DROP TABLE t2;
+DROP TABLE t1;
+#
# Start of 10.1 tests
#
#