Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug14169459.result

raw
1 SET default_storage_engine=InnoDB;
2 SET GLOBAL innodb_file_per_table=ON;
3 #
4 # Create a temporary table and drop it. Make sure the ibd file is gone.
5 # Make sure a discarded table can be dropped with all files deleted.
6 #
7 CREATE TEMPORARY TABLE t14169459_1 (a INT, b TEXT) engine=InnoDB;
8 CREATE TABLE t14169459_2 (a INT, b TEXT) engine=InnoDB;
9 INSERT INTO t14169459_1 VALUES (1, 'one'),(2, 'two');
10 INSERT INTO t14169459_2 VALUES (1, 'one'),(2, 'two');
11 SELECT * FROM t14169459_1;
12 a b
13 1 one
14 2 two
15 SELECT * FROM t14169459_2;
16 a b
17 1 one
18 2 two
19 SHOW CREATE TABLE t14169459_1;
20 Table Create Table
21 t14169459_1 CREATE TEMPORARY TABLE `t14169459_1` (
22 `a` int DEFAULT NULL,
23 `b` text
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 SHOW CREATE TABLE t14169459_2;
26 Table Create Table
27 t14169459_2 CREATE TABLE `t14169459_2` (
28 `a` int DEFAULT NULL,
29 `b` text
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 ### directory of MYSQL_DATA_DIR/test
32 t14169459_2.ibd
33 ### directory of MYSQL_TMP_DIR/mysqld.1
34 FLUSH TABLES t14169459_2 FOR EXPORT;
35 SELECT * FROM t14169459_2;
36 a b
37 1 one
38 2 two
39 UNLOCK TABLES;
40 ### directory of MYSQL_DATA_DIR/test
41 t14169459_2.ibd
42 ALTER TABLE t14169459_2 DISCARD TABLESPACE;
43 SELECT * FROM t14169459_2;
44 ERROR HY000: Tablespace has been discarded for table 't14169459_2'
45 ### directory of MYSQL_DATA_DIR/test
46 ### directory of MYSQL_TMP_DIR/mysqld.1
47 DROP TABLE t14169459_1;
48 DROP TABLE t14169459_2;
49 ### directory of MYSQL_DATA_DIR/test
50 ### directory of MYSQL_TMP_DIR/mysqld.1