Debian Codegraph @

mysql-test/suite/innodb/t/innodb-bug-14084530.test

raw
1 -- source include/have_innodb.inc
2
3 let MYSQLD_DATADIR =`SELECT @@datadir`;
4
5 SET AUTOCOMMIT = 0;
6
7 # Export/import on the same instance
8 CREATE DATABASE testdb_wl5522;
9 CREATE TABLE testdb_wl5522.t1 (c1 int ) engine = Innodb;
10
11 BEGIN;
12 INSERT INTO testdb_wl5522.t1 VALUES (1),(123),(331);
13 ROLLBACK;
14
15 SELECT c1 FROM testdb_wl5522.t1;
16
17 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
18 perl;
19 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
20 ib_backup_tablespaces("testdb_wl5522", "t1");
21 EOF
22 UNLOCK TABLES;
23
24 DROP TABLE testdb_wl5522.t1;
25
26 CREATE TABLE testdb_wl5522.t1 (c1 int ) ENGINE = Innodb;
27 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
28
29 perl;
30 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
31 ib_discard_tablespaces("testdb_wl5522", "t1");
32 ib_restore_tablespaces("testdb_wl5522", "t1");
33 EOF
34
35 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
36 CHECK TABLE testdb_wl5522.t1;
37 SELECT c1 FROM testdb_wl5522.t1;
38
39 DROP DATABASE testdb_wl5522;