Debian Codegraph @

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

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