Debian Codegraph @

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

raw
1 # Variable: mysqlx_max_connections
2 # Default : 100
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_max_connections_sav= @@global.mysqlx_max_connections;
7
8 ## Valid cases
9 SET GLOBAL mysqlx_max_connections=150;
10 show variables like 'mysqlx_max_connections';
11
12 SET @@global.mysqlx_max_connections=500;
13 show variables like 'mysqlx_max_connections';
14
15 ## Invalid cases
16 --error ER_GLOBAL_VARIABLE
17 SET mysqlx_max_connections=150;
18 --error ER_GLOBAL_VARIABLE
19 SET @@local.mysqlx_max_connections=150;
20 --error ER_GLOBAL_VARIABLE
21 SET @@mysqlx_max_connections=150;
22 --error ER_GLOBAL_VARIABLE
23 SET @@session.mysqlx_max_connections=150;
24 --error ER_GLOBAL_VARIABLE
25 SET SESSION mysqlx_max_connections=150;
26
27 # Warning: Truncated incorrect mysqlx_max_connections value
28 SET GLOBAL mysqlx_max_connections=0;
29
30 # It will set value to 1
31 SET GLOBAL mysqlx_max_connections=-848;
32
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL mysqlx_max_connections='%45*#in';
35
36 show variables like 'mysqlx_max_connections';
37 SET @@global.mysqlx_max_connections=151;
38
39 SET @@global.mysqlx_max_connections= @mysqlx_max_connections_sav;