summaryrefslogtreecommitdiff
path: root/storage/innodb_plugin/mysql-test/innodb_bug35220.test
diff options
context:
space:
mode:
Diffstat (limited to 'storage/innodb_plugin/mysql-test/innodb_bug35220.test')
-rw-r--r--storage/innodb_plugin/mysql-test/innodb_bug35220.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/innodb_plugin/mysql-test/innodb_bug35220.test b/storage/innodb_plugin/mysql-test/innodb_bug35220.test
new file mode 100644
index 00000000000..26f7d6b1ddd
--- /dev/null
+++ b/storage/innodb_plugin/mysql-test/innodb_bug35220.test
@@ -0,0 +1,16 @@
+#
+# Bug#35220 ALTER TABLE too picky on reserved word "foreign"
+# http://bugs.mysql.com/35220
+#
+
+-- source include/have_innodb.inc
+
+SET storage_engine=InnoDB;
+
+# we care only that the following SQL commands do not produce errors
+-- disable_query_log
+-- disable_result_log
+
+CREATE TABLE bug35220 (foreign_col INT, dummy_cant_delete_all_columns INT);
+ALTER TABLE bug35220 DROP foreign_col;
+DROP TABLE bug35220;