← 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: Stewart Smith
  • Date: 2010-04-08 07:20:26 UTC
  • mto: This revision was merged to the branch mainline in revision 1456.
  • Revision ID: stewart@flamingspork.com-20100408072026-w3s8zblhs35uo5mg
https://launchpad.net/bugs/557880
remove CHECKSUM TABLE

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
 
# Please also refer to related fix in
5
 
# http://bugs.mysql.com/47621
6
 
#
7
 
 
8
 
CREATE TABLE bug44571 (foo INT) ENGINE=InnoDB;
9
 
ALTER TABLE bug44571 CHANGE foo bar INT;
10
 
# Create index with the old column name will fail,
11
 
# because the CHANGE foo bar is successful. And
12
 
# the column name change would communicate to
13
 
# InnoDB with the fix from bug #47621
14
 
ALTER TABLE bug44571 ADD INDEX bug44571b (foo);
15
 
# The following create indexes should succeed,
16
 
# indirectly confirm the CHANGE foo bar is successful.
17
 
ALTER TABLE bug44571 ADD INDEX bug44571c (bar);
18
 
DROP INDEX bug44571c ON bug44571;
19
 
CREATE INDEX bug44571c ON bug44571 (bar);
20
 
DROP TABLE bug44571;