Debian Codegraph @

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

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