EVOLUTION-MANAGER

Edit File: innodb-bug-14084530.test

-- source include/have_innodb.inc let MYSQLD_DATADIR =`SELECT @@datadir`; SET AUTOCOMMIT = 0; # Export/import on the same instance, with --innodb-file-per-table=1 CREATE DATABASE testdb_wl5522; CREATE TABLE testdb_wl5522.t1 (c1 int ) engine = Innodb; BEGIN; INSERT INTO testdb_wl5522.t1 VALUES (1),(123),(331); ROLLBACK; SELECT c1 FROM testdb_wl5522.t1; FLUSH TABLES testdb_wl5522.t1 FOR EXPORT; perl; do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl"; ib_backup_tablespaces("testdb_wl5522", "t1"); EOF UNLOCK TABLES; DROP TABLE testdb_wl5522.t1; CREATE TABLE testdb_wl5522.t1 (c1 int ) ENGINE = Innodb; ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE; perl; do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl"; ib_discard_tablespaces("testdb_wl5522", "t1"); ib_restore_tablespaces("testdb_wl5522", "t1"); EOF ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE; CHECK TABLE testdb_wl5522.t1; SELECT c1 FROM testdb_wl5522.t1; DROP DATABASE testdb_wl5522;