EVOLUTION-MANAGER

Edit File: instant_alter_import.test

--source include/have_innodb.inc
set default_storage_engine=innodb;

--echo #
--echo # MDEV-18295 IMPORT TABLESPACE fails with instant-altered tables
--echo #

create table t2 (x int, z int default 41);
alter table t2 discard tablespace;

create table t1 (x int);
insert into t1 values (1);
alter table t1 add z int default 42, algorithm instant;
select * from t1;
flush tables t1 for export;
--let $MYSQLD_DATADIR= `select @@datadir`
--move_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
--copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
unlock tables;

--echo # The metadata has to be updated to instant ADD COLUMN.
alter table t2 import tablespace;

select * from t2;
insert into t2 set x=2;
select * from t2;

alter table t1 discard tablespace;
flush tables t2 for export;
--move_file $MYSQLD_DATADIR/test/t2.cfg $MYSQLD_DATADIR/test/t1.cfg
--copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t1.ibd
unlock tables;

--echo # Both the metadata and the data file used instant ADD COLUMN.
alter table t1 import tablespace;
select * from t1;

drop table t2;
create table t2 select * from t1;

--echo # The instant ADD COLUMN has to be removed from the metadata.
alter table t1 import tablespace;
select * from t1;

drop table t2;
drop table t1;