diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb_sys_vars/t/rocksdb_tmpdir_basic.test | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/t/rocksdb_tmpdir_basic.test b/storage/rocksdb/mysql-test/rocksdb_sys_vars/t/rocksdb_tmpdir_basic.test new file mode 100644 index 00000000..8865914d --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/t/rocksdb_tmpdir_basic.test @@ -0,0 +1,38 @@ +--source include/have_rocksdb.inc + +SET @start_global_value = @@global.rocksdb_tmpdir; +SELECT @start_global_value; + +# +# exists as global and session +# +select @@session.rocksdb_tmpdir; + +show global variables like 'rocksdb_tmpdir'; +show session variables like 'rocksdb_tmpdir'; + +select * from information_schema.global_variables where variable_name='rocksdb_tmpdir'; +select * from information_schema.session_variables where variable_name='rocksdb_tmpdir'; + +# +# Show that it is writable +# + +set global rocksdb_tmpdir='value'; +set session rocksdb_tmpdir='value'; + +# +# incorrect types +# +--error ER_WRONG_TYPE_FOR_VAR +set global rocksdb_tmpdir=1.1; +--error ER_WRONG_TYPE_FOR_VAR +set global rocksdb_tmpdir=1e1; + +# +# Cleanup +# + +SET @@global.rocksdb_tmpdir = @start_global_value; +SELECT @@global.rocksdb_tmpdir; + |