Debian Codegraph @

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

raw
1 SET @start_value = @@global.delayed_queue_size;
2 Warnings:
3 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
4 SELECT @start_value;
5 @start_value
6 1000
7 '#--------------------FN_DYNVARS_026_01------------------------#'
8 SET @@global.delayed_queue_size = 100;
9 Warnings:
10 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
11 SET @@global.delayed_queue_size = DEFAULT;
12 Warnings:
13 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
14 SELECT @@global.delayed_queue_size;
15 @@global.delayed_queue_size
16 1000
17 Warnings:
18 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
19 '#---------------------FN_DYNVARS_026_02-------------------------#'
20 SET @@global.delayed_queue_size = @start_value;
21 Warnings:
22 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
23 SELECT @@global.delayed_queue_size = 1000;
24 @@global.delayed_queue_size = 1000
25 1
26 Warnings:
27 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
28 '#--------------------FN_DYNVARS_026_03------------------------#'
29 SET @@global.delayed_queue_size = 1;
30 Warnings:
31 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
32 SELECT @@global.delayed_queue_size;
33 @@global.delayed_queue_size
34 1
35 Warnings:
36 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
37 SET @@global.delayed_queue_size = 10000;
38 Warnings:
39 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
40 SELECT @@global.delayed_queue_size;
41 @@global.delayed_queue_size
42 10000
43 Warnings:
44 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
45 SET @@global.delayed_queue_size = 4294967295;
46 Warnings:
47 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
48 SELECT @@global.delayed_queue_size;
49 @@global.delayed_queue_size
50 4294967295
51 Warnings:
52 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
53 SET @@global.delayed_queue_size = 1;
54 Warnings:
55 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
56 SELECT @@global.delayed_queue_size;
57 @@global.delayed_queue_size
58 1
59 Warnings:
60 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
61 '#--------------------FN_DYNVARS_026_04-------------------------#'
62 SET @@global.delayed_queue_size = 0;
63 Warnings:
64 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
65 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
66 SELECT @@global.delayed_queue_size;
67 @@global.delayed_queue_size
68 1
69 Warnings:
70 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
71 SET @@global.delayed_queue_size = -1024;
72 Warnings:
73 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
74 Warning 1292 Truncated incorrect delayed_queue_size value: '-1024'
75 SELECT @@global.delayed_queue_size;
76 @@global.delayed_queue_size
77 1
78 Warnings:
79 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
80 SET @@global.delayed_queue_size = 429496729.5;
81 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
82 SELECT @@global.delayed_queue_size;
83 @@global.delayed_queue_size
84 1
85 Warnings:
86 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
87 SET @@global.delayed_queue_size = ON;
88 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
89 SELECT @@delayed_queue_size;
90 @@delayed_queue_size
91 1
92 Warnings:
93 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
94 SET @@global.delayed_queue_size = 4294967296;
95 Warnings:
96 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
97 Warning 1292 Truncated incorrect delayed_queue_size value: '4294967296'
98 SELECT @@global.delayed_queue_size;
99 @@global.delayed_queue_size
100 4294967295
101 Warnings:
102 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
103 SET @@global.delayed_queue_size = 42949672950;
104 Warnings:
105 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
106 Warning 1292 Truncated incorrect delayed_queue_size value: '42949672950'
107 SELECT @@global.delayed_queue_size;
108 @@global.delayed_queue_size
109 4294967295
110 Warnings:
111 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
112 '#-------------------FN_DYNVARS_026_05----------------------------#'
113 SET @@session.delayed_queue_size = 0;
114 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
115 SELECT @@session.delayed_queue_size;
116 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
117 '#----------------------FN_DYNVARS_026_06------------------------#'
118 SELECT VARIABLE_VALUE
119 FROM performance_schema.global_variables
120 WHERE VARIABLE_NAME='delayed_queue_size'
121 into @tmp;
122 SELECT @@global.delayed_queue_size = @tmp;
123 @@global.delayed_queue_size = @tmp
124 1
125 Warnings:
126 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
127 SELECT VARIABLE_VALUE
128 FROM performance_schema.session_variables
129 WHERE VARIABLE_NAME='delayed_queue_size'
130 into @tmp;
131 SELECT @@delayed_queue_size = @tmp;
132 @@delayed_queue_size = @tmp
133 1
134 Warnings:
135 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
136 '#---------------------FN_DYNVARS_026_07----------------------#'
137 SET @@global.delayed_queue_size = TRUE;
138 Warnings:
139 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
140 SELECT @@global.delayed_queue_size;
141 @@global.delayed_queue_size
142 1
143 Warnings:
144 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
145 SET @@global.delayed_queue_size = FALSE;
146 Warnings:
147 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
148 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
149 SELECT @@global.delayed_queue_size;
150 @@global.delayed_queue_size
151 1
152 Warnings:
153 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
154 '#---------------------FN_DYNVARS_026_08----------------------#'
155 SET @@global.delayed_queue_size = 1;
156 Warnings:
157 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
158 SELECT @@delayed_queue_size = @@global.delayed_queue_size;
159 @@delayed_queue_size = @@global.delayed_queue_size
160 1
161 Warnings:
162 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
163 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
164 '#---------------------FN_DYNVARS_026_09----------------------#'
165 SET delayed_queue_size = 1;
166 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
167 SELECT @@delayed_queue_size;
168 @@delayed_queue_size
169 1
170 Warnings:
171 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
172 SET local.delayed_queue_size = 1;
173 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.delayed_queue_size = 1' at line 1
174 SELECT local.delayed_queue_size;
175 ERROR 42S02: Unknown table 'local' in field list
176 SET global.delayed_queue_size = 1;
177 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.delayed_queue_size = 1' at line 1
178 SELECT global.delayed_queue_size;
179 ERROR 42S02: Unknown table 'global' in field list
180 SELECT delayed_queue_size;
181 ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list'
182 SELECT @@session.delayed_queue_size;
183 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
184 SET @@global.delayed_queue_size = @start_value;
185 Warnings:
186 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
187 SELECT @@global.delayed_queue_size;
188 @@global.delayed_queue_size
189 1000
190 Warnings:
191 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.