Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.old_mode;
2 SELECT @global_start_value;
3 @global_start_value
4 UTF8_IS_UTF8MB3
5 SET @session_start_value = @@session.old_mode;
6 SELECT @session_start_value;
7 @session_start_value
8 UTF8_IS_UTF8MB3
9 '#--------------------FN_DYNVARS_152_01------------------------#'
10 SET @@global.old_mode = "NO_PROGRESS_INFO";
11 Warnings:
12 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
13 SET @@global.old_mode = DEFAULT;
14 SELECT @@global.old_mode;
15 @@global.old_mode
16 UTF8_IS_UTF8MB3
17 SET @@session.old_mode = "NO_PROGRESS_INFO";
18 Warnings:
19 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
20 SET @@session.old_mode = DEFAULT;
21 SELECT @@session.old_mode;
22 @@session.old_mode
23 UTF8_IS_UTF8MB3
24 '#---------------------FN_DYNVARS_152_02-------------------------#'
25 SET @@global.old_mode = NULL;
26 ERROR 42000: Variable 'old_mode' can't be set to the value of 'NULL'
27 SET @@global.old_mode = '';
28 SELECT @@global.old_mode;
29 @@global.old_mode
30
31 SET @@global.old_mode = ' ';
32 SELECT @@global.old_mode;
33 @@global.old_mode
34
35 SET @@session.old_mode = NULL;
36 ERROR 42000: Variable 'old_mode' can't be set to the value of 'NULL'
37 SET @@session.old_mode = '';
38 SELECT @@session.old_mode;
39 @@session.old_mode
40
41 SET @@session.old_mode = ' ';
42 SELECT @@session.old_mode;
43 @@session.old_mode
44
45 '#--------------------FN_DYNVARS_152_03------------------------#'
46 SET @@global.old_mode = NO_PROGRESS_INFO;
47 Warnings:
48 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
49 SELECT @@global.old_mode;
50 @@global.old_mode
51 NO_PROGRESS_INFO
52 SET @@global.old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE;
53 Warnings:
54 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
55 SELECT @@global.old_mode;
56 @@global.old_mode
57 NO_DUP_KEY_WARNINGS_WITH_IGNORE
58 SET @@global.old_mode = OFF;
59 ERROR 42000: Variable 'old_mode' can't be set to the value of 'OFF'
60 SET @@session.old_mode = NO_PROGRESS_INFO;
61 Warnings:
62 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
63 SELECT @@session.old_mode;
64 @@session.old_mode
65 NO_PROGRESS_INFO
66 SET @@session.old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE;
67 Warnings:
68 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
69 SELECT @@session.old_mode;
70 @@session.old_mode
71 NO_DUP_KEY_WARNINGS_WITH_IGNORE
72 SET @@session.old_mode = OFF;
73 ERROR 42000: Variable 'old_mode' can't be set to the value of 'OFF'
74 SET @@global.old_mode = '?';
75 ERROR 42000: Variable 'old_mode' can't be set to the value of '?'
76 SELECT @@global.old_mode;
77 @@global.old_mode
78 NO_DUP_KEY_WARNINGS_WITH_IGNORE
79 '#--------------------FN_DYNVARS_152_04-------------------------#'
80 SET @@global.old_mode = -1;
81 ERROR 42000: Variable 'old_mode' can't be set to the value of '-1'
82 SET @@global.old_mode = ASCII;
83 ERROR 42000: Variable 'old_mode' can't be set to the value of 'ASCII'
84 SET @@global.old_mode = NON_TRADITIONAL;
85 ERROR 42000: Variable 'old_mode' can't be set to the value of 'NON_TRADITIONAL'
86 SET @@global.old_mode = 'OF';
87 ERROR 42000: Variable 'old_mode' can't be set to the value of 'OF'
88 SET @@global.old_mode = NONE;
89 ERROR 42000: Variable 'old_mode' can't be set to the value of 'NONE'
90 SET @@session.old_mode = -1;
91 ERROR 42000: Variable 'old_mode' can't be set to the value of '-1'
92 SET @@session.old_mode = ANSI_SINGLE_QUOTES;
93 ERROR 42000: Variable 'old_mode' can't be set to the value of 'ANSI_SINGLE_QUOTES'
94 SET @@session.old_mode = 'ON';
95 ERROR 42000: Variable 'old_mode' can't be set to the value of 'ON'
96 SET @@session.old_mode = 'OF';
97 ERROR 42000: Variable 'old_mode' can't be set to the value of 'OF'
98 SET @@session.old_mode = DISABLE;
99 ERROR 42000: Variable 'old_mode' can't be set to the value of 'DISABLE'
100 '#-------------------FN_DYNVARS_152_05----------------------------#'
101 SELECT @@session.old_mode = VARIABLE_VALUE
102 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
103 WHERE VARIABLE_NAME='old_mode';
104 @@session.old_mode = VARIABLE_VALUE
105 1
106 '#----------------------FN_DYNVARS_152_06------------------------#'
107 SELECT @@global.old_mode = VARIABLE_VALUE
108 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
109 WHERE VARIABLE_NAME='old_mode';
110 @@global.old_mode = VARIABLE_VALUE
111 1
112 '#---------------------FN_DYNVARS_152_07-------------------------#'
113 SET @@global.old_mode = 0;
114 SELECT @@global.old_mode;
115 @@global.old_mode
116
117 SET @@global.old_mode = 1;
118 Warnings:
119 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
120 SELECT @@global.old_mode;
121 @@global.old_mode
122 NO_DUP_KEY_WARNINGS_WITH_IGNORE
123 SET @@global.old_mode = 2;
124 Warnings:
125 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
126 SELECT @@global.old_mode;
127 @@global.old_mode
128 NO_PROGRESS_INFO
129 SET @@global.old_mode = 4;
130 Warnings:
131 Warning 1287 'ZERO_DATE_TIME_CAST' is deprecated and will be removed in a future release
132 SELECT @@global.old_mode;
133 @@global.old_mode
134 ZERO_DATE_TIME_CAST
135 SET @@global.old_mode = 6536;
136 ERROR 42000: Variable 'old_mode' can't be set to the value of '6536'
137 SELECT @@global.old_mode;
138 @@global.old_mode
139 ZERO_DATE_TIME_CAST
140 SET @@global.old_mode = 0.4;
141 ERROR 42000: Incorrect argument type to variable 'old_mode'
142 '#---------------------FN_DYNVARS_152_08----------------------#'
143 SET @@global.old_mode = TRUE;
144 Warnings:
145 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
146 SELECT @@global.old_mode;
147 @@global.old_mode
148 NO_DUP_KEY_WARNINGS_WITH_IGNORE
149 SET @@global.old_mode = FALSE;
150 SELECT @@global.old_mode;
151 @@global.old_mode
152
153 '#---------------------FN_DYNVARS_152_09----------------------#'
154 SET old_mode = 'NO_PROGRESS_INFO';
155 Warnings:
156 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
157 SET session old_mode = 1;
158 Warnings:
159 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
160 SELECT @@old_mode;
161 @@old_mode
162 NO_DUP_KEY_WARNINGS_WITH_IGNORE
163 SET global old_mode = 0;
164 SELECT @@global.old_mode;
165 @@global.old_mode
166
167 '#---------------------FN_DYNVARS_152_10----------------------#'
168 SET @@session.old_mode = 'NO_PROGRESS_INFO,NO_DUP_KEY_WARNINGS_WITH_IGNORE';
169 Warnings:
170 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
171 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
172 SELECT @@session.old_mode;
173 @@session.old_mode
174 NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO
175 SET @@global.old_mode = 'NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO';
176 Warnings:
177 Warning 1287 'NO_DUP_KEY_WARNINGS_WITH_IGNORE' is deprecated and will be removed in a future release
178 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
179 SELECT @@global.old_mode;
180 @@global.old_mode
181 NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO
182 SET @@session.old_mode = 'NO_PROGRESS_INFO,NO_SUCH_MODE';
183 ERROR 42000: Variable 'old_mode' can't be set to the value of 'NO_SUCH_MODE'
184 SET @@old_mode=',';
185 SELECT @@old_mode;
186 @@old_mode
187
188 SET @@old_mode=',,,,NO_PROGRESS_INFO,,,';
189 Warnings:
190 Warning 1287 'NO_PROGRESS_INFO' is deprecated and will be removed in a future release
191 SELECT @@old_mode;
192 @@old_mode
193 NO_PROGRESS_INFO
194 SET @@old_mode=',,,,FOOBAR,,,,,';
195 ERROR 42000: Variable 'old_mode' can't be set to the value of 'FOOBAR'
196 SELECT @@old_mode;
197 @@old_mode
198 NO_PROGRESS_INFO
199 SET @@global.old_mode = @global_start_value;
200 SELECT @@global.old_mode;
201 @@global.old_mode
202 UTF8_IS_UTF8MB3
203 SET @@session.old_mode = @session_start_value;
204 SELECT @@session.old_mode;
205 @@session.old_mode
206 UTF8_IS_UTF8MB3
207 #
208 # Beginning of 10.6 test
209 #
210 # MDEV-8334: Rename utf8 to utf8mb3
211 #
212 # Save and display old values
213 SET @save_old_mode = @@OLD_MODE;
214 SET @save_character_set_server = @@character_set_server;
215 SET @save_character_set_client = @@character_set_client;
216 SET @save_character_set_results = @@character_set_results;
217 SET @save_character_set_connection = @@character_set_connection;
218 SET @save_character_set_filesystem = @@character_set_filesystem;
219 SET @save_character_set_database = @@character_set_database;
220 SET @save_collation_connection = @@collation_connection;
221 SET @save_collation_server = @@collation_server;
222 SET @save_collation_database = @@collation_database;
223 SELECT @@OLD_MODE;
224 @@OLD_MODE
225 UTF8_IS_UTF8MB3
226 SELECT @@character_set_server,@@character_set_client,@@character_set_results,
227 @@character_set_connection, @@character_set_filesystem, @@character_set_database,
228 @@collation_connection, @@collation_server, @@collation_database;
229 @@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
230 utf8mb4 latin1 latin1 latin1 binary utf8mb4 latin1_swedish_ci utf8mb4_uca1400_ai_ci utf8mb4_uca1400_ai_ci
231 #
232 # UTF8MB3 alias for UTF8
233 #
234 SET @@character_set_server = utf8;
235 SET @@character_set_client = utf8;
236 SET @@character_set_results = utf8;
237 SET @@character_set_connection = utf8;
238 SET @@character_set_filesystem = utf8;
239 SET @@character_set_database = utf8;
240 SET @@collation_connection = utf8_general_ci;
241 SET @@collation_server = utf8_unicode_ci;
242 SET @@collation_database = utf8_bin;
243 SELECT @@character_set_server, @@character_set_client, @@character_set_results,
244 @@character_set_connection, @@character_set_filesystem, @@character_set_database,
245 @@collation_connection, @@collation_server, @@collation_database;
246 @@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
247 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3 utf8mb3_general_ci utf8mb3_unicode_ci utf8mb3_bin
248 CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';
249 ALTER DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_unicode_ci';
250 CREATE TABLE tb1 (id1 INT) CHARACTER SET 'utf8' COLLATE 'utf8_bin';
251 SHOW CREATE TABLE tb1;
252 Table Create Table
253 tb1 CREATE TABLE `tb1` (
254 `id1` int(11) DEFAULT NULL
255 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin
256 DROP TABLE tb1;
257 DROP DATABASE db1;
258 #
259 # UTF8MB4 is alias for UTF8
260 #
261 SET @@OLD_MODE=0;
262 SET @@character_set_server = utf8;
263 SET @@character_set_client = utf8;
264 SET @@character_set_results = utf8;
265 SET @@character_set_connection = utf8;
266 SET @@character_set_filesystem = utf8;
267 SET @@character_set_database = utf8;
268 SET @@collation_connection = utf8_general_ci;
269 SET @@collation_server = utf8_unicode_ci;
270 SET @@collation_database = utf8_bin;
271 SELECT @@character_set_server, @@character_set_client, @@character_set_results,
272 @@character_set_connection, @@character_set_filesystem, @@character_set_database,
273 @@collation_connection, @@collation_server, @@collation_database;
274 @@character_set_server @@character_set_client @@character_set_results @@character_set_connection @@character_set_filesystem @@character_set_database @@collation_connection @@collation_server @@collation_database
275 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4 utf8mb4_general_ci utf8mb4_unicode_ci utf8mb4_bin
276 CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';
277 ALTER DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_unicode_ci';
278 CREATE TABLE tb1 (id1 INT) CHARACTER SET 'utf8' COLLATE 'utf8_bin';
279 SHOW CREATE TABLE tb1;
280 Table Create Table
281 tb1 CREATE TABLE `tb1` (
282 `id1` int(11) DEFAULT NULL
283 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
284 DROP TABLE tb1;
285 DROP DATABASE db1;
286 SET @@OLD_MODE = @save_old_mode;
287 SET @@character_set_server = @save_character_set_server;
288 SET @@character_set_client = @save_character_set_client;
289 SET @@character_set_results = @save_character_set_results;
290 SET @@character_set_connection = @save_character_set_connection;
291 SET @@character_set_filesystem = @save_character_set_filesystem;
292 SET @@character_set_database = @save_character_set_database;
293 SET @@collation_connection = @save_collation_connection;
294 SET @@collation_server = @save_collation_server;
295 SET @@collation_database = @save_collation_database;
296 #
297 # End of 10.6 test
298 #
299 #
300 # Beginning of 10.9 test
301 #
302 #
303 # MDEV-24920: Merge "old" SQL variable to "old_mode" sql variable
304 #
305 # Checking that setting old will also set old_mode
306 SELECT @@OLD_MODE;
307 @@OLD_MODE
308 UTF8_IS_UTF8MB3
309 SET old= 1;
310 Warnings:
311 Warning 1287 '@@old' is deprecated and will be removed in a future release. Please use '@@old_mode' instead
312 SELECT @@OLD_MODE;
313 @@OLD_MODE
314 NO_PROGRESS_INFO,UTF8_IS_UTF8MB3,IGNORE_INDEX_ONLY_FOR_JOIN,COMPAT_5_1_CHECKSUM
315 SET old= DEFAULT;
316 Warnings:
317 Warning 1287 '@@old' is deprecated and will be removed in a future release. Please use '@@old_mode' instead
318 SELECT @@OLD_MODE;
319 @@OLD_MODE
320 UTF8_IS_UTF8MB3
321 # Checking that old_mode can be set independently as well
322 SELECT @@OLD_MODE;
323 @@OLD_MODE
324 UTF8_IS_UTF8MB3
325 SET @save_old_mode = @@OLD_MODE;
326 SET @@OLD_MODE= IGNORE_INDEX_ONLY_FOR_JOIN;
327 Warnings:
328 Warning 1287 'IGNORE_INDEX_ONLY_FOR_JOIN' is deprecated and will be removed in a future release
329 SELECT @@OLD_MODE;
330 @@OLD_MODE
331 IGNORE_INDEX_ONLY_FOR_JOIN
332 SET @@OLD_MODE= COMPAT_5_1_CHECKSUM;
333 Warnings:
334 Warning 1287 'COMPAT_5_1_CHECKSUM' is deprecated and will be removed in a future release
335 SELECT @@OLD_MODE;
336 @@OLD_MODE
337 COMPAT_5_1_CHECKSUM
338 SET @@OLD_MODE= @save_old_mode;
339 #
340 # End of 10.9 test
341 #