Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug14169459.test

raw
1 # This is the test for bug #14169459.
2
3
4 SET default_storage_engine=InnoDB;
5
6 --disable_query_log
7 # These values can change during the test
8 LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`;
9
10 # Set up some variables
11 LET $MYSQL_DATA_DIR = `select @@datadir`;
12 --enable_query_log
13
14 SET GLOBAL innodb_file_per_table=ON;
15
16 --echo #
17 --echo # Create a temporary table and drop it. Make sure the ibd file is gone.
18 --echo # Make sure a discarded table can be dropped with all files deleted.
19 --echo #
20 CREATE TEMPORARY TABLE t14169459_1 (a INT, b TEXT) engine=InnoDB;
21 CREATE TABLE t14169459_2 (a INT, b TEXT) engine=InnoDB;
22
23 INSERT INTO t14169459_1 VALUES (1, 'one'),(2, 'two');
24 INSERT INTO t14169459_2 VALUES (1, 'one'),(2, 'two');
25 SELECT * FROM t14169459_1;
26 SELECT * FROM t14169459_2;
27 SHOW CREATE TABLE t14169459_1;
28 SHOW CREATE TABLE t14169459_2;
29
30 --echo ### directory of MYSQL_DATA_DIR/test
31 --list_files $MYSQL_DATA_DIR/test
32 --echo ### directory of MYSQL_TMP_DIR/mysqld.1
33 --replace_regex /#sql[0-9a-f_]*/#sql<temporary>/
34 --list_files $MYSQL_TMP_DIR/mysqld.1 *.ibd
35
36 FLUSH TABLES t14169459_2 FOR EXPORT;
37 SELECT * FROM t14169459_2;
38 UNLOCK TABLES;
39 --echo ### directory of MYSQL_DATA_DIR/test
40 --list_files $MYSQL_DATA_DIR/test
41 ALTER TABLE t14169459_2 DISCARD TABLESPACE;
42 --error ER_TABLESPACE_DISCARDED
43 SELECT * FROM t14169459_2;
44 --echo ### directory of MYSQL_DATA_DIR/test
45 --list_files $MYSQL_DATA_DIR/test
46 --echo ### directory of MYSQL_TMP_DIR/mysqld.1
47 --replace_regex /#sql[0-9a-f_]*/#sql<temporary>/
48 --list_files $MYSQL_TMP_DIR/mysqld.1 *.ibd
49
50 #--file_exists $MYSQL_TMP_DIR/mysqld.1/#sql15f8_2_1.ibd
51
52 DROP TABLE t14169459_1;
53 DROP TABLE t14169459_2;
54 --echo ### directory of MYSQL_DATA_DIR/test
55 --list_files $MYSQL_DATA_DIR/test
56 --echo ### directory of MYSQL_TMP_DIR/mysqld.1
57 --replace_regex /#sql[0-9a-f_]*/#sql<temporary>/
58 --list_files $MYSQL_TMP_DIR/mysqld.1 *.ibd
59
60 -- disable_query_log
61 eval set global innodb_file_per_table=$innodb_file_per_table_orig;
62 -- enable_query_log