Debian Codegraph @

mysql-test/suite/sys_vars/r/max_user_connections_basic.result

raw
1 SET @start_global_value = @@global.max_user_connections;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.max_user_connections;
6 SELECT @start_session_value;
7 @start_session_value
8 0
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
14 0
15 SET @@session.max_user_connections = 1000;
16 ERROR HY000: SESSION variable 'max_user_connections' is read-only. Use SET GLOBAL to assign the value
17 '#--------------------FN_DYNVARS_087_02-------------------------#'
18 SET @@global.max_user_connections = DEFAULT;
19 SELECT @@global.max_user_connections = 0;
20 @@global.max_user_connections = 0
21 1
22 SET @@session.max_user_connections = DEFAULT;
23 ERROR HY000: SESSION variable 'max_user_connections' is read-only. Use SET GLOBAL to assign the value
24 SELECT @@session.max_user_connections;
25 @@session.max_user_connections
26 0
27 '#--------------------FN_DYNVARS_087_03-------------------------#'
28 SET @@global.max_user_connections = 1;
29 SELECT @@global.max_user_connections;
30 @@global.max_user_connections
31 1
32 SET @@global.max_user_connections = 2;
33 SELECT @@global.max_user_connections;
34 @@global.max_user_connections
35 2
36 SET @@global.max_user_connections = 65536;
37 SELECT @@global.max_user_connections;
38 @@global.max_user_connections
39 65536
40 SET @@global.max_user_connections = 4294967295;
41 SELECT @@global.max_user_connections;
42 @@global.max_user_connections
43 4294967295
44 SET @@global.max_user_connections = 4294967294;
45 SELECT @@global.max_user_connections;
46 @@global.max_user_connections
47 4294967294
48 '#------------------FN_DYNVARS_087_05-----------------------#'
49 SET @@global.max_user_connections = -1024;
50 Warnings:
51 Warning 1292 Truncated incorrect max_user_connections value: '-1024'
52 SELECT @@global.max_user_connections;
53 @@global.max_user_connections
54 0
55 SET @@global.max_user_connections = 4294967296;
56 Warnings:
57 Warning 1292 Truncated incorrect max_user_connections value: '4294967296'
58 SELECT @@global.max_user_connections;
59 @@global.max_user_connections
60 4294967295
61 SET @@global.max_user_connections = -1;
62 Warnings:
63 Warning 1292 Truncated incorrect max_user_connections value: '-1'
64 SELECT @@global.max_user_connections;
65 @@global.max_user_connections
66 0
67 SET @@global.max_user_connections = 429496729500;
68 Warnings:
69 Warning 1292 Truncated incorrect max_user_connections value: '429496729500'
70 SELECT @@global.max_user_connections;
71 @@global.max_user_connections
72 4294967295
73 SET @@global.max_user_connections = 65530.34;
74 ERROR 42000: Incorrect argument type to variable 'max_user_connections'
75 SELECT @@global.max_user_connections;
76 @@global.max_user_connections
77 4294967295
78 SET @@global.max_user_connections = test;
79 ERROR 42000: Incorrect argument type to variable 'max_user_connections'
80 SELECT @@global.max_user_connections;
81 @@global.max_user_connections
82 4294967295
83 SET @@global.max_user_connections = ' ';
84 ERROR 42000: Incorrect argument type to variable 'max_user_connections'
85 SELECT @@global.max_user_connections;
86 @@global.max_user_connections
87 4294967295
88 '#------------------FN_DYNVARS_087_06-----------------------#'
89 SELECT @@global.max_user_connections = VARIABLE_VALUE
90 FROM performance_schema.global_variables
91 WHERE VARIABLE_NAME='max_user_connections';
92 @@global.max_user_connections = VARIABLE_VALUE
93 1
94 '#------------------FN_DYNVARS_087_08-----------------------#'
95 SET @@global.max_user_connections = TRUE;
96 SELECT @@global.max_user_connections;
97 @@global.max_user_connections
98 1
99 SET @@global.max_user_connections = FALSE;
100 SELECT @@global.max_user_connections;
101 @@global.max_user_connections
102 0
103 '#---------------------FN_DYNVARS_087_09----------------------#'
104 SET @@global.max_user_connections = 20;
105 SELECT @@max_user_connections = @@global.max_user_connections;
106 @@max_user_connections = @@global.max_user_connections
107 1
108 '#---------------------FN_DYNVARS_087_11----------------------#'
109 SET @@global.max_user_connections = 102;
110 SELECT @@max_user_connections;
111 @@max_user_connections
112 102
113 SELECT local.max_user_connections;
114 ERROR 42S02: Unknown table 'local' in field list
115 SELECT session.max_user_connections;
116 ERROR 42S02: Unknown table 'session' in field list
117 SELECT max_user_connections = @@session.max_user_connections;
118 ERROR 42S22: Unknown column 'max_user_connections' in 'field list'
119 SET @@global.max_user_connections = @start_global_value;
120 SELECT @@global.max_user_connections;
121 @@global.max_user_connections
122 0