← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/mysql-test/innodb_bug44571.test

  • Committer: Brian Aker
  • Date: 2010-11-08 18:24:58 UTC
  • mto: (1921.1.1 trunk)
  • mto: This revision was merged to the branch mainline in revision 1916.
  • Revision ID: brian@tangent.org-20101108182458-twv4hyix43ojno80
Merge in changes such that lock is now broken out into its own directory.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/mysql-test/innodb_bug44571.test
 
1
#
 
2
# Bug#44571 InnoDB Plugin crashes on ADD INDEX
 
3
# http://bugs.mysql.com/44571
 
4
#
 
5
-- source include/have_innodb.inc
 
6
 
 
7
CREATE TABLE bug44571 (foo INT) ENGINE=InnoDB;
 
8
ALTER TABLE bug44571 CHANGE foo bar INT;
 
9
-- error ER_KEY_COLUMN_DOES_NOT_EXITS
 
10
ALTER TABLE bug44571 ADD INDEX bug44571b (foo);
 
11
# The following will fail, because the CHANGE foo bar was
 
12
# not communicated to InnoDB.
 
13
--error ER_NOT_KEYFILE
 
14
ALTER TABLE bug44571 ADD INDEX bug44571b (bar);
 
15
--error ER_NOT_KEYFILE
 
16
CREATE INDEX bug44571b ON bug44571 (bar);
 
17
DROP TABLE bug44571;