Debian Codegraph @

mysql-test/suite/group_replication/t/gr_innodb_unknown_dir.test

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