Debian Codegraph @

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

raw
1 #
2 # Show that two locations in --innodb-directories that differ by only by case
3 # are recognized as the same on case insensitive file systems.
4 #
5 ##########
6 # Restart with the data_home_dir the same as the datadir except for case.
7 # On case insensitive file systems they should be recognized as the same location.
8 ##########
9 # restart: --innodb-directories='MYSQL_TMP_DIR/Known_Dir' --innodb-data-home-dir=../DATA
10 SET default_storage_engine=InnoDB;
11 SHOW VARIABLES LIKE 'lower_case_file_system';
12 Variable_name Value
13 lower_case_file_system ON
14 # Create a table in a known directory.
15 CREATE TABLE t1(c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/Known_Dir';
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` int DEFAULT NULL
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/Known_Dir/'
21 # Create a general tablespace in a known directory.
22 CREATE TABLESPACE ts1 ADD DATAFILE 'MYSQL_TMP_DIR/Known_Dir/ts1.ibd';
23 ##########
24 # Restart with two identical known directories except for Case.
25 # On case insensitive file systems they should be recognized as the same location.
26 ##########
27 # restart: --innodb-directories='MYSQL_TMP_DIR/known_dir;MYSQL_TMP_DIR/Known_Dir;MYSQL_TMP_DIR/KNOWN_DIR'
28 # Show these tablespaces in information_schema.
29 === information_schema.innodb_tablespaces and innodb_datafiles ===
30 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
31 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
32 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
33 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
34 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
35 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/Known_Dir/test/t1.ibd
36 ts1 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/Known_Dir/ts1.ibd
37 === information_schema.files ===
38 Space_Name File_Type Engine Status Tablespace_Name Path
39 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
40 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
41 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
42 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
43 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQL_TMP_DIR/Known_Dir/test/t1.ibd
44 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQL_TMP_DIR/Known_Dir/ts1.ibd
45 # Create an inplicit tablespace using UPPER case for a MIXED case folder.
46 CREATE TABLE t2(c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/KNOWN_DIR';
47 SHOW CREATE TABLE t2;
48 Table Create Table
49 t2 CREATE TABLE `t2` (
50 `c1` int DEFAULT NULL
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/KNOWN_DIR/'
52 # Create an inplicit tablespace using LOWER case for a MIXED case folder.
53 CREATE TABLE t3(c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/known_dir';
54 SHOW CREATE TABLE t3;
55 Table Create Table
56 t3 CREATE TABLE `t3` (
57 `c1` int DEFAULT NULL
58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/known_dir/'
59 # Create a general tablespace using UPPER case for a MIXED case folder.
60 CREATE TABLESPACE ts2 ADD DATAFILE 'MYSQL_TMP_DIR/KNOWN_DIR/ts2.ibd';
61 # Create a general tablespace using LOWER case for a MIXED case folder.
62 CREATE TABLESPACE ts3 ADD DATAFILE 'MYSQL_TMP_DIR/known_dir/ts3.ibd';
63 # Show these tablespaces in information_schema.
64 === information_schema.innodb_tablespaces and innodb_datafiles ===
65 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
66 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
67 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
68 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
69 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
70 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/Known_Dir/test/t1.ibd
71 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/KNOWN_DIR/test/t2.ibd
72 test/t3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/t3.ibd
73 ts1 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/Known_Dir/ts1.ibd
74 ts2 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/KNOWN_DIR/ts2.ibd
75 ts3 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/known_dir/ts3.ibd
76 === information_schema.files ===
77 Space_Name File_Type Engine Status Tablespace_Name Path
78 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
79 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
80 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
81 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
82 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQL_TMP_DIR/Known_Dir/test/t1.ibd
83 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQL_TMP_DIR/KNOWN_DIR/test/t2.ibd
84 test/t3 TABLESPACE InnoDB NORMAL test/t3 MYSQL_TMP_DIR/known_dir/test/t3.ibd
85 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQL_TMP_DIR/Known_Dir/ts1.ibd
86 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQL_TMP_DIR/KNOWN_DIR/ts2.ibd
87 ts3 TABLESPACE InnoDB NORMAL ts3 MYSQL_TMP_DIR/known_dir/ts3.ibd
88 #
89 # Cleanup
90 #
91 DROP TABLE t1;
92 DROP TABLE t2;
93 DROP TABLE t3;
94 DROP TABLESPACE ts1;
95 DROP TABLESPACE ts2;
96 DROP TABLESPACE ts3;