Debian Codegraph @

mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.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 SET @@global.delayed_queue_size = 18446744073709551615;
62 SELECT @@global.delayed_queue_size;
63 @@global.delayed_queue_size
64 18446744073709551615
65 Warnings:
66 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
67 '#--------------------FN_DYNVARS_026_04-------------------------#'
68 SET @@global.delayed_queue_size = 0;
69 Warnings:
70 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
71 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
72 SELECT @@global.delayed_queue_size;
73 @@global.delayed_queue_size
74 1
75 Warnings:
76 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
77 SET @@global.delayed_queue_size = -1024;
78 Warnings:
79 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
80 Warning 1292 Truncated incorrect delayed_queue_size value: '-1024'
81 SELECT @@global.delayed_queue_size;
82 @@global.delayed_queue_size
83 1
84 Warnings:
85 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
86 SET @@global.delayed_queue_size = 429496729.5;
87 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
88 SELECT @@global.delayed_queue_size;
89 @@global.delayed_queue_size
90 1
91 Warnings:
92 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
93 SET @@global.delayed_queue_size = ON;
94 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
95 SELECT @@delayed_queue_size;
96 @@delayed_queue_size
97 1
98 Warnings:
99 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
100 SET @@global.delayed_queue_size = 18446744073709551616;
101 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
102 SELECT @@global.delayed_queue_size;
103 @@global.delayed_queue_size
104 1
105 Warnings:
106 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
107 '#-------------------FN_DYNVARS_026_05----------------------------#'
108 SET @@session.delayed_queue_size = 0;
109 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
110 SELECT @@session.delayed_queue_size;
111 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
112 '#----------------------FN_DYNVARS_026_06------------------------#'
113 SELECT VARIABLE_VALUE
114 FROM performance_schema.global_variables
115 WHERE VARIABLE_NAME='delayed_queue_size'
116 into @tmp;
117 SELECT @@global.delayed_queue_size = @tmp;
118 @@global.delayed_queue_size = @tmp
119 1
120 Warnings:
121 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
122 SELECT VARIABLE_VALUE
123 FROM performance_schema.session_variables
124 WHERE VARIABLE_NAME='delayed_queue_size'
125 into @tmp;
126 SELECT @@delayed_queue_size = @tmp;
127 @@delayed_queue_size = @tmp
128 1
129 Warnings:
130 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
131 '#---------------------FN_DYNVARS_026_07----------------------#'
132 SET @@global.delayed_queue_size = TRUE;
133 Warnings:
134 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
135 SELECT @@global.delayed_queue_size;
136 @@global.delayed_queue_size
137 1
138 Warnings:
139 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
140 SET @@global.delayed_queue_size = FALSE;
141 Warnings:
142 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
143 Warning 1292 Truncated incorrect delayed_queue_size value: '0'
144 SELECT @@global.delayed_queue_size;
145 @@global.delayed_queue_size
146 1
147 Warnings:
148 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
149 '#---------------------FN_DYNVARS_026_08----------------------#'
150 SET @@global.delayed_queue_size = 1;
151 Warnings:
152 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
153 SELECT @@delayed_queue_size = @@global.delayed_queue_size;
154 @@delayed_queue_size = @@global.delayed_queue_size
155 1
156 Warnings:
157 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
158 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
159 '#---------------------FN_DYNVARS_026_09----------------------#'
160 SET delayed_queue_size = 1;
161 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
162 SELECT @@delayed_queue_size;
163 @@delayed_queue_size
164 1
165 Warnings:
166 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
167 SET local.delayed_queue_size = 1;
168 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
169 SELECT local.delayed_queue_size;
170 ERROR 42S02: Unknown table 'local' in field list
171 SET global.delayed_queue_size = 1;
172 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
173 SELECT global.delayed_queue_size;
174 ERROR 42S02: Unknown table 'global' in field list
175 SELECT delayed_queue_size;
176 ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list'
177 SELECT @@session.delayed_queue_size;
178 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
179 SET @@global.delayed_queue_size = @start_value;
180 Warnings:
181 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.
182 SELECT @@global.delayed_queue_size;
183 @@global.delayed_queue_size
184 1000
185 Warnings:
186 Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release.