1SET @start_global_value = @@global.max_user_connections;
2SELECT @start_global_value;
3@start_global_value
40
5SET @start_session_value = @@session.max_user_connections;
6SELECT @start_session_value;
7@start_session_value
80
9'#--------------------FN_DYNVARS_087_01-------------------------#'
10SET @@global.max_user_connections = 1000;
11SET @@global.max_user_connections = DEFAULT;
12SELECT @@global.max_user_connections;
13@@global.max_user_connections
140
15SET @@session.max_user_connections = 1000;
16ERROR HY000: SESSION variable 'max_user_connections' is read-only. Use SET GLOBAL to assign the value
17'#--------------------FN_DYNVARS_087_02-------------------------#'
18SET @@global.max_user_connections = DEFAULT;
19SELECT @@global.max_user_connections = 0;
20@@global.max_user_connections = 0
211
22SET @@session.max_user_connections = DEFAULT;
23ERROR HY000: SESSION variable 'max_user_connections' is read-only. Use SET GLOBAL to assign the value
24SELECT @@session.max_user_connections;
25@@session.max_user_connections
260
27'#--------------------FN_DYNVARS_087_03-------------------------#'
28SET @@global.max_user_connections = 1;
29SELECT @@global.max_user_connections;
30@@global.max_user_connections
311
32SET @@global.max_user_connections = 2;
33SELECT @@global.max_user_connections;
34@@global.max_user_connections
352
36SET @@global.max_user_connections = 65536;
37SELECT @@global.max_user_connections;
38@@global.max_user_connections
3965536
40SET @@global.max_user_connections = 4294967295;
41SELECT @@global.max_user_connections;
42@@global.max_user_connections
434294967295
44SET @@global.max_user_connections = 4294967294;
45SELECT @@global.max_user_connections;
46@@global.max_user_connections
474294967294
48'#------------------FN_DYNVARS_087_05-----------------------#'
49SET @@global.max_user_connections = -1024;
50Warnings:
51Warning	1292	Truncated incorrect max_user_connections value: '-1024'
52SELECT @@global.max_user_connections;
53@@global.max_user_connections
540
55SET @@global.max_user_connections = 4294967296;
56Warnings:
57Warning	1292	Truncated incorrect max_user_connections value: '4294967296'
58SELECT @@global.max_user_connections;
59@@global.max_user_connections
604294967295
61SET @@global.max_user_connections = -1;
62Warnings:
63Warning	1292	Truncated incorrect max_user_connections value: '-1'
64SELECT @@global.max_user_connections;
65@@global.max_user_connections
660
67SET @@global.max_user_connections = 429496729500;
68Warnings:
69Warning	1292	Truncated incorrect max_user_connections value: '429496729500'
70SELECT @@global.max_user_connections;
71@@global.max_user_connections
724294967295
73SET @@global.max_user_connections = 65530.34;
74ERROR 42000: Incorrect argument type to variable 'max_user_connections'
75SELECT @@global.max_user_connections;
76@@global.max_user_connections
774294967295
78SET @@global.max_user_connections = test;
79ERROR 42000: Incorrect argument type to variable 'max_user_connections'
80SELECT @@global.max_user_connections;
81@@global.max_user_connections
824294967295
83'#------------------FN_DYNVARS_087_06-----------------------#'
84SELECT @@global.max_user_connections = VARIABLE_VALUE
85FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
86WHERE VARIABLE_NAME='max_user_connections';
87@@global.max_user_connections = VARIABLE_VALUE
881
89'#------------------FN_DYNVARS_087_08-----------------------#'
90SET @@global.max_user_connections = TRUE;
91SELECT @@global.max_user_connections;
92@@global.max_user_connections
931
94SET @@global.max_user_connections = FALSE;
95SELECT @@global.max_user_connections;
96@@global.max_user_connections
970
98'#---------------------FN_DYNVARS_087_09----------------------#'
99SET @@global.max_user_connections = 20;
100SELECT @@max_user_connections = @@global.max_user_connections;
101@@max_user_connections = @@global.max_user_connections
1021
103'#---------------------FN_DYNVARS_087_11----------------------#'
104SET @@global.max_user_connections = 102;
105SELECT @@max_user_connections;
106@@max_user_connections
107102
108SELECT local.max_user_connections;
109ERROR 42S02: Unknown table 'local' in field list
110SELECT session.max_user_connections;
111ERROR 42S02: Unknown table 'session' in field list
112SELECT max_user_connections = @@session.max_user_connections;
113ERROR 42S22: Unknown column 'max_user_connections' in 'field list'
114SET @@global.max_user_connections = @start_global_value;
115SELECT @@global.max_user_connections;
116@@global.max_user_connections
1170
118