Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_tmpdir_basic.test

raw
1
2
3 SET @start_global_value = @@global.innodb_tmpdir;
4 SELECT @start_global_value;
5
6 #
7 # exists as global and session
8 #
9 select @@session.innodb_tmpdir;
10
11 show global variables like 'innodb_tmpdir';
12 show session variables like 'innodb_tmpdir';
13
14 --disable_warnings
15 select * from performance_schema.global_variables where variable_name='innodb_tmpdir';
16 select * from performance_schema.session_variables where variable_name='innodb_tmpdir';
17 --enable_warnings
18 #
19 # Show that it is writable
20 #
21
22 set global innodb_tmpdir=@@global.tmpdir;
23 set session innodb_tmpdir=@@global.tmpdir;
24
25 #
26 # incorrect types
27 #
28 --error ER_WRONG_TYPE_FOR_VAR
29 set global innodb_tmpdir=1.1;
30 --error ER_WRONG_TYPE_FOR_VAR
31 set global innodb_tmpdir=1e1;
32
33 #
34 # path len more than 512
35 #
36 --error ER_WRONG_VALUE_FOR_VAR
37 set global innodb_tmpdir=repeat('a',1000);
38 show warnings;
39
40 #
41 # Cleanup
42 #
43
44 SET @@global.innodb_tmpdir = @start_global_value;
45 SELECT @@global.innodb_tmpdir;