sys_vars/r/delayed_queue_size_basic_32.result

1 SET @start_value = @@global.delayed_queue_size;
3 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
8 SET @@global.delayed_queue_size = 100;
10 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
11 SET @@global.delayed_queue_size = DEFAULT;
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
18 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
20 SET @@global.delayed_queue_size = @start_value;
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
27 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
29 SET @@global.delayed_queue_size = 10000;
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
36 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
37 SET @@global.delayed_queue_size = 4294967295;
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
44 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
45 SET @@global.delayed_queue_size = 1;
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
52 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
54 SET @@global.delayed_queue_size = 0;
56 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
57 Warning	1292	Truncated incorrect delayed_queue_size value: '0'
58 SELECT @@global.delayed_queue_size;
59 @@global.delayed_queue_size
62 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
63 SET @@global.delayed_queue_size = -1024;
65 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
66 Warning	1292	Truncated incorrect delayed_queue_size value: '-1024'
67 SELECT @@global.delayed_queue_size;
68 @@global.delayed_queue_size
71 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
72 SET @@global.delayed_queue_size = 42949672950;
74 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
75 Warning	1292	Truncated incorrect delayed_queue_size value: '42949672950'
76 SELECT @@global.delayed_queue_size;
77 @@global.delayed_queue_size
80 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
81 SET @@global.delayed_queue_size = 429496729.5;
82 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
83 SELECT @@global.delayed_queue_size;
84 @@global.delayed_queue_size
87 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
88 SET @@global.delayed_queue_size = ON;
89 ERROR 42000: Incorrect argument type to variable 'delayed_queue_size'
90 SELECT @@delayed_queue_size;
91 @@delayed_queue_size
94 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
96 SET @@session.delayed_queue_size = 0;
97 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
98 SELECT @@session.delayed_queue_size;
99 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable
103 WHERE VARIABLE_NAME='delayed_queue_size'
105 SELECT @@global.delayed_queue_size = @tmp;
106 @@global.delayed_queue_size = @tmp
109 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
112 WHERE VARIABLE_NAME='delayed_queue_size'
114 SELECT @@delayed_queue_size = @tmp;
115 @@delayed_queue_size = @tmp
118 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
120 SET @@global.delayed_queue_size = TRUE;
122 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
123 SELECT @@global.delayed_queue_size;
124 @@global.delayed_queue_size
127 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
128 SET @@global.delayed_queue_size = FALSE;
130 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
131 Warning	1292	Truncated incorrect delayed_queue_size value: '0'
132 SELECT @@global.delayed_queue_size;
133 @@global.delayed_queue_size
136 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
138 SET @@global.delayed_queue_size = 1;
140 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
141 SELECT @@delayed_queue_size = @@global.delayed_queue_size;
142 @@delayed_queue_size = @@global.delayed_queue_size
145 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
146 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
148 SET delayed_queue_size = 1;
149 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
150 SELECT @@delayed_queue_size;
151 @@delayed_queue_size
154 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
155 SET local.delayed_queue_size = 1;
156 … your MySQL server version for the right syntax to use near 'local.delayed_queue_size = 1' at line…
157 SELECT local.delayed_queue_size;
159 SET global.delayed_queue_size = 1;
160 …your MySQL server version for the right syntax to use near 'global.delayed_queue_size = 1' at line…
161 SELECT global.delayed_queue_size;
163 SELECT delayed_queue_size = @@session.delayed_queue_size;
164 ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list'
165 SET @@global.delayed_queue_size = @start_value;
167 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
168 SELECT @@global.delayed_queue_size;
169 @@global.delayed_queue_size
172 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.