Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.new;
2 Warnings:
3 Warning 1287 '@@new' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 0
7 SET @start_session_value = @@session.new;
8 Warnings:
9 Warning 1287 '@@new' is deprecated and will be removed in a future release.
10 SELECT @start_session_value;
11 @start_session_value
12 0
13 '#--------------------FN_DYNVARS_113_01-------------------------#'
14 SET @@global.new = ON;
15 Warnings:
16 Warning 1287 '@@new' is deprecated and will be removed in a future release.
17 SET @@global.new = DEFAULT;
18 Warnings:
19 Warning 1287 '@@new' is deprecated and will be removed in a future release.
20 SELECT @@global.new;
21 @@global.new
22 0
23 Warnings:
24 Warning 1287 '@@new' is deprecated and will be removed in a future release.
25 SET @@session.new = ON;
26 Warnings:
27 Warning 1287 '@@new' is deprecated and will be removed in a future release.
28 SET @@session.new = DEFAULT;
29 Warnings:
30 Warning 1287 '@@new' is deprecated and will be removed in a future release.
31 SELECT @@session.new;
32 @@session.new
33 0
34 Warnings:
35 Warning 1287 '@@new' is deprecated and will be removed in a future release.
36 '#--------------------FN_DYNVARS_113_02-------------------------#'
37 SET @@global.new = DEFAULT;
38 Warnings:
39 Warning 1287 '@@new' is deprecated and will be removed in a future release.
40 SELECT @@global.new = 'OFF';
41 @@global.new = 'OFF'
42 1
43 Warnings:
44 Warning 1287 '@@new' is deprecated and will be removed in a future release.
45 Warning 1292 Truncated incorrect DOUBLE value: 'OFF'
46 SET @@session.new = DEFAULT;
47 Warnings:
48 Warning 1287 '@@new' is deprecated and will be removed in a future release.
49 SELECT @@session.new = 'OFF';
50 @@session.new = 'OFF'
51 1
52 Warnings:
53 Warning 1287 '@@new' is deprecated and will be removed in a future release.
54 Warning 1292 Truncated incorrect DOUBLE value: 'OFF'
55 '#--------------------FN_DYNVARS_113_03-------------------------#'
56 SET @@global.new = ON;
57 Warnings:
58 Warning 1287 '@@new' is deprecated and will be removed in a future release.
59 SELECT @@global.new;
60 @@global.new
61 1
62 Warnings:
63 Warning 1287 '@@new' is deprecated and will be removed in a future release.
64 SET @@global.new = OFF;
65 Warnings:
66 Warning 1287 '@@new' is deprecated and will be removed in a future release.
67 SELECT @@global.new;
68 @@global.new
69 0
70 Warnings:
71 Warning 1287 '@@new' is deprecated and will be removed in a future release.
72 SET @@global.new = 0;
73 Warnings:
74 Warning 1287 '@@new' is deprecated and will be removed in a future release.
75 SELECT @@global.new;
76 @@global.new
77 0
78 Warnings:
79 Warning 1287 '@@new' is deprecated and will be removed in a future release.
80 SET @@global.new = 1;
81 Warnings:
82 Warning 1287 '@@new' is deprecated and will be removed in a future release.
83 SELECT @@global.new;
84 @@global.new
85 1
86 Warnings:
87 Warning 1287 '@@new' is deprecated and will be removed in a future release.
88 SET @@global.new = TRUE;
89 Warnings:
90 Warning 1287 '@@new' is deprecated and will be removed in a future release.
91 SELECT @@global.new;
92 @@global.new
93 1
94 Warnings:
95 Warning 1287 '@@new' is deprecated and will be removed in a future release.
96 SET @@global.new = FALSE;
97 Warnings:
98 Warning 1287 '@@new' is deprecated and will be removed in a future release.
99 SELECT @@global.new;
100 @@global.new
101 0
102 Warnings:
103 Warning 1287 '@@new' is deprecated and will be removed in a future release.
104 '#--------------------FN_DYNVARS_113_04-------------------------#'
105 SET @@session.new = ON;
106 Warnings:
107 Warning 1287 '@@new' is deprecated and will be removed in a future release.
108 SELECT @@session.new;
109 @@session.new
110 1
111 Warnings:
112 Warning 1287 '@@new' is deprecated and will be removed in a future release.
113 SET @@session.new = OFF;
114 Warnings:
115 Warning 1287 '@@new' is deprecated and will be removed in a future release.
116 SELECT @@session.new;
117 @@session.new
118 0
119 Warnings:
120 Warning 1287 '@@new' is deprecated and will be removed in a future release.
121 SET @@session.new = 0;
122 Warnings:
123 Warning 1287 '@@new' is deprecated and will be removed in a future release.
124 SELECT @@session.new;
125 @@session.new
126 0
127 Warnings:
128 Warning 1287 '@@new' is deprecated and will be removed in a future release.
129 SET @@session.new = 1;
130 Warnings:
131 Warning 1287 '@@new' is deprecated and will be removed in a future release.
132 SELECT @@session.new;
133 @@session.new
134 1
135 Warnings:
136 Warning 1287 '@@new' is deprecated and will be removed in a future release.
137 SET @@session.new = TRUE;
138 Warnings:
139 Warning 1287 '@@new' is deprecated and will be removed in a future release.
140 SELECT @@session.new;
141 @@session.new
142 1
143 Warnings:
144 Warning 1287 '@@new' is deprecated and will be removed in a future release.
145 SET @@session.new = FALSE;
146 Warnings:
147 Warning 1287 '@@new' is deprecated and will be removed in a future release.
148 SELECT @@session.new;
149 @@session.new
150 0
151 Warnings:
152 Warning 1287 '@@new' is deprecated and will be removed in a future release.
153 '#------------------FN_DYNVARS_113_05-----------------------#'
154 SET @@global.new = 'ONN';
155 ERROR 42000: Variable 'new' can't be set to the value of 'ONN'
156 SET @@global.new = "OFFF";
157 ERROR 42000: Variable 'new' can't be set to the value of 'OFFF'
158 SET @@global.new = TTRUE;
159 ERROR 42000: Variable 'new' can't be set to the value of 'TTRUE'
160 SET @@global.new = FELSE;
161 ERROR 42000: Variable 'new' can't be set to the value of 'FELSE'
162 SET @@global.new = -1024;
163 ERROR 42000: Variable 'new' can't be set to the value of '-1024'
164 SET @@global.new = 65536;
165 ERROR 42000: Variable 'new' can't be set to the value of '65536'
166 SET @@global.new = 65530.34;
167 ERROR 42000: Incorrect argument type to variable 'new'
168 SET @@global.new = test;
169 ERROR 42000: Variable 'new' can't be set to the value of 'test'
170 SET @@session.new = ONN;
171 ERROR 42000: Variable 'new' can't be set to the value of 'ONN'
172 SET @@session.new = ONF;
173 ERROR 42000: Variable 'new' can't be set to the value of 'ONF'
174 SET @@session.new = OF;
175 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 'OF' at line 1
176 SET @@session.new = 'OFN';
177 ERROR 42000: Variable 'new' can't be set to the value of 'OFN'
178 SET @@session.new = -2;
179 ERROR 42000: Variable 'new' can't be set to the value of '-2'
180 SET @@session.new = 65530.34;
181 ERROR 42000: Incorrect argument type to variable 'new'
182 SET @@session.new = 65550;
183 ERROR 42000: Variable 'new' can't be set to the value of '65550'
184 SET @@session.new = test;
185 ERROR 42000: Variable 'new' can't be set to the value of 'test'
186 '#------------------FN_DYNVARS_113_06-----------------------#'
187 SELECT IF(@@global.new, "ON", "OFF") = VARIABLE_VALUE
188 FROM performance_schema.global_variables
189 WHERE VARIABLE_NAME='new';
190 IF(@@global.new, "ON", "OFF") = VARIABLE_VALUE
191 1
192 '#------------------FN_DYNVARS_113_07-----------------------#'
193 SELECT IF(@@session.new, "ON", "OFF") = VARIABLE_VALUE
194 FROM performance_schema.session_variables
195 WHERE VARIABLE_NAME='new';
196 IF(@@session.new, "ON", "OFF") = VARIABLE_VALUE
197 1
198 '#---------------------FN_DYNVARS_113_08----------------------#'
199 SET @@new = OFF;
200 Warnings:
201 Warning 1287 '@@new' is deprecated and will be removed in a future release.
202 SET @@global.new = ON;
203 Warnings:
204 Warning 1287 '@@new' is deprecated and will be removed in a future release.
205 SELECT @@new = @@global.new;
206 @@new = @@global.new
207 0
208 Warnings:
209 Warning 1287 '@@new' is deprecated and will be removed in a future release.
210 Warning 1287 '@@new' is deprecated and will be removed in a future release.
211 '#---------------------FN_DYNVARS_113_09----------------------#'
212 SET @@new = ON;
213 Warnings:
214 Warning 1287 '@@new' is deprecated and will be removed in a future release.
215 SELECT @@new = @@local.new;
216 @@new = @@local.new
217 1
218 Warnings:
219 Warning 1287 '@@new' is deprecated and will be removed in a future release.
220 Warning 1287 '@@new' is deprecated and will be removed in a future release.
221 SELECT @@local.new = @@session.new;
222 @@local.new = @@session.new
223 1
224 Warnings:
225 Warning 1287 '@@new' is deprecated and will be removed in a future release.
226 Warning 1287 '@@new' is deprecated and will be removed in a future release.
227 '#---------------------FN_DYNVARS_113_10----------------------#'
228 SET new = 1;
229 Warnings:
230 Warning 1287 '@@new' is deprecated and will be removed in a future release.
231 SELECT @@new;
232 @@new
233 1
234 Warnings:
235 Warning 1287 '@@new' is deprecated and will be removed in a future release.
236 SELECT local.new;
237 ERROR 42S02: Unknown table 'local' in field list
238 SELECT session.new;
239 ERROR 42S02: Unknown table 'session' in field list
240 SELECT new = @@session.new;
241 ERROR 42S22: Unknown column 'new' in 'field list'
242 SET @@global.new = @start_global_value;
243 Warnings:
244 Warning 1287 '@@new' is deprecated and will be removed in a future release.
245 SELECT @@global.new;
246 @@global.new
247 0
248 Warnings:
249 Warning 1287 '@@new' is deprecated and will be removed in a future release.
250 SET @@session.new = @start_session_value;
251 Warnings:
252 Warning 1287 '@@new' is deprecated and will be removed in a future release.
253 SELECT @@session.new;
254 @@session.new
255 0
256 Warnings:
257 Warning 1287 '@@new' is deprecated and will be removed in a future release.