Debian Codegraph @

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

raw
1 SET @mysqlx_max_connections_sav= @@global.mysqlx_max_connections;
2 SET GLOBAL mysqlx_max_connections=150;
3 show variables like 'mysqlx_max_connections';
4 Variable_name Value
5 mysqlx_max_connections 150
6 SET @@global.mysqlx_max_connections=500;
7 show variables like 'mysqlx_max_connections';
8 Variable_name Value
9 mysqlx_max_connections 500
10 SET mysqlx_max_connections=150;
11 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
12 SET @@local.mysqlx_max_connections=150;
13 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
14 SET @@mysqlx_max_connections=150;
15 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
16 SET @@session.mysqlx_max_connections=150;
17 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
18 SET SESSION mysqlx_max_connections=150;
19 ERROR HY000: Variable 'mysqlx_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
20 SET GLOBAL mysqlx_max_connections=0;
21 Warnings:
22 Warning 1292 Truncated incorrect mysqlx_max_connections value: '0'
23 SET GLOBAL mysqlx_max_connections=-848;
24 Warnings:
25 Warning 1292 Truncated incorrect mysqlx_max_connections value: '-848'
26 SET GLOBAL mysqlx_max_connections='%45*#in';
27 ERROR 42000: Incorrect argument type to variable 'mysqlx_max_connections'
28 show variables like 'mysqlx_max_connections';
29 Variable_name Value
30 mysqlx_max_connections 1
31 SET @@global.mysqlx_max_connections=151;
32 SET @@global.mysqlx_max_connections= @mysqlx_max_connections_sav;