1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
# ###################################################################
# wl#13065 : Restrict All InnoDB Tablespaces To Known Directories
# ###################################################################
--source include/have_group_replication_plugin.inc
--let $rpl_server_count= 2
--source include/group_replication.inc
# Connect to server1, create a table and insert a record
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Cannot create a tablespace for table .* because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory");
call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location must be in a known directory");
SET SESSION sql_log_bin= 1;
LET $MYSQLD_DATADIR=`select @@datadir`;
LET $UNKNOWN_DIR=$MYSQLD_DATADIR/../unknown_dir;
--mkdir $UNKNOWN_DIR
--echo #
--echo # Attempt to create a table in an unknown directory.
--echo #
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
--error ER_WRONG_FILE_NAME
eval CREATE TABLE t1 (c1 INT) DATA DIRECTORY='$UNKNOWN_DIR';
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR \\ /
SHOW WARNINGS;
--echo #
--echo # Attempt to create a general tablespace in an unknown directory.
--echo #
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
--error ER_WRONG_FILE_NAME
eval CREATE TABLESPACE t2 ADD DATAFILE '$UNKNOWN_DIR/bad_2.ibd';
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR \\ /
SHOW WARNINGS;
--echo #
--echo # Attempt to create a table with a partition in an unknown directory.
--echo #
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
--error ER_WRONG_FILE_NAME
eval CREATE TABLE t3(c1 INT)
PARTITION BY HASH(c1) (
PARTITION p1 DATA DIRECTORY='$UNKNOWN_DIR',
PARTITION p2 DATA DIRECTORY='$UNKNOWN_DIR',
PARTITION p3 DATA DIRECTORY='$UNKNOWN_DIR');
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR \\ /
SHOW WARNINGS;
--let $assert_text= 'Assert all servers are ONLINE'
--let $assert_cond= "[SELECT COUNT(*) from performance_schema.replication_group_members WHERE MEMBER_STATE=\"ONLINE\"]" = 2
--source include/assert.inc
--force-rmdir $UNKNOWN_DIR
--source include/group_replication_end.inc
|
