mirror of
https://github.com/MariaDB/server.git
synced 2025-04-22 07:05:33 +02: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
102 lines
3.6 KiB
Text
102 lines
3.6 KiB
Text
--source include/have_innodb.inc
|
|
--source include/have_partition.inc
|
|
--source include/have_symlink.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-15953 Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
|
|
--echo #
|
|
|
|
mkdir $MYSQLTEST_VARDIR/tmp/partitions_here;
|
|
|
|
evalp CREATE TABLE t (
|
|
a INT NOT NULL, KEY(a)
|
|
) ENGINE=INNODB
|
|
PARTITION BY HASH (a) (
|
|
PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB,
|
|
PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/' ENGINE = INNODB
|
|
);
|
|
INSERT INTO t VALUES (1);
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
ALTER TABLE t DROP PRIMARY KEY, ALGORITHM=COPY;
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
SET @TMP = @@GLOBAL.INNODB_FILE_PER_TABLE;
|
|
SET GLOBAL INNODB_FILE_PER_TABLE=OFF;
|
|
ALTER TABLE t ADD PRIMARY KEY pk(a), ALGORITHM=INPLACE;
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
SET GLOBAL INNODB_FILE_PER_TABLE=@TMP;
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
|
|
PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
|
|
PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
|
|
);
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
|
|
PARTITION p1 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/',
|
|
PARTITION p2 DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
|
|
);
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
eval ALTER TABLE t REORGANIZE PARTITION p1,p2 INTO (
|
|
PARTITION p1 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB,
|
|
PARTITION p2 INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/' ENGINE = INNODB
|
|
);
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
|
|
DROP TABLE t;
|
|
|
|
SET @strict = @@innodb_strict_mode;
|
|
SET innodb_strict_mode=OFF;
|
|
evalp CREATE TABLE t (
|
|
a INT NOT NULL, KEY(a)
|
|
) ENGINE=INNODB
|
|
PARTITION BY RANGE (a)
|
|
SUBPARTITION BY HASH (a)
|
|
SUBPARTITIONS 2
|
|
(
|
|
PARTITION p1 VALUES LESS THAN (7)
|
|
DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
|
|
INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
|
|
ENGINE = INNODB,
|
|
PARTITION p2 VALUES LESS THAN MAXVALUE
|
|
DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
|
|
INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
|
|
ENGINE = INNODB
|
|
);
|
|
SET innodb_strict_mode=@strict;
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
eval ALTER TABLE t
|
|
REORGANIZE PARTITION p1,p2 INTO
|
|
(
|
|
PARTITION p1 VALUES LESS THAN (7)
|
|
DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
|
|
INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
|
|
ENGINE = INNODB,
|
|
PARTITION p2 VALUES LESS THAN MAXVALUE
|
|
DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_somewhere_else/'
|
|
INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/partitions_here/'
|
|
ENGINE = INNODB
|
|
);
|
|
|
|
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
SHOW CREATE TABLE t;
|
|
|
|
DROP TABLE t;
|
|
|
|
rmdir $MYSQLTEST_VARDIR/tmp/partitions_here/test;
|
|
rmdir $MYSQLTEST_VARDIR/tmp/partitions_here;
|
|
|