~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2008-10-28 08:36:02 UTC
  • mfrom: (520.4.13 merge-innodb-plugin)
  • Revision ID: brian@tangent.org-20081028083602-0p3zzlhlxr5q2sqo
Merging Monty's work

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;