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 10
5 SET @start_session_value = @@session.max_user_connections;
6 SELECT @start_session_value;
7 @start_session_value
8 10
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 = 2147483647;
41 SELECT @@global.max_user_connections;
42 @@global.max_user_connections
43 2147483647
44 SET @@global.max_user_connections = 2147483646;
45 SELECT @@global.max_user_connections;
46 @@global.max_user_connections
47 2147483646
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 -1
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 2147483647
61 SET @@global.max_user_connections = -1;
62 SELECT @@global.max_user_connections;
63 @@global.max_user_connections
64 -1
65 SET @@global.max_user_connections = 429496729500;
66 Warnings:
67 Warning 1292 Truncated incorrect max_user_connections value: '429496729500'
68 SELECT @@global.max_user_connections;
69 @@global.max_user_connections
70 2147483647
71 SET @@global.max_user_connections = 65530.34;
72 ERROR 42000: Incorrect argument type to variable 'max_user_connections'
73 SELECT @@global.max_user_connections;
74 @@global.max_user_connections
75 2147483647
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
80 2147483647
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
86 1
87 '#------------------FN_DYNVARS_087_08-----------------------#'
88 SET @@global.max_user_connections = TRUE;
89 SELECT @@global.max_user_connections;
90 @@global.max_user_connections
91 1
92 SET @@global.max_user_connections = FALSE;
93 SELECT @@global.max_user_connections;
94 @@global.max_user_connections
95 0
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
100 1
101 '#---------------------FN_DYNVARS_087_11----------------------#'
102 SET @@global.max_user_connections = 102;
103 SELECT @@max_user_connections;
104 @@max_user_connections
105 102
106 SELECT local.max_user_connections;
107 ERROR 42S02: Unknown table 'local' in SELECT
108 SELECT session.max_user_connections;
109 ERROR 42S02: Unknown table 'session' in SELECT
110 SELECT max_user_connections = @@session.max_user_connections;
111 ERROR 42S22: Unknown column 'max_user_connections' in 'SELECT'
112 SET @@global.max_user_connections = @start_global_value;
113 SELECT @@global.max_user_connections;
114 @@global.max_user_connections
115 10