1
SET @start_global_value = @@global.max_user_connections;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_user_connections;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_087_01-------------------------#'
10
SET @@global.max_user_connections = 1000;
11
SET @@global.max_user_connections = DEFAULT;
12
SELECT @@global.max_user_connections;
13
@@global.max_user_connections
15
SET @@session.max_user_connections = 1000;
16
ERROR HY000: Variable 'max_user_connections' is a GLOBAL variable and should be set with SET GLOBAL
17
SET @@session.max_user_connections = DEFAULT;
18
ERROR 42000: Variable 'max_user_connections' doesn't have a default value
19
SELECT @@session.max_user_connections;
20
@@session.max_user_connections
22
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
23
'#--------------------FN_DYNVARS_087_02-------------------------#'
24
SET @@global.max_user_connections = DEFAULT;
25
SELECT @@global.max_user_connections = 0;
26
@@global.max_user_connections = 0
28
SET @@session.max_user_connections = DEFAULT;
29
ERROR 42000: Variable 'max_user_connections' doesn't have a default value
30
SELECT @@session.max_user_connections = 0;
31
@@session.max_user_connections = 0
33
'#--------------------FN_DYNVARS_087_03-------------------------#'
34
SET @@global.max_user_connections = 1;
35
SELECT @@global.max_user_connections;
36
@@global.max_user_connections
38
SET @@global.max_user_connections = 2;
39
SELECT @@global.max_user_connections;
40
@@global.max_user_connections
42
SET @@global.max_user_connections = 65536;
43
SELECT @@global.max_user_connections;
44
@@global.max_user_connections
46
SET @@global.max_user_connections = 4294967295;
47
SELECT @@global.max_user_connections;
48
@@global.max_user_connections
50
SET @@global.max_user_connections = 4294967294;
51
SELECT @@global.max_user_connections;
52
@@global.max_user_connections
54
'#------------------FN_DYNVARS_087_05-----------------------#'
55
SET @@global.max_user_connections = -1024;
56
SELECT @@global.max_user_connections;
57
@@global.max_user_connections
59
SET @@global.max_user_connections = 4294967296;
60
SELECT @@global.max_user_connections;
61
@@global.max_user_connections
63
SET @@global.max_user_connections = -1;
64
SELECT @@global.max_user_connections;
65
@@global.max_user_connections
67
SET @@global.max_user_connections = 429496729500;
68
SELECT @@global.max_user_connections;
69
@@global.max_user_connections
71
SET @@global.max_user_connections = 65530.34.;
72
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
73
SELECT @@global.max_user_connections;
74
@@global.max_user_connections
76
SET @@global.max_user_connections = test;
77
ERROR 42000: Incorrect argument type to variable 'max_user_connections'
78
SELECT @@global.max_user_connections;
79
@@global.max_user_connections
81
'#------------------FN_DYNVARS_087_06-----------------------#'
82
SELECT @@global.max_user_connections = VARIABLE_VALUE
83
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
84
WHERE VARIABLE_NAME='max_user_connections';
85
@@global.max_user_connections = VARIABLE_VALUE
87
'#------------------FN_DYNVARS_087_08-----------------------#'
88
SET @@global.max_user_connections = TRUE;
89
SELECT @@global.max_user_connections;
90
@@global.max_user_connections
92
SET @@global.max_user_connections = FALSE;
93
SELECT @@global.max_user_connections;
94
@@global.max_user_connections
96
'#---------------------FN_DYNVARS_087_09----------------------#'
97
SET @@global.max_user_connections = 20;
98
SELECT @@max_user_connections = @@global.max_user_connections;
99
@@max_user_connections = @@global.max_user_connections
101
'#---------------------FN_DYNVARS_087_11----------------------#'
102
SET @@global.max_user_connections = 102;
103
SELECT @@max_user_connections;
104
@@max_user_connections
106
SELECT local.max_user_connections;
107
ERROR 42S02: Unknown table 'local' in field list
108
SELECT session.max_user_connections;
109
ERROR 42S02: Unknown table 'session' in field list
110
SELECT max_user_connections = @@session.max_user_connections;
111
ERROR 42S22: Unknown column 'max_user_connections' in 'field list'
112
SET @@global.max_user_connections = @start_global_value;
113
SELECT @@global.max_user_connections;
114
@@global.max_user_connections