Debian Codegraph @

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

raw
1 #
2 # Windows version of Tablespace Portability test.
3 #
4 # This testcase is related to WL#5980 & WL#6205.
5 # It tests whether datafiles can be copied from one location
6 # to another, and still be opened. In order to make this testcase run
7 # on any OS, we create the tablespaces here.
8 #
9 SET DEFAULT_STORAGE_ENGINE=InnoDB;
10 #
11 # Try a series of invalid relative ADD DATAFILE entries.
12 # General tablespace files can be in the datadir but they cannot be under the datadir.
13 #
14 CREATE TABLESPACE bad ADD DATAFILE '';
15 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
16 SHOW WARNINGS;
17 Level Code Message
18 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
19 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
20 Error 1528 Failed to create TABLESPACE bad
21 Error 3121 Incorrect File Name ''.
22 CREATE TABLESPACE bad ADD DATAFILE '.ibd';
23 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
24 SHOW WARNINGS;
25 Level Code Message
26 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
27 Error 1528 Failed to create TABLESPACE bad
28 Error 3121 Incorrect File Name '.ibd'.
29 CREATE TABLESPACE bad ADD DATAFILE './ibd';
30 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
31 SHOW WARNINGS;
32 Level Code Message
33 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
34 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
35 Error 1528 Failed to create TABLESPACE bad
36 Error 3121 Incorrect File Name './ibd'.
37 CREATE TABLESPACE bad ADD DATAFILE './.ibd';
38 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
39 SHOW WARNINGS;
40 Level Code Message
41 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
42 Error 1528 Failed to create TABLESPACE bad
43 Error 3121 Incorrect File Name './.ibd'.
44 CREATE TABLESPACE bad ADD DATAFILE '../spaces/';
45 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
46 SHOW WARNINGS;
47 Level Code Message
48 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
49 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
50 Error 3121 The directory does not exist or is incorrect.
51 Error 3121 The DATAFILE location must be in a known directory.
52 Error 1528 Failed to create TABLESPACE bad
53 Error 3121 Incorrect File Name '../spaces/'.
54 CREATE TABLESPACE bad ADD DATAFILE 'test/bad.ibd';
55 ERROR HY000: The DATAFILE location cannot be under the datadir.
56 SHOW WARNINGS;
57 Level Code Message
58 Error 3121 The DATAFILE location cannot be under the datadir.
59 Error 1528 Failed to create TABLESPACE bad
60 Error 3121 Incorrect File Name 'test/bad.ibd'.
61 CREATE TABLESPACE bad ADD DATAFILE './test/bad.ibd';
62 ERROR HY000: The DATAFILE location cannot be under the datadir.
63 SHOW WARNINGS;
64 Level Code Message
65 Error 3121 The DATAFILE location cannot be under the datadir.
66 Error 1528 Failed to create TABLESPACE bad
67 Error 3121 Incorrect File Name './test/bad.ibd'.
68 CREATE TABLESPACE bad ADD DATAFILE './test//bad.ibd';
69 ERROR HY000: The DATAFILE location cannot be under the datadir.
70 SHOW WARNINGS;
71 Level Code Message
72 Error 3121 The DATAFILE location cannot be under the datadir.
73 Error 1528 Failed to create TABLESPACE bad
74 Error 3121 Incorrect File Name './test//bad.ibd'.
75 CREATE TABLESPACE bad ADD DATAFILE '../data/test/bad.ibd';
76 ERROR HY000: The DATAFILE location cannot be under the datadir.
77 SHOW WARNINGS;
78 Level Code Message
79 Error 3121 The DATAFILE location cannot be under the datadir.
80 Error 1528 Failed to create TABLESPACE bad
81 Error 3121 Incorrect File Name '../data/test/bad.ibd'.
82 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/test/bad.ibd';
83 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
84 SHOW WARNINGS;
85 Level Code Message
86 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
87 Error 3121 The DATAFILE location cannot be under the datadir.
88 Error 1528 Failed to create TABLESPACE bad
89 Error 3121 Incorrect File Name '../data/../data/test/bad.ibd'.
90 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/bad.ibd';
91 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
92 SHOW WARNINGS;
93 Level Code Message
94 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
95 Error 1528 Failed to create TABLESPACE bad
96 Error 3121 Incorrect File Name '../data/../data/bad.ibd'.
97 CREATE TABLESPACE bad ADD DATAFILE '../does_not_exist/bad.ibd';
98 ERROR HY000: The directory does not exist or is incorrect.
99 SHOW WARNINGS;
100 Level Code Message
101 Error 3121 The directory does not exist or is incorrect.
102 Error 3121 The DATAFILE location must be in a known directory.
103 Error 1528 Failed to create TABLESPACE bad
104 Error 3121 Incorrect File Name '../does_not_exist/bad.ibd'.
105 CREATE TABLESPACE bad ADD DATAFILE 'test/../bad.ibd';
106 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
107 SHOW WARNINGS;
108 Level Code Message
109 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
110 Error 1528 Failed to create TABLESPACE bad
111 Error 3121 Incorrect File Name 'test/../bad.ibd'.
112 CREATE TABLESPACE bad ADD DATAFILE './test/../bad.ibd';
113 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
114 SHOW WARNINGS;
115 Level Code Message
116 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
117 Error 1528 Failed to create TABLESPACE bad
118 Error 3121 Incorrect File Name './test/../bad.ibd'.
119 CREATE TABLESPACE bad ADD DATAFILE 'test//..//bad.ibd';
120 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
121 SHOW WARNINGS;
122 Level Code Message
123 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
124 Error 1528 Failed to create TABLESPACE bad
125 Error 3121 Incorrect File Name 'test//..//bad.ibd'.
126 CREATE TABLESPACE bad ADD DATAFILE '..///data//test///..//bad.ibd';
127 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
128 SHOW WARNINGS;
129 Level Code Message
130 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
131 Error 1528 Failed to create TABLESPACE bad
132 Error 3121 Incorrect File Name '..///data//test///..//bad.ibd'.
133 CREATE TABLESPACE bad ADD DATAFILE './/test//..//bad.ibd';
134 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
135 SHOW WARNINGS;
136 Level Code Message
137 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
138 Error 1528 Failed to create TABLESPACE bad
139 Error 3121 Incorrect File Name './/test//..//bad.ibd'.
140 CREATE TABLESPACE bad ADD DATAFILE '..//////data////test//////..////bad.ibd';
141 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
142 SHOW WARNINGS;
143 Level Code Message
144 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
145 Error 1528 Failed to create TABLESPACE bad
146 Error 3121 Incorrect File Name '..//////data////test//////..////bad.ibd'.
147 #
148 # Try a series of valid relative ADD DATAFILE entries.
149 # General tablespace files can be in the datadir but they cannot be under the datadir.
150 #
151 CREATE TABLESPACE ibport_s01 ADD DATAFILE 'ibport_s01.ibd';
152 CREATE TABLESPACE ibport_s02 ADD DATAFILE './ibport_s02.ibd';
153 CREATE TABLESPACE ibport_s03 ADD DATAFILE '../data/ibport_s03.ibd';
154 CREATE TABLESPACE ibport_s04 ADD DATAFILE './/ibport_s04.ibd';
155 CREATE TABLESPACE ibport_s05 ADD DATAFILE '..//data//ibport_s05.ibd';
156 # Directory listing of MYSQLD_DATADIR/ ibport*
157 ibport_s01.ibd
158 ibport_s02.ibd
159 ibport_s03.ibd
160 ibport_s04.ibd
161 ibport_s05.ibd
162 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
163 FROM information_schema.innodb_tablespaces s, information_schema.innodb_datafiles d
164 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
165 Type Space Name Path
166 General ibport_s01 ibport_s01.ibd
167 General ibport_s02 ./ibport_s02.ibd
168 General ibport_s03 ../data/ibport_s03.ibd
169 General ibport_s04 .//ibport_s04.ibd
170 General ibport_s05 ..//data//ibport_s05.ibd
171 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
172 FROM information_schema.innodb_tablespaces s, information_schema.files f
173 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
174 Type Space Name Path
175 General ibport_s01 ./ibport_s01.ibd
176 General ibport_s02 ./ibport_s02.ibd
177 General ibport_s03 ../data/ibport_s03.ibd
178 General ibport_s04 .//ibport_s04.ibd
179 General ibport_s05 ..//data//ibport_s05.ibd
180 DROP TABLESPACE ibport_s01;
181 DROP TABLESPACE ibport_s02;
182 DROP TABLESPACE ibport_s03;
183 DROP TABLESPACE ibport_s04;
184 DROP TABLESPACE ibport_s05;