Debian Codegraph @

mysql-test/suite/innodb/include/tablespace_filenames.inc

raw
1 # Remember some variables.
2 LET $MYSQLD_DATADIR = `select @@datadir`;
3 LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`;
4
5 --echo #
6 --echo # Try a series of invalid relative ADD DATAFILE entries.
7 --echo # General tablespace files can be in the datadir but they cannot be under the datadir.
8 --echo #
9 --error ER_WRONG_FILE_NAME
10 CREATE TABLESPACE bad ADD DATAFILE '';
11 SHOW WARNINGS;
12 --error ER_WRONG_FILE_NAME
13 CREATE TABLESPACE bad ADD DATAFILE '.ibd';
14 SHOW WARNINGS;
15 --error ER_WRONG_FILE_NAME
16 CREATE TABLESPACE bad ADD DATAFILE './ibd';
17 SHOW WARNINGS;
18 --error ER_WRONG_FILE_NAME
19 CREATE TABLESPACE bad ADD DATAFILE './.ibd';
20 SHOW WARNINGS;
21 --error ER_WRONG_FILE_NAME
22 CREATE TABLESPACE bad ADD DATAFILE '../spaces/';
23 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
24 SHOW WARNINGS;
25 --error ER_WRONG_FILE_NAME
26 CREATE TABLESPACE bad ADD DATAFILE 'test/bad.ibd';
27 SHOW WARNINGS;
28 --error ER_WRONG_FILE_NAME
29 CREATE TABLESPACE bad ADD DATAFILE './test/bad.ibd';
30 SHOW WARNINGS;
31 --error ER_WRONG_FILE_NAME
32 CREATE TABLESPACE bad ADD DATAFILE './test//bad.ibd';
33 SHOW WARNINGS;
34 --error ER_WRONG_FILE_NAME
35 CREATE TABLESPACE bad ADD DATAFILE '../data/test/bad.ibd';
36 SHOW WARNINGS;
37 --error ER_WRONG_FILE_NAME
38 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/test/bad.ibd';
39 SHOW WARNINGS;
40 --error ER_WRONG_FILE_NAME
41 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/bad.ibd';
42 SHOW WARNINGS;
43 --error ER_WRONG_FILE_NAME
44 CREATE TABLESPACE bad ADD DATAFILE '../does_not_exist/bad.ibd';
45 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
46 SHOW WARNINGS;
47 --error ER_WRONG_FILE_NAME
48 CREATE TABLESPACE bad ADD DATAFILE 'test/../bad.ibd';
49 SHOW WARNINGS;
50 --error ER_WRONG_FILE_NAME
51 CREATE TABLESPACE bad ADD DATAFILE './test/../bad.ibd';
52 SHOW WARNINGS;
53 --error ER_WRONG_FILE_NAME
54 CREATE TABLESPACE bad ADD DATAFILE 'test\\..\\bad.ibd';
55 SHOW WARNINGS;
56 --error ER_WRONG_FILE_NAME
57 CREATE TABLESPACE bad ADD DATAFILE '..///data//test///..//bad.ibd';
58 SHOW WARNINGS;
59 --error ER_WRONG_FILE_NAME
60 CREATE TABLESPACE bad ADD DATAFILE '.\\test\\..\\bad.ibd';
61 SHOW WARNINGS;
62 --error ER_WRONG_FILE_NAME
63 CREATE TABLESPACE bad ADD DATAFILE '..\\\\\\data\\\\test\\\\\\..\\\\bad.ibd';
64 SHOW WARNINGS;
65
66 --echo #
67 --echo # Try a series of valid relative ADD DATAFILE entries.
68 --echo # General tablespace files can be in the datadir but they cannot be under the datadir.
69 --echo #
70 CREATE TABLESPACE ibport_s01 ADD DATAFILE 'ibport_s01.ibd';
71 CREATE TABLESPACE ibport_s02 ADD DATAFILE './ibport_s02.ibd';
72 CREATE TABLESPACE ibport_s03 ADD DATAFILE '../data/ibport_s03.ibd';
73 CREATE TABLESPACE ibport_s04 ADD DATAFILE '.\\ibport_s04.ibd';
74 CREATE TABLESPACE ibport_s05 ADD DATAFILE '..\\data\\ibport_s05.ibd';
75
76 --echo # Directory listing of MYSQLD_DATADIR/ ibport*
77 --list_files $MYSQLD_DATADIR/ ibport*
78
79 --replace_result $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
80 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
81 FROM information_schema.innodb_tablespaces s, information_schema.innodb_datafiles d
82 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
83
84 --replace_result $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
85 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
86 FROM information_schema.innodb_tablespaces s, information_schema.files f
87 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
88
89 DROP TABLESPACE ibport_s01;
90 DROP TABLESPACE ibport_s02;
91 DROP TABLESPACE ibport_s03;
92 DROP TABLESPACE ibport_s04;
93 DROP TABLESPACE ibport_s05;
94
95 --disable_query_log
96 call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] InnoDB: Operating system error number [0-9]* in a file operation");
97 --enable_query_log