--source include/have_innodb.inc

--let $datadir= `select @@datadir`

CREATE TABLE `t` (

  `pk` int(11) NOT NULL,

  `a` char(32) DEFAULT NULL,

  `b` bigint(20) DEFAULT NULL,

  PRIMARY KEY (`pk`),

  KEY `ind` (`a`(8))

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE OR REPLACE INDEX ind ON t(b);

FLUSH TABLES t FOR EXPORT;

--copy_file $datadir/test/t.ibd $datadir/test/t.ibd.save

--copy_file $datadir/test/t.cfg $datadir/test/t.cfg.save

UNLOCK TABLES;

DROP TABLE t;

CREATE TABLE `t` (

  `pk` int(11) NOT NULL,

  `a` char(32) DEFAULT NULL,

  `b` bigint(20) DEFAULT NULL,

  PRIMARY KEY (`pk`),

  KEY `ind` (`b`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE t DISCARD TABLESPACE;

--move_file $datadir/test/t.ibd.save $datadir/test/t.ibd

--move_file $datadir/test/t.cfg.save $datadir/test/t.cfg

ALTER TABLE t IMPORT TABLESPACE;

# Cleanup

DROP TABLE t;

mysqltest: At line 35: query 'ALTER TABLE t IMPORT TABLESPACE' failed: 1808: Schema mismatch (Column a max prefix mismatch it's 0 in the table and 8 in the tablespace meta file)