Debian Codegraph @

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

raw
1 # ulong global
2
3 SET @start_global_value = @@global.extra_max_connections;
4
5 #
6 # exists as global only
7 #
8 select @@global.extra_max_connections;
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 select @@session.extra_max_connections;
11 show global variables like 'extra_max_connections';
12 show session variables like 'extra_max_connections';
13 select * from information_schema.global_variables where variable_name='extra_max_connections';
14 select * from information_schema.session_variables where variable_name='extra_max_connections';
15
16 #
17 # show that it's writable
18 #
19 set global extra_max_connections=1;
20 select @@global.extra_max_connections;
21 --error ER_GLOBAL_VARIABLE
22 set session extra_max_connections=1;
23
24 #
25 # incorrect types
26 #
27 --error ER_WRONG_TYPE_FOR_VAR
28 set global extra_max_connections=1.1;
29 --error ER_WRONG_TYPE_FOR_VAR
30 set global extra_max_connections=1e1;
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global extra_max_connections="foo";
33
34 #
35 # min/max values
36 #
37 set global extra_max_connections=0;
38 select @@global.extra_max_connections;
39 set global extra_max_connections=cast(-1 as unsigned int);
40 select @@global.extra_max_connections;
41
42 SET @@global.extra_max_connections = @start_global_value;