Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-20 OBN - Added check of I_S values after variable value change
4 #
5
6 SET @start_global_value = @@global.thread_cache_size;
7 SELECT @start_global_value;
8
9 #
10 # exists as global only
11 #
12 select @@global.thread_cache_size;
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.thread_cache_size;
15 show global variables like 'thread_cache_size';
16 show session variables like 'thread_cache_size';
17 select * from information_schema.global_variables where variable_name='thread_cache_size';
18 select * from information_schema.session_variables where variable_name='thread_cache_size';
19
20 #
21 # show that it's writable
22 #
23 set global thread_cache_size=1;
24 select @@global.thread_cache_size;
25 select * from information_schema.global_variables where variable_name='thread_cache_size';
26 select * from information_schema.session_variables where variable_name='thread_cache_size';
27 --error ER_GLOBAL_VARIABLE
28 set session thread_cache_size=1;
29
30 #
31 # incorrect types
32 #
33 --error ER_WRONG_TYPE_FOR_VAR
34 set global thread_cache_size=1.1;
35 --error ER_WRONG_TYPE_FOR_VAR
36 set global thread_cache_size=1e1;
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global thread_cache_size="foo";
39
40 #
41 # min/max values
42 #
43 set global thread_cache_size=0;
44 select @@global.thread_cache_size;
45 set global thread_cache_size=cast(-1 as unsigned int);
46 select @@global.thread_cache_size;
47
48 SET @@global.thread_cache_size = @start_global_value;
49 SELECT @@global.thread_cache_size;