Debian Codegraph @

mysql-test/suite/archive/archive_symlink.test

raw
1 # Test archive engine when symbolic links are available.
2 --source include/not_windows.inc
3 --source include/have_archive.inc
4
5 # DATA DIRECTORY/INDEX DIRECTORY require symbolic link support
6 --source include/have_symlink.inc
7
8 let $MYSQLD_DATADIR= `select @@datadir`;
9 let $data_directory = DATA DIRECTORY = '$MYSQL_TMP_DIR/archive';
10 let $index_directory = INDEX DIRECTORY = '$MYSQL_TMP_DIR/archive';
11
12 --echo #
13 --echo # Archive can only use an existing directory for DATA DIRECTORY.
14 --echo #
15 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
16 --error ER_CANT_CREATE_TABLE
17 eval CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
18 ENGINE archive $data_directory $index_directory;
19
20 --echo #
21 --echo # mkdir MYSQL_TMP_DIR/archive and try again...
22 --echo # Archive will use a symlink for DATA DIRECTORY but ignore INDEX DIRECTORY.
23 --echo #
24 --mkdir $MYSQL_TMP_DIR/archive
25 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
26 eval CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
27 ENGINE archive $data_directory $index_directory;
28 INSERT INTO t1 VALUES (NULL, "blue");
29 INSERT INTO t1 VALUES (NULL, "red");
30 INSERT INTO t1 VALUES (NULL, "yellow");
31 --echo # Checking if archive file exists where we specified in DATA DIRECTORY
32 --file_exists $MYSQL_TMP_DIR/archive/t1.ARZ
33 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
34 SHOW CREATE TABLE t1;
35 DROP TABLE t1;
36
37 --echo #
38 --echo # Be sure SQL MODE "NO_DIR_IN_CREATE" prevents the use of DATA DIRECTORY
39 --echo #
40 SET @org_mode=@@sql_mode;
41 SET @@sql_mode='NO_DIR_IN_CREATE';
42 SELECT @@sql_mode;
43 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
44 eval CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
45 ENGINE archive $data_directory;
46 INSERT INTO t1 VALUES (NULL, "blue");
47 INSERT INTO t1 VALUES (NULL, "red");
48 INSERT INTO t1 VALUES (NULL, "yellow");
49 --echo # Checking if archive file exists in --datadir since DATA DIRECTORY was ignored.
50 --file_exists $MYSQLD_DATADIR/test/t1.ARZ
51 DROP TABLE t1;
52 set @@sql_mode=@org_mode;
53
54 --echo #
55 --echo # MySQL engine does not allow DATA DIRECTORY to be
56 --echo # within --datadir for any engine, including Archive
57 --echo #
58 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
59 --error ER_WRONG_ARGUMENTS
60 eval CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
61 ENGINE archive DATA DIRECTORY '$MYSQLD_DATADIR/test';
62
63 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
64 --error ER_WRONG_ARGUMENTS
65 eval CREATE TABLE t1 (c1 int(10), PRIMARY KEY (c1))
66 ENGINE archive INDEX DIRECTORY '$MYSQLD_DATADIR/test';
67
68 --echo #
69 --echo # Cleanup
70 --echo #
71 --rmdir $MYSQL_TMP_DIR/archive
72