Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
--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; |
10.3 efdbb3cf |
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) |
If the test is run with --mysqld=--alter-algorithm=copy, it passes.
Attachments
Issue Links
- relates to
-
MDEV-29144 ER_TABLE_SCHEMA_MISMATCH or InnoDB: Failing assertion: index != 0 upon IMPORT TABLESPACE
- Closed