Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_delayed_threads;
2 SELECT @start_global_value;
3 @start_global_value
4 20
5 SET @start_session_value = @@session.max_delayed_threads;
6 SELECT @start_session_value;
7 @start_session_value
8 20
9 '#--------------------FN_DYNVARS_075_01-------------------------#'
10 SET @@global.max_delayed_threads = 1000;
11 SET @@global.max_delayed_threads = DEFAULT;
12 SELECT @@global.max_delayed_threads;
13 @@global.max_delayed_threads
14 20
15 SET @@session.max_delayed_threads = 1000;
16 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1000'
17 SET @@session.max_delayed_threads = DEFAULT;
18 SELECT @@session.max_delayed_threads;
19 @@session.max_delayed_threads
20 20
21 '#--------------------FN_DYNVARS_075_02-------------------------#'
22 SET @@global.max_delayed_threads = DEFAULT;
23 SELECT @@global.max_delayed_threads = 20;
24 @@global.max_delayed_threads = 20
25 1
26 SET @@session.max_delayed_threads = DEFAULT;
27 SELECT @@session.max_delayed_threads = 20;
28 @@session.max_delayed_threads = 20
29 1
30 '#--------------------FN_DYNVARS_075_03-------------------------#'
31 SET @@global.max_delayed_threads = 1;
32 SELECT @@global.max_delayed_threads;
33 @@global.max_delayed_threads
34 1
35 SET @@global.max_delayed_threads = 1025;
36 SELECT @@global.max_delayed_threads;
37 @@global.max_delayed_threads
38 1025
39 SET @@global.max_delayed_threads = 0;
40 SELECT @@global.max_delayed_threads;
41 @@global.max_delayed_threads
42 0
43 SET @@global.max_delayed_threads = 16384;
44 SELECT @@global.max_delayed_threads;
45 @@global.max_delayed_threads
46 16384
47 SET @@global.max_delayed_threads = 16383;
48 SELECT @@global.max_delayed_threads;
49 @@global.max_delayed_threads
50 16383
51 '#--------------------FN_DYNVARS_075_04-------------------------#'
52 SET @@session.max_delayed_threads = 1;
53 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1'
54 SELECT @@session.max_delayed_threads;
55 @@session.max_delayed_threads
56 20
57 SET @@session.max_delayed_threads = 1025;
58 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1025'
59 SELECT @@session.max_delayed_threads;
60 @@session.max_delayed_threads
61 20
62 SET @@session.max_delayed_threads = 0;
63 SELECT @@session.max_delayed_threads;
64 @@session.max_delayed_threads
65 0
66 SET @@session.max_delayed_threads = 16384;
67 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '16384'
68 SELECT @@session.max_delayed_threads;
69 @@session.max_delayed_threads
70 0
71 SET @@session.max_delayed_threads = 16383;
72 SELECT @@session.max_delayed_threads;
73 @@session.max_delayed_threads
74 16383
75 '#------------------FN_DYNVARS_075_05-----------------------#'
76 SET @@global.max_delayed_threads = -1024;
77 Warnings:
78 Warning 1292 Truncated incorrect max_delayed_threads value: '-1024'
79 SELECT @@global.max_delayed_threads;
80 @@global.max_delayed_threads
81 0
82 SET @@global.max_delayed_threads = -1;
83 Warnings:
84 Warning 1292 Truncated incorrect max_delayed_threads value: '-1'
85 SELECT @@global.max_delayed_threads;
86 @@global.max_delayed_threads
87 0
88 SET @@global.max_delayed_threads = 16385;
89 Warnings:
90 Warning 1292 Truncated incorrect max_delayed_threads value: '16385'
91 SELECT @@global.max_delayed_threads;
92 @@global.max_delayed_threads
93 16384
94 SET @@global.max_delayed_threads = 65530.34;
95 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
96 SELECT @@global.max_delayed_threads;
97 @@global.max_delayed_threads
98 16384
99 SET @@global.max_delayed_threads = test;
100 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
101 SELECT @@global.max_delayed_threads;
102 @@global.max_delayed_threads
103 16384
104 SET @@session.max_delayed_threads = 16385;
105 Warnings:
106 Warning 1292 Truncated incorrect max_delayed_threads value: '16385'
107 SELECT @@session.max_delayed_threads;
108 @@session.max_delayed_threads
109 16384
110 SET @@session.max_delayed_threads = -1;
111 Warnings:
112 Warning 1292 Truncated incorrect max_delayed_threads value: '-1'
113 SELECT @@session.max_delayed_threads;
114 @@session.max_delayed_threads
115 0
116 SET @@session.max_delayed_threads = -2;
117 Warnings:
118 Warning 1292 Truncated incorrect max_delayed_threads value: '-2'
119 SELECT @@session.max_delayed_threads;
120 @@session.max_delayed_threads
121 0
122 SET @@session.max_delayed_threads = 65530.34;
123 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
124 SET @@session.max_delayed_threads = 10737418241;
125 Warnings:
126 Warning 1292 Truncated incorrect max_delayed_threads value: '10737418241'
127 SELECT @@session.max_delayed_threads;
128 @@session.max_delayed_threads
129 16384
130 SET @@session.max_delayed_threads = test;
131 ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
132 SELECT @@session.max_delayed_threads;
133 @@session.max_delayed_threads
134 16384
135 '#------------------FN_DYNVARS_075_06-----------------------#'
136 SELECT @@global.max_delayed_threads = VARIABLE_VALUE
137 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
138 WHERE VARIABLE_NAME='max_delayed_threads';
139 @@global.max_delayed_threads = VARIABLE_VALUE
140 1
141 '#------------------FN_DYNVARS_075_07-----------------------#'
142 SELECT @@session.max_delayed_threads = VARIABLE_VALUE
143 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
144 WHERE VARIABLE_NAME='max_delayed_threads';
145 @@session.max_delayed_threads = VARIABLE_VALUE
146 1
147 '#------------------FN_DYNVARS_075_08-----------------------#'
148 SET @@global.max_delayed_threads = TRUE;
149 SELECT @@global.max_delayed_threads;
150 @@global.max_delayed_threads
151 1
152 SET @@global.max_delayed_threads = FALSE;
153 SELECT @@global.max_delayed_threads;
154 @@global.max_delayed_threads
155 0
156 '#---------------------FN_DYNVARS_001_09----------------------#'
157 SET @@global.max_delayed_threads = 2048;
158 SELECT @@max_delayed_threads = @@global.max_delayed_threads;
159 @@max_delayed_threads = @@global.max_delayed_threads
160 0
161 '#---------------------FN_DYNVARS_001_10----------------------#'
162 SET @@max_delayed_threads = 100000;
163 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '100000'
164 SELECT @@max_delayed_threads = @@local.max_delayed_threads;
165 @@max_delayed_threads = @@local.max_delayed_threads
166 1
167 SELECT @@local.max_delayed_threads = @@session.max_delayed_threads;
168 @@local.max_delayed_threads = @@session.max_delayed_threads
169 1
170 '#---------------------FN_DYNVARS_001_11----------------------#'
171 SET max_delayed_threads = 1024;
172 ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1024'
173 SELECT @@max_delayed_threads;
174 @@max_delayed_threads
175 16384
176 SELECT local.max_delayed_threads;
177 ERROR 42S02: Unknown table 'local' in SELECT
178 SELECT session.max_delayed_threads;
179 ERROR 42S02: Unknown table 'session' in SELECT
180 SELECT max_delayed_threads = @@session.max_delayed_threads;
181 ERROR 42S22: Unknown column 'max_delayed_threads' in 'SELECT'
182 SET @@global.max_delayed_threads = @start_global_value;
183 SELECT @@global.max_delayed_threads;
184 @@global.max_delayed_threads
185 20
186 SET @@session.max_delayed_threads = @start_session_value;
187 SELECT @@session.max_delayed_threads;
188 @@session.max_delayed_threads
189 20