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
83SET @@global.max_user_connections = ' ';
84ERROR 42000: Incorrect argument type to variable 'max_user_connections'
85SELECT @@global.max_user_connections;
86@@global.max_user_connections
874294967295
88'#------------------FN_DYNVARS_087_06-----------------------#'
89SELECT @@global.max_user_connections = VARIABLE_VALUE
90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91WHERE VARIABLE_NAME='max_user_connections';
92@@global.max_user_connections = VARIABLE_VALUE
931
94'#------------------FN_DYNVARS_087_08-----------------------#'
95SET @@global.max_user_connections = TRUE;
96SELECT @@global.max_user_connections;
97@@global.max_user_connections
981
99SET @@global.max_user_connections = FALSE;
100SELECT @@global.max_user_connections;
101@@global.max_user_connections
1020
103'#---------------------FN_DYNVARS_087_09----------------------#'
104SET @@global.max_user_connections = 20;
105SELECT @@max_user_connections = @@global.max_user_connections;
106@@max_user_connections = @@global.max_user_connections
1071
108'#---------------------FN_DYNVARS_087_11----------------------#'
109SET @@global.max_user_connections = 102;
110SELECT @@max_user_connections;
111@@max_user_connections
112102
113SELECT local.max_user_connections;
114ERROR 42S02: Unknown table 'local' in field list
115SELECT session.max_user_connections;
116ERROR 42S02: Unknown table 'session' in field list
117SELECT max_user_connections = @@session.max_user_connections;
118ERROR 42S22: Unknown column 'max_user_connections' in 'field list'
119SET @@global.max_user_connections = @start_global_value;
120SELECT @@global.max_user_connections;
121@@global.max_user_connections
1220
123