1--source include/have_rocksdb.inc
2
3--echo # If rocksdb_tmpdir is NULL or "", temporary file will be created in
4--echo # server configuration variable location(--tmpdir)
5
6CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB;
7show session variables like 'rocksdb_tmpdir';
8--echo # Connection con1
9connect (con1,localhost,root);
10show session variables like 'rocksdb_tmpdir';
11
12ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE;
13connection default;
14disconnect con1;
15DROP TABLE t1;
16
17--echo # rocksdb_tmpdir with valid location.
18
19CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=RocksDB;
20set @tmpdir = @@global.tmpdir;
21set global rocksdb_tmpdir = @tmpdir;
22show session variables like 'rocksdb_tmpdir';
23
24--echo # Connection con3
25connect (con2,localhost,root);
26--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
27show session variables like 'rocksdb_tmpdir';
28
29ALTER TABLE t1 ADD INDEX kb(b), ALGORITHM=INPLACE;
30disconnect con2;
31connection default;
32set global rocksdb_tmpdir=NULL;
33DROP TABLE t1;
34
35
36