release/src/router/mysql/mysql-test/suite/innodb_plugin/t/innodb_bug35220.test

   1 #
   2 # Bug#35220 ALTER TABLE too picky on reserved word "foreign"
   3 # http://bugs.mysql.com/35220
   4 #
   5
   6 -- source include/have_innodb_plugin.inc
   7
   8 SET storage_engine=InnoDB;
   9
  10 # we care only that the following SQL commands do not produce errors
  11 -- disable_query_log
  12 -- disable_result_log
  13
  14 CREATE TABLE bug35220 (foreign_col INT, dummy_cant_delete_all_columns INT);
  15 ALTER TABLE bug35220 DROP foreign_col;
  16 DROP TABLE bug35220;