diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/tmpdir.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/tmpdir.test | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/tmpdir.test b/storage/rocksdb/mysql-test/rocksdb/t/tmpdir.test new file mode 100644 index 00000000..28615264 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/tmpdir.test @@ -0,0 +1,35 @@ +--source include/have_rocksdb.inc + +--echo # If rocksdb_tmpdir is NULL or "", temporary file will be created in +--echo # server configuration variable location(--tmpdir) + +CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB; +show session variables like 'rocksdb_tmpdir'; +--echo # Connection con1 +connect (con1,localhost,root); +show session variables like 'rocksdb_tmpdir'; + +ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE; +connection default; +disconnect con1; +DROP TABLE t1; + +--echo # rocksdb_tmpdir with valid location. + +CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB; +set @tmpdir = @@global.tmpdir; +set global rocksdb_tmpdir = @tmpdir; +show session variables like 'rocksdb_tmpdir'; + +--echo # Connection con3 +connect (con2,localhost,root); +--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR +show session variables like 'rocksdb_tmpdir'; + +ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE; +disconnect con2; +connection default; +set global rocksdb_tmpdir=NULL; +DROP TABLE t1; + + |