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:39:28 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2017-01-10 14:39:28 +0200
commitf27ca6f667f21b45325cc0f262f6aa632375be9a (patch)
tree124795f9fb62aa21b1d053535ac2d92fa82069b0 /mysql-test/r/alter_table.result
parent3d46768da2a784ddc9c341d1fb03468525bd38f1 (diff)
parent5044dae239d094582879792de7a762d3428223ce (diff)
downloadmariadb-git-f27ca6f667f21b45325cc0f262f6aa632375be9a.tar.gz
Merge 10.1 into 10.2
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 4cccf861807..c3049ac4adf 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -2089,6 +2089,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
#
#