Debian Codegraph @

mysql-test/suite/archive/archive_no_symlink.result

raw
1 #
2 # This test shows that DATA DIRECTORY and INDEX DIRECTORY are
3 # ignored where symbolic links are not supported such as Windows.
4 #
5 CREATE TABLE t1 (
6 c1 int(10) unsigned NOT NULL AUTO_INCREMENT,
7 c2 varchar(30) NOT NULL,
8 c3 smallint(5) unsigned DEFAULT NULL,
9 PRIMARY KEY (c1))
10 ENGINE = archive
11 DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive';
12 Warnings:
13 Note 1618 DATA DIRECTORY option ignored
14 Note 1618 INDEX DIRECTORY option ignored
15 INSERT INTO t1 VALUES (NULL, "first", 1);
16 INSERT INTO t1 VALUES (NULL, "second", 2);
17 INSERT INTO t1 VALUES (NULL, "third", 3);
18 SHOW CREATE TABLE t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
22 `c2` varchar(30) NOT NULL,
23 `c3` smallint(5) unsigned DEFAULT NULL,
24 PRIMARY KEY (`c1`)
25 ) ENGINE=ARCHIVE AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
26 DROP TABLE t1;