diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
| commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
| tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/archive/archive_symlink.result | |
| parent | Initial commit. (diff) | |
| download | mariadb-upstream.tar.xz mariadb-upstream.zip | |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/archive/archive_symlink.result')
| -rw-r--r-- | mysql-test/suite/archive/archive_symlink.result | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/mysql-test/suite/archive/archive_symlink.result b/mysql-test/suite/archive/archive_symlink.result new file mode 100644 index 00000000..7414fc88 --- /dev/null +++ b/mysql-test/suite/archive/archive_symlink.result @@ -0,0 +1,57 @@ +# +# Archive can only use an existing directory for DATA DIRECTORY. +# +CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30)) +ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive'; +ERROR HY000: Can't create table `test`.`t1` (errno: 2 "No such file or directory") +# +# mkdir MYSQL_TMP_DIR/archive and try again... +# Archive will use a symlink for DATA DIRECTORY but ignore INDEX DIRECTORY. +# +CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30)) +ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive' INDEX DIRECTORY = 'MYSQL_TMP_DIR/archive'; +Warnings: +Warning 1618 <INDEX DIRECTORY> option ignored +INSERT INTO t1 VALUES (NULL, "blue"); +INSERT INTO t1 VALUES (NULL, "red"); +INSERT INTO t1 VALUES (NULL, "yellow"); +# Checking if archive file exists where we specified in DATA DIRECTORY +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL AUTO_INCREMENT, + `b` char(30) DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=ARCHIVE AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DATA DIRECTORY='MYSQL_TMP_DIR/archive/' +DROP TABLE t1; +# +# Be sure SQL MODE "NO_DIR_IN_CREATE" prevents the use of DATA DIRECTORY +# +SET @org_mode=@@sql_mode; +SET @@sql_mode='NO_DIR_IN_CREATE'; +SELECT @@sql_mode; +@@sql_mode +NO_DIR_IN_CREATE +CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30)) +ENGINE archive DATA DIRECTORY = 'MYSQL_TMP_DIR/archive'; +Warnings: +Warning 1618 <DATA DIRECTORY> option ignored +INSERT INTO t1 VALUES (NULL, "blue"); +INSERT INTO t1 VALUES (NULL, "red"); +INSERT INTO t1 VALUES (NULL, "yellow"); +# Checking if archive file exists in --datadir since DATA DIRECTORY was ignored. +DROP TABLE t1; +set @@sql_mode=@org_mode; +# +# MySQL engine does not allow DATA DIRECTORY to be +# within --datadir for any engine, including Archive +# +CREATE TABLE t1 (a int AUTO_INCREMENT KEY, b char(30)) +ENGINE archive DATA DIRECTORY 'MYSQLD_DATADIR/test'; +ERROR HY000: Incorrect arguments to DATA DIRECTORY +CREATE TABLE t1 (c1 int(10), PRIMARY KEY (c1)) +ENGINE archive INDEX DIRECTORY 'MYSQLD_DATADIR/test'; +ERROR HY000: Incorrect arguments to INDEX DIRECTORY +# +# Cleanup +# |