Debian Codegraph @

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

raw
1 # Variable: mysqlx_connect_timeout
2 # Default : 300000
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_connect_timeout_sav= @@global.mysqlx_connect_timeout;
7
8 ## Valid cases
9 SET GLOBAL mysqlx_connect_timeout=20;
10
11 # IT will set value to 300000
12 SET @@global.mysqlx_connect_timeout=500;
13 show variables like 'mysqlx_connect_timeout';
14
15 ## Invalid cases
16 --error ER_GLOBAL_VARIABLE
17 SET mysqlx_connect_timeout=20;
18 --error ER_GLOBAL_VARIABLE
19 SET @@local.mysqlx_connect_timeout=20;
20 --error ER_GLOBAL_VARIABLE
21 SET @@mysqlx_connect_timeout=20;
22 --error ER_GLOBAL_VARIABLE
23 SET @@session.mysqlx_connect_timeout=20;
24 --error ER_GLOBAL_VARIABLE
25 SET SESSION mysqlx_connect_timeout=20;
26
27 # Truncated incorrect mysqlx_connect_timeout value: '0'
28 SET GLOBAL mysqlx_connect_timeout=0;
29
30 SET GLOBAL mysqlx_connect_timeout=1;
31
32 # It will set vaule to 1
33 SET GLOBAL mysqlx_connect_timeout=-4686234;
34 --error ER_WRONG_TYPE_FOR_VAR
35 SET GLOBAL mysqlx_connect_timeout='gduges7';
36
37 show variables like 'mysqlx_connect_timeout';
38 SET GLOBAL mysqlx_connect_timeout=300;
39
40 SET @@global.mysqlx_connect_timeout= @mysqlx_connect_timeout_sav;