mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
3b6c04f44c
The server behaves differently on the DATA/INDEX DIRECTORY clause under valgrind because symlink is disabled under valgrind.
24 lines
996 B
Text
24 lines
996 B
Text
--source include/have_partition.inc
|
|
--let $engine=MyISAM
|
|
--source inc/part_alter_values.inc
|
|
|
|
#
|
|
# MDEV-14026 ALTER TABLE ... DELAY_KEY_WRITE=1 creates table copy for partitioned MyISAM table with DATA DIRECTORY/INDEX DIRECTORY options
|
|
#
|
|
|
|
replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR;
|
|
--disable_warnings
|
|
eval create table t1 ( c1 int, c2 int, c3 varchar(100)) delay_key_write=1
|
|
partition by key(c1) (
|
|
partition p01 data directory = '$MYSQL_TMP_DIR'
|
|
index directory = '$MYSQL_TMP_DIR',
|
|
partition p02 data directory = '$MYSQL_TMP_DIR'
|
|
index directory = '$MYSQL_TMP_DIR');
|
|
--enable_warnings
|
|
insert into t1 values (1, 1, repeat('a', 100));
|
|
insert into t1 select rand()*1000, rand()*1000, repeat('b', 100) from t1;
|
|
insert into t1 select rand()*1000, rand()*1000, repeat('b', 100) from t1;
|
|
insert into t1 select rand()*1000, rand()*1000, repeat('b', 100) from t1;
|
|
alter online table t1 delay_key_write=0;
|
|
alter online table t1 delay_key_write=1;
|
|
drop table t1;
|