130112  5:18:59 [ERROR] Found index PRIMARY whose column info does not match that of MySQL.

130112  5:18:59 [ERROR] Build InnoDB index translation table for Table ./test/t_enum failed

130112  5:18:59 [ERROR] Found index PRIMARY whose column info does not match that of MySQL.

130112  5:18:59 [ERROR] Build InnoDB index translation table for Table ./test/t_set failed

130112  5:18:59 [ERROR] Found index PRIMARY whose column info does not match that of MySQL.

130112  5:18:59 [ERROR] Build InnoDB index translation table for Table ./test/t_year failed

130112  5:18:59 [ERROR] Found index PRIMARY whose column info does not match that of MySQL.

130112  5:18:59 [ERROR] Build InnoDB index translation table for Table ./test/t_year2 failed

# Run as mysql-test-run.pl --mysqld=--innodb <test name>

# (assuming that XtraDB is built in, and InnoDB exists as a plugin ha_innodb.so)

CREATE TABLE t_int (f1 INT PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_smallint (f1 SMALLINT PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_tinyint (f1 TINYINT PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_mediumint (f1 MEDIUMINT PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_bigint (f1 BIGINT PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_numeric (f1 NUMERIC(6,2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_decimal (f1 DECIMAL(6,2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_float (f1 FLOAT(6,2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_double (f1 DOUBLE(6,2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_bit (f1 BIT(2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_date (f1 DATE PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_datetime (f1 DATETIME PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_datetime4 (f1 DATETIME(4) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_timestamp (f1 TIMESTAMP PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_timestamp3 (f1 TIMESTAMP(3) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_time (f1 TIME PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_time2 (f1 TIME(2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_year (f1 YEAR PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_year2 (f1 YEAR(2) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_char (f1 CHAR(3) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_varchar (f1 VARCHAR(8) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_binary (f1 BINARY(3) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_varbinary (f1 VARBINARY(3) PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_enum (f1 ENUM('a','b') PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_set (f1 SET('a','b') PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE t_text (f1 TEXT, PRIMARY KEY (f1(256))) ENGINE=InnoDB;

CREATE TABLE t_blob (f1 BLOB, PRIMARY KEY (f1(256))) ENGINE=InnoDB;

let $expect_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;

--error 0,1

--remove_file $expect_file

--write_file $expect_file

wait

EOF

--echo #

--echo # Shutdown the server

--echo #

--shutdown_server 10

--source include/wait_until_disconnected.inc

--append_file $expect_file

restart: --ignore-builtin-innodb --plugin-load=ha_innodb.so --innodb 

EOF

--enable_reconnect

--source include/wait_until_connected_again.inc

--echo #

--echo # Run mysql_upgrade

--echo #

--exec $MYSQL_UPGRADE -uroot

SHOW CREATE TABLE t_int;

SHOW CREATE TABLE t_smallint;

SHOW CREATE TABLE t_tinyint;

SHOW CREATE TABLE t_mediumint;

SHOW CREATE TABLE t_bigint;

SHOW CREATE TABLE t_numeric;

SHOW CREATE TABLE t_decimal;

SHOW CREATE TABLE t_float;

SHOW CREATE TABLE t_double;

SHOW CREATE TABLE t_bit;

SHOW CREATE TABLE t_date;

SHOW CREATE TABLE t_datetime;

SHOW CREATE TABLE t_datetime4;

SHOW CREATE TABLE t_timestamp;

SHOW CREATE TABLE t_timestamp3;

SHOW CREATE TABLE t_time;

SHOW CREATE TABLE t_time2;

SHOW CREATE TABLE t_year;

SHOW CREATE TABLE t_year2;

SHOW CREATE TABLE t_char;

SHOW CREATE TABLE t_varchar;

SHOW CREATE TABLE t_binary;

SHOW CREATE TABLE t_varbinary;

SHOW CREATE TABLE t_enum;

SHOW CREATE TABLE t_set;

SHOW CREATE TABLE t_text;

SHOW CREATE TABLE t_blob;