~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to storage/innobase/mysql-test/innodb_bug35220.test

  • Committer: Elan Ruusamäe
  • Date: 2008-12-04 19:38:26 UTC
  • mfrom: (644 drizzle)
  • mto: (641.3.10 devel)
  • mto: This revision was merged to the branch mainline in revision 649.
  • Revision ID: glen@haarber.alkohol.ee-20081204193826-xxyhd45ag121pf3z
- pull from trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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.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;