Debian Codegraph @

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

raw
1 #
2 # Show the limitations of using a hidden directory on Windows
3 #
4 SET default_storage_engine=InnoDB;
5 CREATE TABLE t1 (a INT);
6 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
7 # Shutdown and make the another directory that is HIDDEN.
8 # Copy ibdata1, test/t1.ibd and ts1.ibd to the hidden directory.
9 # Restart with --innodb-directories=MYSQL_TMP_DIR
10 # The tablespaces in the hidden directory will not be scanned.
11 # restart:--innodb-directories=MYSQL_TMP_DIR
12 SHOW VARIABLES LIKE 'innodb_directories';
13 Variable_name Value
14 innodb_directories MYSQL_TMP_DIR
15 # Show that tablespaces can be built in a HIDDEN directory.
16 # NOTE: This means that a tablespace can be created in a location that cannot be recovered. !!!
17 CREATE TABLE t2 (a INT) DATA DIRECTORY='MYSQL_TMP_DIR/other_dir';
18 CREATE TABLESPACE ts2 ADD DATAFILE 'MYSQL_TMP_DIR/other_dir/ts2.ibd';
19 === information_schema.innodb_tablespaces and innodb_datafiles ===
20 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
21 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
22 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
23 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
24 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
25 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
26 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/other_dir/test/t2.ibd
27 ts1 General DEFAULT 0 1 1 Any ts1.ibd
28 ts2 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/other_dir/ts2.ibd
29 === information_schema.files ===
30 Space_Name File_Type Engine Status Tablespace_Name Path
31 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
32 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
33 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
34 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
35 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
36 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQL_TMP_DIR/other_dir/test/t2.ibd
37 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQLD_DATADIR/ts1.ibd
38 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQL_TMP_DIR/other_dir/ts2.ibd
39 # Shutdown again.
40 # Take off the HIDDEN attribute and add SYSTEM attribute
41 # Make a copy of the new tablespaces in the datadir
42 # restart:--innodb-directories=MYSQL_TMP_DIR
43 # The tablespaces in the hidden directory will not be scanned and the
44 # tablespaces originally created in the hidden directory will be marked
45 # as MOVED to the datadir.
46 === information_schema.innodb_tablespaces and innodb_datafiles ===
47 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
48 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
49 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
50 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
51 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
52 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
53 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t2.ibd
54 ts1 General DEFAULT 0 1 1 Any ts1.ibd
55 ts2 General DEFAULT 0 1 1 Any MYSQLD_DATADIR/ts2.ibd
56 === information_schema.files ===
57 Space_Name File_Type Engine Status Tablespace_Name Path
58 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
59 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
60 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
61 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
62 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
63 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQLD_DATADIR/test/t2.ibd
64 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQLD_DATADIR/ts1.ibd
65 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQLD_DATADIR/ts2.ibd
66 # Use both HIDDEN and SYSTEM attributes
67 # restart:--innodb-directories=MYSQL_TMP_DIR
68 === information_schema.innodb_tablespaces and innodb_datafiles ===
69 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
70 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
71 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
72 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
73 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
74 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
75 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t2.ibd
76 ts1 General DEFAULT 0 1 1 Any ts1.ibd
77 ts2 General DEFAULT 0 1 1 Any MYSQLD_DATADIR/ts2.ibd
78 === information_schema.files ===
79 Space_Name File_Type Engine Status Tablespace_Name Path
80 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
81 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
82 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
83 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
84 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
85 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQLD_DATADIR/test/t2.ibd
86 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQLD_DATADIR/ts1.ibd
87 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQLD_DATADIR/ts2.ibd
88 #
89 # Validate the message that should have been put into the error log.
90 #
91 Pattern "Directory '.*' will not be scanned because it is a hidden directory" found
92 #
93 # Cleanup
94 #
95 DROP TABLE t1;
96 DROP TABLE t2;
97 DROP TABLESPACE ts1;
98 DROP TABLESPACE ts2;