--source include/have_innodb.inc
|
|
--let $datadir= `select @@datadir`
|
|
SET system_versioning_alter_history= KEEP;
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB WITH SYSTEM VERSIONING;
|
ALTER TABLE t1 ADD b INT;
|
FLUSH TABLES t1 FOR EXPORT;
|
--copy_file $datadir/test/t1.cfg $MYSQLTEST_VARDIR/t1.cfg
|
--copy_file $datadir/test/t1.ibd $MYSQLTEST_VARDIR/t1.ibd
|
UNLOCK TABLES;
|
|
DROP TABLE t1;
|
CREATE TABLE `t1` (
|
`a` int(11) DEFAULT NULL,
|
`b` int(11) DEFAULT NULL
|
) ENGINE=InnoDB WITH SYSTEM VERSIONING;
|
|
ALTER TABLE t1 DISCARD TABLESPACE;
|
--copy_file $MYSQLTEST_VARDIR/t1.cfg $datadir/test/t1.cfg
|
--copy_file $MYSQLTEST_VARDIR/t1.ibd $datadir/test/t1.ibd
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
# Cleanup
|
DROP TABLE t1;
|