~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

• browse files at revision 1841.1.7
• compare with another revision
• compare with revision 2165.1.3
• download diff
• download tarball
• view history from revision 1841.1.7

Show diffs side-by-side

added

removed

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;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1