Debian Codegraph @

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

raw
1 # Variable: mysqlx_idle_worker_thread_timeout
2 # Default : 60000
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_idle_worker_thread_timeout_sav= @@global.mysqlx_idle_worker_thread_timeout;
7 ## Valid cases
8 SET GLOBAL mysqlx_idle_worker_thread_timeout=7;
9 SET @@global.mysqlx_idle_worker_thread_timeout=7;
10 show variables like 'mysqlx_idle_worker_thread_timeout';
11 #Max valid value
12 SET @@global.mysqlx_idle_worker_thread_timeout=3600;
13 show variables like 'mysqlx_idle_worker_thread_timeout';
14
15 ## Invalid cases
16 --error ER_GLOBAL_VARIABLE
17 SET mysqlx_idle_worker_thread_timeout=7;
18 --error ER_GLOBAL_VARIABLE
19 SET @@local.mysqlx_idle_worker_thread_timeout=7;
20 --error ER_GLOBAL_VARIABLE
21 SET @@mysqlx_idle_worker_thread_timeout=7;
22 --error ER_GLOBAL_VARIABLE
23 SET @@session.mysqlx_idle_worker_thread_timeout=7;
24 --error ER_GLOBAL_VARIABLE
25 SET SESSION mysqlx_idle_worker_thread_timeout=7;
26 # Warning: Truncated incorrect mysqlx_idle_worker_thread_timeout value
27 SET @@global.mysqlx_idle_worker_thread_timeout=3601;
28
29 #--error ER_GLOBAL_VARIABLE
30 SET GLOBAL mysqlx_idle_worker_thread_timeout=0;
31 # Warning for negative values
32 SET GLOBAL mysqlx_idle_worker_thread_timeout=-1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL mysqlx_idle_worker_thread_timeout='invaid%char';
35
36 show variables like 'mysqlx_idle_worker_thread_timeout';
37 SET GLOBAL mysqlx_idle_worker_thread_timeout=60;
38
39 SET GLOBAL mysqlx_idle_worker_thread_timeout= @mysqlx_idle_worker_thread_timeout_sav;