Debian Codegraph @

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

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