Debian Codegraph @

mysql-test/suite/archive/archive_symlink.result

raw
1 #
2 # Archive can only use an existing directory for DATA DIRECTORY.
3 #
4 CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
5 ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive';
6 ERROR HY000: Can't create table `test`.`t1` (errno: 2 "No such file or directory")
7 #
8 # mkdir MYSQL_TMP_DIR/archive and try again...
9 # Archive will use a symlink for DATA DIRECTORY but ignore INDEX DIRECTORY.
10 #
11 CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
12 ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive';
13 Warnings:
14 Note 1618 INDEX DIRECTORY option ignored
15 INSERT INTO t1 VALUES (NULL, "blue");
16 INSERT INTO t1 VALUES (NULL, "red");
17 INSERT INTO t1 VALUES (NULL, "yellow");
18 # Checking if archive file exists where we specified in DATA DIRECTORY
19 SHOW CREATE TABLE t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `a` int(11) NOT NULL AUTO_INCREMENT,
23 `b` char(30) DEFAULT NULL,
24 PRIMARY KEY (`a`)
25 ) ENGINE=ARCHIVE AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/archive/'
26 DROP TABLE t1;
27 #
28 # Be sure SQL MODE "NO_DIR_IN_CREATE" prevents the use of DATA DIRECTORY
29 #
30 SET @org_mode=@@sql_mode;
31 SET @@sql_mode='NO_DIR_IN_CREATE';
32 SELECT @@sql_mode;
33 @@sql_mode
34 NO_DIR_IN_CREATE
35 CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
36 ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive';
37 Warnings:
38 Warning 1618 DATA DIRECTORY option ignored
39 INSERT INTO t1 VALUES (NULL, "blue");
40 INSERT INTO t1 VALUES (NULL, "red");
41 INSERT INTO t1 VALUES (NULL, "yellow");
42 # Checking if archive file exists in --datadir since DATA DIRECTORY was ignored.
43 DROP TABLE t1;
44 set @@sql_mode=@org_mode;
45 #
46 # MySQL engine does not allow DATA DIRECTORY to be
47 # within --datadir for any engine, including Archive
48 #
49 CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30))
50 ENGINE archive DATA DIRECTORY 'MYSQLD_DATADIR/test';
51 ERROR HY000: Incorrect arguments to DATA DIRECTORY
52 CREATE TABLE t1 (c1 int(10), PRIMARY KEY (c1))
53 ENGINE archive INDEX DIRECTORY 'MYSQLD_DATADIR/test';
54 ERROR HY000: Incorrect arguments to INDEX DIRECTORY
55 #
56 # Cleanup
57 #