Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.extra_max_connections;
2 select @@global.extra_max_connections;
3 @@global.extra_max_connections
4 1
5 select @@session.extra_max_connections;
6 ERROR HY000: Variable 'extra_max_connections' is a GLOBAL variable
7 show global variables like 'extra_max_connections';
8 Variable_name Value
9 extra_max_connections 1
10 show session variables like 'extra_max_connections';
11 Variable_name Value
12 extra_max_connections 1
13 select * from information_schema.global_variables where variable_name='extra_max_connections';
14 VARIABLE_NAME VARIABLE_VALUE
15 EXTRA_MAX_CONNECTIONS 1
16 select * from information_schema.session_variables where variable_name='extra_max_connections';
17 VARIABLE_NAME VARIABLE_VALUE
18 EXTRA_MAX_CONNECTIONS 1
19 set global extra_max_connections=1;
20 select @@global.extra_max_connections;
21 @@global.extra_max_connections
22 1
23 set session extra_max_connections=1;
24 ERROR HY000: Variable 'extra_max_connections' is a GLOBAL variable and should be set with SET GLOBAL
25 set global extra_max_connections=1.1;
26 ERROR 42000: Incorrect argument type to variable 'extra_max_connections'
27 set global extra_max_connections=1e1;
28 ERROR 42000: Incorrect argument type to variable 'extra_max_connections'
29 set global extra_max_connections="foo";
30 ERROR 42000: Incorrect argument type to variable 'extra_max_connections'
31 set global extra_max_connections=0;
32 Warnings:
33 Warning 1292 Truncated incorrect extra_max_connections value: '0'
34 select @@global.extra_max_connections;
35 @@global.extra_max_connections
36 1
37 set global extra_max_connections=cast(-1 as unsigned int);
38 Warnings:
39 Note 1105 Cast to unsigned converted negative integer to it's positive complement
40 Warning 1292 Truncated incorrect extra_max_connections value: '18446744073709551615'
41 select @@global.extra_max_connections;
42 @@global.extra_max_connections
43 100000
44 SET @@global.extra_max_connections = @start_global_value;