Debian Codegraph @

mysql-test/suite/sys_vars/r/mysqlx_idle_worker_thread_timeout_basic.result

raw
1 SET @mysqlx_idle_worker_thread_timeout_sav= @@global.mysqlx_idle_worker_thread_timeout;
2 SET GLOBAL mysqlx_idle_worker_thread_timeout=7;
3 SET @@global.mysqlx_idle_worker_thread_timeout=7;
4 show variables like 'mysqlx_idle_worker_thread_timeout';
5 Variable_name Value
6 mysqlx_idle_worker_thread_timeout 7
7 SET @@global.mysqlx_idle_worker_thread_timeout=3600;
8 show variables like 'mysqlx_idle_worker_thread_timeout';
9 Variable_name Value
10 mysqlx_idle_worker_thread_timeout 3600
11 SET mysqlx_idle_worker_thread_timeout=7;
12 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@local.mysqlx_idle_worker_thread_timeout=7;
14 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
15 SET @@mysqlx_idle_worker_thread_timeout=7;
16 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
17 SET @@session.mysqlx_idle_worker_thread_timeout=7;
18 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
19 SET SESSION mysqlx_idle_worker_thread_timeout=7;
20 ERROR HY000: Variable 'mysqlx_idle_worker_thread_timeout' is a GLOBAL variable and should be set with SET GLOBAL
21 SET @@global.mysqlx_idle_worker_thread_timeout=3601;
22 Warnings:
23 Warning 1292 Truncated incorrect mysqlx_idle_worker_thread_timeout value: '3601'
24 SET GLOBAL mysqlx_idle_worker_thread_timeout=0;
25 SET GLOBAL mysqlx_idle_worker_thread_timeout=-1;
26 Warnings:
27 Warning 1292 Truncated incorrect mysqlx_idle_worker_thread_timeout value: '-1'
28 SET GLOBAL mysqlx_idle_worker_thread_timeout='invaid%char';
29 ERROR 42000: Incorrect argument type to variable 'mysqlx_idle_worker_thread_timeout'
30 show variables like 'mysqlx_idle_worker_thread_timeout';
31 Variable_name Value
32 mysqlx_idle_worker_thread_timeout 0
33 SET GLOBAL mysqlx_idle_worker_thread_timeout=60;
34 SET GLOBAL mysqlx_idle_worker_thread_timeout= @mysqlx_idle_worker_thread_timeout_sav;