Debian Codegraph @

mysql-test/suite/parts/t/partition_basic_symlink_innodb.test

raw
1 ################################################################################
2 # t/partition_basic_innodb.test #
3 # #
4 # Purpose: #
5 # Tests around Create Partitioned table using DATA/INDEX DIR #
6 # InnoDB branch #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: mleich #
10 # Original Date: 2006-03-05 #
11 # Change Author: mattiasj #
12 # Change Date: 2008-02-05 #
13 # Change: copied it from partition_basic_innodb.test and kept DATA DIR #
14 # Change Author: mattiasj #
15 # Change Date: 2008-03-16 #
16 # Change: Replaced all test with alter -> myisam, since innodb does not support#
17 # Change Author: Kevin lewis #
18 # Change Date: 2012-03-02 #
19 # Change: WL5980 activates DATA DIRECTORY for InnoDB #
20 ################################################################################
21
22 # NOTE: As of WL5980, InnoDB supports DATA DIRECTORY, but not INDEX DIRECTORY.
23 # See innodb.innodb-tablespace for tests using partition engine, innodb
24 # and DATADIRECTORY. The purpose of this test is to show that a
25 # partitioned table remembers the DATA/INDEX DIR and it is used if
26 # altered to MyISAM
27 #
28 --echo #
29 --echo # Verify that the DATA/INDEX DIR is stored and used if ALTER to MyISAM.
30 --echo #
31 # windows does not support symlink for DATA/INDEX DIRECTORY.
32 --source include/not_windows.inc
33
34 --disable_query_log
35 let $MYSQLD_DATADIR= `select @@datadir`;
36
37 # These values can change during the test
38 LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`;
39 LET $innodb_strict_mode_orig=`select @@session.innodb_strict_mode`;
40 --enable_query_log
41
42 --disable_warnings
43 DROP TABLE IF EXISTS t1;
44 --enable_warnings
45
46 --mkdir $MYSQLTEST_VARDIR/mysql-test-data-dir
47 --mkdir $MYSQLTEST_VARDIR/mysql-test-idx-dir
48
49 SET SESSION innodb_strict_mode = ON;
50
51 --echo #
52 --echo # InnoDB only supports DATA DIRECTORY with innodb_file_per_table=ON
53 --echo #
54 SET GLOBAL innodb_file_per_table = OFF;
55 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
56 --error ER_ILLEGAL_HA
57 eval CREATE TABLE t1 (c1 INT) ENGINE = InnoDB
58 PARTITION BY HASH (c1) (
59 PARTITION p0
60 DATA DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-data-dir'
61 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-idx-dir',
62 PARTITION p1
63 DATA DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-data-dir'
64 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-idx-dir'
65 );
66 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR
67 SHOW WARNINGS;
68
69 --echo #
70 --echo # InnoDB is different from MyISAM in that instead of
71 --echo # putting the file directly into the DATA DIRECTORY,
72 --echo # it adds a folder under it with the name of the database.
73 --echo # Since strict mode is off, InnoDB ignores the INDEX DIRECTORY
74 --echo # and it is no longer part of the definition.
75 --echo #
76 SET SESSION innodb_strict_mode = OFF;
77 SET GLOBAL innodb_file_per_table = ON;
78 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
79 eval CREATE TABLE t1 (c1 INT) ENGINE = InnoDB
80 PARTITION BY HASH (c1)
81 (PARTITION p0
82 DATA DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-data-dir'
83 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-idx-dir',
84 PARTITION p1
85 DATA DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-data-dir'
86 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-idx-dir'
87 );
88 SHOW WARNINGS;
89
90 --echo # Also create a partitioned table with DATA DIRECTORY clasue at
91 --echo # the table level.
92 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
93 eval CREATE TABLE t2 (c1 int) ENGINE = InnoDB
94 DATA DIRECTORY = '$MYSQLTEST_VARDIR/mysql-test-data-dir'
95 PARTITION BY HASH (c1)
96 (PARTITION p0,
97 PARTITION p1
98 );
99
100 --echo # Verifying .ibd files
101 --echo ---- MYSQLD_DATADIR/test
102 --list_files $MYSQLD_DATADIR/test
103 --echo ---- MYSQLTEST_VARDIR/mysql-test-data-dir/test
104 --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir/test
105 --echo # The ibd tablespaces should not be directly under the DATA DIRECTORY
106 --echo ---- MYSQLTEST_VARDIR/mysql-test-data-dir
107 --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir
108 --echo ---- MYSQLTEST_VARDIR/mysql-test-idx-dir
109 --list_files $MYSQLTEST_VARDIR/mysql-test-idx-dir
110
111 FLUSH TABLES;
112 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
113 SHOW CREATE TABLE t1;
114 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
115 SHOW CREATE TABLE t2;
116
117 --echo #
118 --echo # Verify how the DATA/INDEX DIRECTORY is stored and used if we
119 --echo # ALTER TABLE to MyISAM.
120 --echo #
121 ALTER TABLE t1 engine=MyISAM REMOVE PARTITIONING;
122 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
123 SHOW CREATE TABLE t1;
124
125 ALTER TABLE t2 engine=MyISAM REMOVE PARTITIONING;
126 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
127 SHOW CREATE TABLE t2;
128
129 --echo # Verifying .par and MyISAM files (.MYD, MYI)
130 --echo ---- MYSQLD_DATADIR/test
131 --replace_regex /_[0-9]+\.sdi/_XXX.sdi/
132 --list_files $MYSQLD_DATADIR/test
133 --echo ---- MYSQLTEST_VARDIR/mysql-test-data-dir
134 --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir
135 --echo ---- MYSQLTEST_VARDIR/mysql-test-idx-dir
136 --list_files $MYSQLTEST_VARDIR/mysql-test-idx-dir
137
138 --echo #
139 --echo # Now verify how the DATA DIRECTORY is used again if we
140 --echo # ALTER TABLE back to InnoDB.
141 --echo #
142 SET SESSION innodb_strict_mode = ON;
143
144 ALTER TABLE t1 engine=InnoDB;
145 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
146 SHOW CREATE TABLE t1;
147
148 ALTER TABLE t2 engine=InnoDB;
149 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
150 SHOW CREATE TABLE t2;
151
152 --echo # Verifying InnoDB .ibd files
153 --echo ---- MYSQLD_DATADIR/test
154 --list_files $MYSQLD_DATADIR/test
155 --echo ---- MYSQLTEST_VARDIR/mysql-test-data-dir
156 --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir
157 --echo ---- MYSQLTEST_VARDIR/mysql-test-idx-dir
158 --list_files $MYSQLTEST_VARDIR/mysql-test-idx-dir
159 --echo ---- MYSQLTEST_VARDIR/mysql-test-data-dir/test
160 --list_files $MYSQLTEST_VARDIR/mysql-test-data-dir/test
161
162 DROP TABLE t1;
163 DROP TABLE t2;
164
165 --disable_query_log
166 EVAL SET GLOBAL innodb_file_per_table=$innodb_file_per_table_orig;
167 EVAL SET SESSION innodb_strict_mode=$innodb_strict_mode_orig;
168 --enable_query_log
169
170 #
171 # Bug 32091: Security breach via directory changes
172 #
173 # Note: The description below is kept for historical reasons.
174 # An updated description is provided further below.
175 #
176 # The below test shows that a pre-existing table mysqltest2.t1 cannot be
177 # replaced by a user with no rights in 'mysqltest2'. The altered table
178 # test.t1 will be altered (remove partitioning) into the test directory
179 # and having its partitions removed from the mysqltest2 directory.
180 # (the partitions data files are named <tablename>#P#<partname>.MYD
181 # and will not collide with a non partitioned table's data files.)
182 # NOTE: the privileges on files and directories are the same for all
183 # database users in mysqld, though mysqld enforces privileges on
184 # the database and table levels which in turn maps to directories and
185 # files, but not the other way around (any db-user can use any
186 # directory or file that the mysqld-process can use, via DATA/INDEX DIR)
187 # this is the security flaw that was used in bug#32091 and bug#32111
188 #
189 # After WL#8971, this test is rewritten to use InnoDB.
190 # We create two partitioned tables in separate schemas. Then,
191 # partitioning is removed, which makes the data files be
192 # located in MYSQL_DATA_DIR/<schema name>.
193
194 --echo # Creating two non colliding tables test2.t1 and test.t1.
195 CREATE DATABASE test2;
196 USE test2;
197 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
198 eval CREATE TABLE t1 (a INT)
199 ENGINE = InnoDB
200 DATA DIRECTORY '$MYSQLTEST_VARDIR/tmp'
201 PARTITION BY LIST (a) (
202 PARTITION p0 VALUES IN (0),
203 PARTITION p1 VALUES IN (1)
204 );
205 INSERT INTO t1 VALUES (0);
206
207 USE test;
208 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
209 eval CREATE TABLE t1 (a INT)
210 ENGINE = InnoDB
211 DATA DIRECTORY '$MYSQLTEST_VARDIR/tmp'
212 PARTITION BY LIST (a) (
213 PARTITION p0 VALUES IN (0),
214 PARTITION p1 VALUES IN (1)
215 );
216 INSERT INTO t1 VALUES (1);
217
218 ALTER TABLE test.t1 ENGINE= MyISAM REMOVE PARTITIONING;
219
220 --echo # datadir/test:
221 --replace_regex /_[0-9]+\.sdi/_XXX.sdi/
222 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
223 --list_files $MYSQLD_DATADIR/test
224
225 --echo # datadir/test2:
226 --replace_regex /_[0-9]+\.sdi/_XXX.sdi/
227 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
228 --list_files $MYSQLD_DATADIR/test2
229
230 ALTER TABLE test2.t1 ENGINE= MyISAM REMOVE PARTITIONING;
231
232 --echo # datadir/test:
233 --replace_regex /_[0-9]+\.sdi/_XXX.sdi/
234 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
235 --list_files $MYSQLD_DATADIR/test
236
237 --echo # datadir/test2:
238 --replace_regex /_[0-9]+\.sdi/_XXX.sdi/
239 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
240 --list_files $MYSQLD_DATADIR/test2
241
242 FLUSH TABLES;
243 SELECT * FROM test.t1;
244 SELECT * FROM test2.t1;
245
246 DROP TABLE test2.t1;
247 DROP TABLE test.t1;
248 DROP DATABASE test2;
249
250 --echo #
251 --echo # Cleanup
252 --echo #
253
254 --rmdir $MYSQLTEST_VARDIR/mysql-test-data-dir/test
255 --rmdir $MYSQLTEST_VARDIR/mysql-test-data-dir
256 --rmdir $MYSQLTEST_VARDIR/mysql-test-idx-dir
257 --rmdir $MYSQLTEST_VARDIR/tmp/test2
258 --rmdir $MYSQLTEST_VARDIR/tmp/test