Debian Codegraph @

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

raw
1 SET @start_value = @@global.max_connections;
2 SELECT @start_value;
3 @start_value
4 151
5 '#--------------------FN_DYNVARS_074_01------------------------#'
6 SET @@global.max_connections = 5000;
7 SET @@global.max_connections = DEFAULT;
8 SELECT @@global.max_connections;
9 @@global.max_connections
10 151
11 '#---------------------FN_DYNVARS_074_02-------------------------#'
12 SET @@global.max_connections = @start_value;
13 SELECT @@global.max_connections = 151;
14 @@global.max_connections = 151
15 1
16 '#--------------------FN_DYNVARS_074_03------------------------#'
17 SET @@global.max_connections = 100000;
18 SELECT @@global.max_connections;
19 @@global.max_connections
20 100000
21 SET @@global.max_connections = 99999;
22 SELECT @@global.max_connections;
23 @@global.max_connections
24 99999
25 SET @@global.max_connections = 65536;
26 SELECT @@global.max_connections;
27 @@global.max_connections
28 65536
29 SET @@global.max_connections = 1;
30 SELECT @@global.max_connections;
31 @@global.max_connections
32 1
33 SET @@global.max_connections = 2;
34 SELECT @@global.max_connections;
35 @@global.max_connections
36 2
37 '#--------------------FN_DYNVARS_074_04-------------------------#'
38 SET @@global.max_connections = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect max_connections value: '-1'
41 SELECT @@global.max_connections;
42 @@global.max_connections
43 1
44 SET @@global.max_connections = 100000000000;
45 Warnings:
46 Warning 1292 Truncated incorrect max_connections value: '100000000000'
47 SELECT @@global.max_connections;
48 @@global.max_connections
49 100000
50 SET @@global.max_connections = 10000.01;
51 ERROR 42000: Incorrect argument type to variable 'max_connections'
52 SELECT @@global.max_connections;
53 @@global.max_connections
54 100000
55 SET @@global.max_connections = -1024;
56 Warnings:
57 Warning 1292 Truncated incorrect max_connections value: '-1024'
58 SELECT @@global.max_connections;
59 @@global.max_connections
60 1
61 SET @@global.max_connections = 0;
62 Warnings:
63 Warning 1292 Truncated incorrect max_connections value: '0'
64 SELECT @@global.max_connections;
65 @@global.max_connections
66 1
67 SET @@global.max_connections = 100001;
68 Warnings:
69 Warning 1292 Truncated incorrect max_connections value: '100001'
70 SELECT @@global.max_connections;
71 @@global.max_connections
72 100000
73 SET @@global.max_connections = ON;
74 ERROR 42000: Incorrect argument type to variable 'max_connections'
75 SELECT @@global.max_connections;
76 @@global.max_connections
77 100000
78 SET @@global.max_connections = 'test';
79 ERROR 42000: Incorrect argument type to variable 'max_connections'
80 SELECT @@global.max_connections;
81 @@global.max_connections
82 100000
83 SET @@global.max_connections = ' ';
84 ERROR 42000: Incorrect argument type to variable 'max_connections'
85 SELECT @@global.max_connections;
86 @@global.max_connections
87 100000
88 '#-------------------FN_DYNVARS_074_05----------------------------#'
89 SET @@session.max_connections = 4096;
90 ERROR HY000: Variable 'max_connections' is a GLOBAL variable and should be set with SET GLOBAL
91 SELECT @@session.max_connections;
92 ERROR HY000: Variable 'max_connections' is a GLOBAL variable
93 '#----------------------FN_DYNVARS_074_06------------------------#'
94 SELECT @@global.max_connections = VARIABLE_VALUE
95 FROM performance_schema.global_variables
96 WHERE VARIABLE_NAME='max_connections';
97 @@global.max_connections = VARIABLE_VALUE
98 1
99 SELECT @@max_connections = VARIABLE_VALUE
100 FROM performance_schema.session_variables
101 WHERE VARIABLE_NAME='max_connections';
102 @@max_connections = VARIABLE_VALUE
103 1
104 '#---------------------FN_DYNVARS_074_07----------------------#'
105 SET @@global.max_connections = TRUE;
106 SELECT @@global.max_connections;
107 @@global.max_connections
108 1
109 SET @@global.max_connections = FALSE;
110 Warnings:
111 Warning 1292 Truncated incorrect max_connections value: '0'
112 SELECT @@global.max_connections;
113 @@global.max_connections
114 1
115 '#---------------------FN_DYNVARS_074_08----------------------#'
116 SET @@global.max_connections = 5000;
117 SELECT @@max_connections = @@global.max_connections;
118 @@max_connections = @@global.max_connections
119 1
120 '#---------------------FN_DYNVARS_074_09----------------------#'
121 SET max_connections = 6000;
122 ERROR HY000: Variable 'max_connections' is a GLOBAL variable and should be set with SET GLOBAL
123 SELECT @@max_connections;
124 @@max_connections
125 5000
126 SET local.max_connections = 7000;
127 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 'local.max_connections = 7000' at line 1
128 SELECT local.max_connections;
129 ERROR 42S02: Unknown table 'local' in field list
130 SET global.max_connections = 8000;
131 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 'global.max_connections = 8000' at line 1
132 SELECT global.max_connections;
133 ERROR 42S02: Unknown table 'global' in field list
134 SELECT max_connections;
135 ERROR 42S22: Unknown column 'max_connections' in 'field list'
136 SELECT @@session.max_connections;
137 ERROR HY000: Variable 'max_connections' is a GLOBAL variable
138 SET @@global.max_connections = @start_value;
139 SELECT @@global.max_connections;
140 @@global.max_connections
141 151