Debian Codegraph @

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

raw
1 # uint global
2 --source include/not_embedded.inc
3 --source include/windows.inc
4 --source include/not_aix.inc
5 SET @start_global_value = @@global.thread_pool_min_threads;
6
7 #
8 # exists as global only
9 #
10 select @@global.thread_pool_min_threads;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.thread_pool_min_threads;
13 show global variables like 'thread_pool_min_threads';
14 show session variables like 'thread_pool_min_threads';
15 select * from information_schema.global_variables where variable_name='thread_pool_min_threads';
16 select * from information_schema.session_variables where variable_name='thread_pool_min_threads';
17
18 #
19 # show that it's writable
20 #
21 set global thread_pool_min_threads=1;
22 select @@global.thread_pool_min_threads;
23 set global thread_pool_min_threads=65536;
24 select @@global.thread_pool_min_threads;
25 --error ER_GLOBAL_VARIABLE
26 set session thread_pool_min_threads=1;
27
28 #
29 # incorrect types
30 #
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global thread_pool_min_threads=1.1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 set global thread_pool_min_threads=1e1;
35 --error ER_WRONG_TYPE_FOR_VAR
36 set global thread_pool_min_threads="foo";
37
38
39 set global thread_pool_min_threads=0;
40 select @@global.thread_pool_min_threads;
41 set global thread_pool_min_threads=10000000000;
42 select @@global.thread_pool_min_threads;
43
44 SET @@global.thread_pool_min_threads = @start_global_value;