← 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: Joseph Daly
  • Date: 2010-10-24 03:19:07 UTC
  • mto: (1856.2.16 transaction_id_innodb)
  • mto: This revision was merged to the branch mainline in revision 1900.
  • Revision ID: skinny.moey@gmail.com-20101024031907-cnkdjmjycx62jsv0
create schema changes

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/mysql-test/innodb_bug44571.test
1
1
#
2
2
# Bug#44571 InnoDB Plugin crashes on ADD INDEX
3
3
# http://bugs.mysql.com/44571
4
 
# Please also refer to related fix in
5
 
# http://bugs.mysql.com/47621
6
4
#
7
5
-- source include/have_innodb.inc
8
6
 
9
7
CREATE TABLE bug44571 (foo INT) ENGINE=InnoDB;
10
8
ALTER TABLE bug44571 CHANGE foo bar INT;
11
 
# Create index with the old column name will fail,
12
 
# because the CHANGE foo bar is successful. And
13
 
# the column name change would communicate to
14
 
# InnoDB with the fix from bug #47621
15
9
-- error ER_KEY_COLUMN_DOES_NOT_EXITS
16
10
ALTER TABLE bug44571 ADD INDEX bug44571b (foo);
17
 
# The following create indexes should succeed,
18
 
# indirectly confirm the CHANGE foo bar is successful.
19
 
ALTER TABLE bug44571 ADD INDEX bug44571c (bar);
20
 
DROP INDEX bug44571c ON bug44571;
21
 
CREATE INDEX bug44571c ON bug44571 (bar);
 
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);
22
17
DROP TABLE bug44571;