Debian Codegraph @

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

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