1SET @start_global_value = @@global.max_user_connections;
2SELECT @start_global_value;
3@start_global_value
410
5SET @start_session_value = @@session.max_user_connections;
6SELECT @start_session_value;
7@start_session_value
810
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 = 2147483647;
41SELECT @@global.max_user_connections;
42@@global.max_user_connections
432147483647
44SET @@global.max_user_connections = 2147483646;
45SELECT @@global.max_user_connections;
46@@global.max_user_connections
472147483646
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
54-1
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
602147483647
61SET @@global.max_user_connections = -1;
62SELECT @@global.max_user_connections;
63@@global.max_user_connections
64-1
65SET @@global.max_user_connections = 429496729500;
66Warnings:
67Warning	1292	Truncated incorrect max_user_connections value: '429496729500'
68SELECT @@global.max_user_connections;
69@@global.max_user_connections
702147483647
71SET @@global.max_user_connections = 65530.34;
72ERROR 42000: Incorrect argument type to variable 'max_user_connections'
73SELECT @@global.max_user_connections;
74@@global.max_user_connections
752147483647
76SET @@global.max_user_connections = test;
77ERROR 42000: Incorrect argument type to variable 'max_user_connections'
78SELECT @@global.max_user_connections;
79@@global.max_user_connections
802147483647
81'#------------------FN_DYNVARS_087_06-----------------------#'
82SELECT @@global.max_user_connections = VARIABLE_VALUE
83FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
84WHERE VARIABLE_NAME='max_user_connections';
85@@global.max_user_connections = VARIABLE_VALUE
861
87'#------------------FN_DYNVARS_087_08-----------------------#'
88SET @@global.max_user_connections = TRUE;
89SELECT @@global.max_user_connections;
90@@global.max_user_connections
911
92SET @@global.max_user_connections = FALSE;
93SELECT @@global.max_user_connections;
94@@global.max_user_connections
950
96'#---------------------FN_DYNVARS_087_09----------------------#'
97SET @@global.max_user_connections = 20;
98SELECT @@max_user_connections = @@global.max_user_connections;
99@@max_user_connections = @@global.max_user_connections
1001
101'#---------------------FN_DYNVARS_087_11----------------------#'
102SET @@global.max_user_connections = 102;
103SELECT @@max_user_connections;
104@@max_user_connections
105102
106SELECT local.max_user_connections;
107ERROR 42S02: Unknown table 'local' in field list
108SELECT session.max_user_connections;
109ERROR 42S02: Unknown table 'session' in field list
110SELECT max_user_connections = @@session.max_user_connections;
111ERROR 42S22: Unknown column 'max_user_connections' in 'field list'
112SET @@global.max_user_connections = @start_global_value;
113SELECT @@global.max_user_connections;
114@@global.max_user_connections
11510
116