| 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; |