mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
1a85ae444a
consistently issue a Note 1618 DATA DIRECTORY option ignored Note 1618 INDEX DIRECTORY option ignored in archive/csv/innodb/rocksdb whenever an option is ignored. Note that csv doesn't say "INDEX DIRECTORY option ignored" because it does not create index files at all anywhere. Other engines don't say "INDEX DIRECTORY option ignored" if the table has no indexes. additionally InnoDB doesn't say that if INDEX DIRECTORY is the same as DATA DIRECTORY, because in that case indexes are technically stored in INDEX DIRECTORY. collateral fix: use strmake to zero-terminate the string
27 lines
903 B
Plaintext
27 lines
903 B
Plaintext
#
|
|
# This test shows that DATA DIRECTORY and INDEX DIRECTORY are
|
|
# ignored where symbolic links are not supported such as Windows.
|
|
#
|
|
CREATE TABLE t1 (
|
|
c1 int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
c2 varchar(30) NOT NULL,
|
|
c3 smallint(5) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (c1))
|
|
ENGINE = archive
|
|
DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive';
|
|
Warnings:
|
|
Note 1618 DATA DIRECTORY option ignored
|
|
Note 1618 INDEX DIRECTORY option ignored
|
|
INSERT INTO t1 VALUES (NULL, "first", 1);
|
|
INSERT INTO t1 VALUES (NULL, "second", 2);
|
|
INSERT INTO t1 VALUES (NULL, "third", 3);
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`c2` varchar(30) NOT NULL,
|
|
`c3` smallint(5) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`c1`)
|
|
) ENGINE=ARCHIVE AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
DROP TABLE t1;
|