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
101 SELECT @@global.delayed_queue_size = VARIABLE_VALUE
103 WHERE VARIABLE_NAME='delayed_queue_size';
104 @@global.delayed_queue_size = VARIABLE_VALUE
107 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
108 SELECT @@delayed_queue_size = VARIABLE_VALUE
110 WHERE VARIABLE_NAME='delayed_queue_size';
111 @@delayed_queue_size = VARIABLE_VALUE
114 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
116 SET @@global.delayed_queue_size = TRUE;
118 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
119 SELECT @@global.delayed_queue_size;
120 @@global.delayed_queue_size
123 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
124 SET @@global.delayed_queue_size = FALSE;
126 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
127 Warning	1292	Truncated incorrect delayed_queue_size value: '0'
128 SELECT @@global.delayed_queue_size;
129 @@global.delayed_queue_size
132 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
134 SET @@global.delayed_queue_size = 1;
136 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
137 SELECT @@delayed_queue_size = @@global.delayed_queue_size;
138 @@delayed_queue_size = @@global.delayed_queue_size
141 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
142 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
144 SET delayed_queue_size = 1;
145 ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL
146 SELECT @@delayed_queue_size;
147 @@delayed_queue_size
150 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
151 SET local.delayed_queue_size = 1;
152 …nds to your MySQL server version for the right syntax to use near 'delayed_queue_size = 1' at line…
153 SELECT local.delayed_queue_size;
155 SET global.delayed_queue_size = 1;
156 …nds to your MySQL server version for the right syntax to use near 'delayed_queue_size = 1' at line…
157 SELECT global.delayed_queue_size;
159 SELECT delayed_queue_size = @@session.delayed_queue_size;
160 ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list'
161 SET @@global.delayed_queue_size = @start_value;
163 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.
164 SELECT @@global.delayed_queue_size;
165 @@global.delayed_queue_size
168 Warning	1287	'@@delayed_queue_size' is deprecated and will be removed in a future release.