Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.default_collation_for_utf8mb4;
2 @@GLOBAL.default_collation_for_utf8mb4
3 utf8mb4_0900_ai_ci
4 SELECT @@SESSION.default_collation_for_utf8mb4;
5 @@SESSION.default_collation_for_utf8mb4
6 utf8mb4_0900_ai_ci
7 #
8 SET @@default_collation_for_utf8mb4 = DEFAULT;
9 Warnings:
10 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
11 SELECT @@default_collation_for_utf8mb4;
12 @@default_collation_for_utf8mb4
13 utf8mb4_0900_ai_ci
14 #
15 SET @@default_collation_for_utf8mb4 = utf8mb4_0900_ai_ci;
16 Warnings:
17 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
18 SELECT @@default_collation_for_utf8mb4;
19 @@default_collation_for_utf8mb4
20 utf8mb4_0900_ai_ci
21 #
22 SET @@default_collation_for_utf8mb4 = utf8mb4_general_ci;
23 Warnings:
24 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
25 SELECT @@default_collation_for_utf8mb4;
26 @@default_collation_for_utf8mb4
27 utf8mb4_general_ci
28 #
29 SET @@default_collation_for_utf8mb4 = utf8mb4;
30 ERROR HY000: Unknown collation: 'utf8mb4'
31 #
32 SET @@default_collation_for_utf8mb4 = latin2_general_ci;
33 ERROR HY000: Invalid default collation latin2_general_ci: utf8mb4_0900_ai_ci or utf8mb4_general_ci expected
34 #
35 SET @@default_collation_for_utf8mb4 = utf8mb4_general_ci;
36 Warnings:
37 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
38 #
39 # String literals
40 #
41 SELECT COLLATION(_utf8mb4 'a');
42 COLLATION(_utf8mb4 'a')
43 utf8mb4_general_ci
44 SELECT COLLATION(_utf8mb4 'b' COLLATE utf8mb4_0900_ai_ci);
45 COLLATION(_utf8mb4 'b' COLLATE utf8mb4_0900_ai_ci)
46 utf8mb4_0900_ai_ci
47 SELECT COLLATION(_utf8mb4 0x20);
48 COLLATION(_utf8mb4 0x20)
49 utf8mb4_general_ci
50 SELECT COLLATION(_utf8mb4 0x20 COLLATE utf8mb4_0900_ai_ci);
51 COLLATION(_utf8mb4 0x20 COLLATE utf8mb4_0900_ai_ci)
52 utf8mb4_0900_ai_ci
53 SELECT COLLATION(_utf8mb4 0b10100);
54 COLLATION(_utf8mb4 0b10100)
55 utf8mb4_general_ci
56 SELECT COLLATION(_utf8mb4 0b10100 COLLATE utf8mb4_0900_ai_ci);
57 COLLATION(_utf8mb4 0b10100 COLLATE utf8mb4_0900_ai_ci)
58 utf8mb4_0900_ai_ci
59 #
60 # SET NAMES
61 #
62 SELECT @@collation_database;
63 @@collation_database
64 utf8mb4_0900_ai_ci
65 #
66 SET NAMES utf8mb4;
67 SELECT @@collation_connection;
68 @@collation_connection
69 utf8mb4_general_ci
70 #
71 SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci;
72 SELECT @@collation_connection;
73 @@collation_connection
74 utf8mb4_0900_ai_ci
75 #
76 SET NAMES latin1;
77 SELECT @@collation_connection;
78 @@collation_connection
79 latin1_swedish_ci
80 #
81 SET NAMES DEFAULT;
82 SELECT @@collation_connection;
83 @@collation_connection
84 utf8mb4_general_ci
85 #
86 SET @@default_collation_for_utf8mb4 = DEFAULT;
87 Warnings:
88 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
89 SET NAMES DEFAULT;
90 SET @@default_collation_for_utf8mb4 = utf8mb4_general_ci;
91 Warnings:
92 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
93 #
94 # CREATE/ALTER SCHEMA/DATABASE
95 #
96 CREATE DATABASE db1;
97 SHOW CREATE DATABASE db1;
98 Database db1
99 Create Database CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
100 ALTER DATABASE db1 CHARSET utf8mb4;
101 SHOW CREATE DATABASE db1;
102 Database db1
103 Create Database CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
104 DROP DATABASE db1;
105 #
106 CREATE DATABASE db2 CHARSET utf8mb4;
107 SHOW CREATE DATABASE db2;
108 Database db2
109 Create Database CREATE DATABASE `db2` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
110 ALTER DATABASE db2 CHARSET utf8mb4;
111 SHOW CREATE DATABASE db2;
112 Database db2
113 Create Database CREATE DATABASE `db2` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
114 ALTER DATABASE db2 CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
115 SHOW CREATE DATABASE db2;
116 Database db2
117 Create Database CREATE DATABASE `db2` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
118 DROP DATABASE db2;
119 #
120 CREATE DATABASE db3 CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
121 SHOW CREATE DATABASE db3;
122 Database db3
123 Create Database CREATE DATABASE `db3` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
124 DROP DATABASE db3;
125 #
126 CREATE DATABASE db4_latin1 CHARSET latin1;
127 SHOW CREATE DATABASE db4_latin1;
128 Database db4_latin1
129 Create Database CREATE DATABASE `db4_latin1` /*!40100 DEFAULT CHARACTER SET latin1 */ /*!80016 DEFAULT ENCRYPTION='N' */
130 #
131 CREATE DATABASE db5_utf8mb4_general_ci CHARSET utf8mb4;
132 SHOW CREATE DATABASE db5_utf8mb4_general_ci;
133 Database db5_utf8mb4_general_ci
134 Create Database CREATE DATABASE `db5_utf8mb4_general_ci` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
135 #
136 # CREATE/ALTER TABLE
137 #
138 CREATE TABLE db4_latin1.t1 (
139 c1 CHAR(1) CHARSET utf8mb4,
140 c2 CHAR(1) COLLATE utf8mb4_0900_ai_ci,
141 c3 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
142 c4 CHAR(1),
143 c5 CHAR(1) CHARSET latin1
144 );
145 SHOW CREATE TABLE db4_latin1.t1;
146 Table t1
147 Create Table CREATE TABLE `t1` (
148 `c1` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
149 `c2` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
150 `c3` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
151 `c4` char(1) DEFAULT NULL,
152 `c5` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
153 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
154 DROP TABLE db4_latin1.t1;
155 #
156 CREATE TABLE t2 (
157 c1 CHAR(1) CHARSET utf8mb4,
158 c2 CHAR(1) COLLATE utf8mb4_0900_ai_ci,
159 c3 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
160 c4 CHAR(1),
161 c5 CHAR(1) CHARSET latin1
162 );
163 SHOW CREATE TABLE t2;
164 Table t2
165 Create Table CREATE TABLE `t2` (
166 `c1` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
167 `c2` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
168 `c3` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
169 `c4` char(1) DEFAULT NULL,
170 `c5` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
172 DROP TABLE t2;
173 #
174 CREATE TABLE t3 (
175 c1 CHAR(1) CHARSET utf8mb4,
176 c2 CHAR(1) COLLATE utf8mb4_0900_ai_ci,
177 c3 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
178 c4 CHAR(1),
179 c5 CHAR(1) CHARSET latin1
180 ) CHARSET utf8mb4;
181 SHOW CREATE TABLE t3;
182 Table t3
183 Create Table CREATE TABLE `t3` (
184 `c1` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
185 `c2` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
186 `c3` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
187 `c4` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
188 `c5` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
190 DROP TABLE t3;
191 #
192 CREATE TABLE t4 (
193 c1 CHAR(1) CHARSET utf8mb4,
194 c2 CHAR(1) COLLATE utf8mb4_0900_ai_ci,
195 c3 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
196 c4 CHAR(1),
197 c5 CHAR(1) CHARSET latin1
198 ) CHARSET latin1;
199 SHOW CREATE TABLE t4;
200 Table t4
201 Create Table CREATE TABLE `t4` (
202 `c1` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
203 `c2` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
204 `c3` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
205 `c4` char(1) DEFAULT NULL,
206 `c5` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
207 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
208 DROP TABLE t4;
209 #
210 # CREATE/ALTER FUNCTION
211 #
212 CREATE FUNCTION db5_utf8mb4_general_ci.f1(
213 c1 CHAR(1) CHARSET utf8mb4,
214 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
215 c3 CHAR(1),
216 c4 CHAR(1) CHARSET latin1)
217 RETURNS CHAR(246)
218 BEGIN
219 DECLARE p1 CHAR(1) CHARSET utf8mb4;
220 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
221 DECLARE p3 CHAR(1);
222 DECLARE p4 CHAR(1) CHARSET latin1;
223 RETURN CONCAT('c1:', COLLATION(c1),
224 ' c2:', COLLATION(c2),
225 ' c3:', COLLATION(c3),
226 ' c4:', COLLATION(c4),
227 ' p1:', COLLATION(p1),
228 ' p2:', COLLATION(p2),
229 ' p3:', COLLATION(p3),
230 ' p4:', COLLATION(p4));
231 END//
232 SHOW CREATE FUNCTION db5_utf8mb4_general_ci.f1//
233 Function f1
234 sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
235 Create Function CREATE DEFINER=`root`@`localhost` FUNCTION `f1`(
236 c1 CHAR(1) CHARSET utf8mb4,
237 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
238 c3 CHAR(1),
239 c4 CHAR(1) CHARSET latin1) RETURNS char(246) CHARSET utf8mb4 COLLATE utf8mb4_general_ci
240 BEGIN
241 DECLARE p1 CHAR(1) CHARSET utf8mb4;
242 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
243 DECLARE p3 CHAR(1);
244 DECLARE p4 CHAR(1) CHARSET latin1;
245 RETURN CONCAT('c1:', COLLATION(c1),
246 ' c2:', COLLATION(c2),
247 ' c3:', COLLATION(c3),
248 ' c4:', COLLATION(c4),
249 ' p1:', COLLATION(p1),
250 ' p2:', COLLATION(p2),
251 ' p3:', COLLATION(p3),
252 ' p4:', COLLATION(p4));
253 END
254 character_set_client utf8mb4
255 collation_connection utf8mb4_0900_ai_ci
256 Database Collation utf8mb4_general_ci
257 SELECT db5_utf8mb4_general_ci.f1('1', '2', '3', '4'),
258 COLLATION(db5_utf8mb4_general_ci.f1('1', '2', '3', '4'))//
259 db5_utf8mb4_general_ci.f1('1', '2', '3', '4') COLLATION(db5_utf8mb4_general_ci.f1('1', '2', '3', '4'))
260 c1:utf8mb4_general_ci c2:utf8mb4_general_ci c3:utf8mb4_general_ci c4:latin1_swedish_ci p1:utf8mb4_general_ci p2:utf8mb4_0900_ai_ci p3:utf8mb4_general_ci p4:latin1_swedish_ci utf8mb4_general_ci
261 DROP FUNCTION db5_utf8mb4_general_ci.f1//
262 #
263 CREATE FUNCTION f2(
264 c1 CHAR(1) CHARSET utf8mb4,
265 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
266 c3 CHAR(1),
267 c4 CHAR(1) CHARSET latin1)
268 RETURNS CHAR(246)
269 BEGIN
270 DECLARE p1 CHAR(1) CHARSET utf8mb4;
271 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
272 DECLARE p3 CHAR(1);
273 DECLARE p4 CHAR(1) CHARSET latin1;
274 RETURN CONCAT('c1:', COLLATION(c1),
275 ' c2:', COLLATION(c2),
276 ' c3:', COLLATION(c3),
277 ' c4:', COLLATION(c4),
278 ' p1:', COLLATION(p1),
279 ' p2:', COLLATION(p2),
280 ' p3:', COLLATION(p3),
281 ' p4:', COLLATION(p4));
282 END//
283 SHOW CREATE FUNCTION f2//
284 Function f2
285 sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
286 Create Function CREATE DEFINER=`root`@`localhost` FUNCTION `f2`(
287 c1 CHAR(1) CHARSET utf8mb4,
288 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
289 c3 CHAR(1),
290 c4 CHAR(1) CHARSET latin1) RETURNS char(246) CHARSET utf8mb4 COLLATE utf8mb4_general_ci
291 BEGIN
292 DECLARE p1 CHAR(1) CHARSET utf8mb4;
293 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
294 DECLARE p3 CHAR(1);
295 DECLARE p4 CHAR(1) CHARSET latin1;
296 RETURN CONCAT('c1:', COLLATION(c1),
297 ' c2:', COLLATION(c2),
298 ' c3:', COLLATION(c3),
299 ' c4:', COLLATION(c4),
300 ' p1:', COLLATION(p1),
301 ' p2:', COLLATION(p2),
302 ' p3:', COLLATION(p3),
303 ' p4:', COLLATION(p4));
304 END
305 character_set_client utf8mb4
306 collation_connection utf8mb4_0900_ai_ci
307 Database Collation utf8mb4_0900_ai_ci
308 SELECT f2('1', '2', '3', '4'), COLLATION(f2('1', '2', '3', '4'))//
309 f2('1', '2', '3', '4') COLLATION(f2('1', '2', '3', '4'))
310 c1:utf8mb4_general_ci c2:utf8mb4_general_ci c3:utf8mb4_general_ci c4:latin1_swedish_ci p1:utf8mb4_general_ci p2:utf8mb4_0900_ai_ci p3:utf8mb4_general_ci p4:latin1_swedish_ci utf8mb4_general_ci
311 DROP FUNCTION f2//
312 #
313 CREATE FUNCTION f3(
314 c1 CHAR(1) CHARSET utf8mb4,
315 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
316 c3 CHAR(1),
317 c4 CHAR(1) CHARSET latin1)
318 RETURNS CHAR(246)
319 BEGIN
320 DECLARE p1 CHAR(1) CHARSET utf8mb4;
321 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
322 DECLARE p3 CHAR(1);
323 DECLARE p4 CHAR(1) CHARSET latin1;
324 RETURN CONCAT('c1:', COLLATION(c1),
325 ' c2:', COLLATION(c2),
326 ' c3:', COLLATION(c3),
327 ' c4:', COLLATION(c4),
328 ' p1:', COLLATION(p1),
329 ' p2:', COLLATION(p2),
330 ' p3:', COLLATION(p3),
331 ' p4:', COLLATION(p4));
332 END//
333 SHOW CREATE FUNCTION f3//
334 Function f3
335 sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
336 Create Function CREATE DEFINER=`root`@`localhost` FUNCTION `f3`(
337 c1 CHAR(1) CHARSET utf8mb4,
338 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
339 c3 CHAR(1),
340 c4 CHAR(1) CHARSET latin1) RETURNS char(246) CHARSET utf8mb4 COLLATE utf8mb4_general_ci
341 BEGIN
342 DECLARE p1 CHAR(1) CHARSET utf8mb4;
343 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
344 DECLARE p3 CHAR(1);
345 DECLARE p4 CHAR(1) CHARSET latin1;
346 RETURN CONCAT('c1:', COLLATION(c1),
347 ' c2:', COLLATION(c2),
348 ' c3:', COLLATION(c3),
349 ' c4:', COLLATION(c4),
350 ' p1:', COLLATION(p1),
351 ' p2:', COLLATION(p2),
352 ' p3:', COLLATION(p3),
353 ' p4:', COLLATION(p4));
354 END
355 character_set_client utf8mb4
356 collation_connection utf8mb4_0900_ai_ci
357 Database Collation utf8mb4_0900_ai_ci
358 SELECT f3('1', '2', '3', '4'), COLLATION(f3('1', '2', '3', '4'))//
359 f3('1', '2', '3', '4') COLLATION(f3('1', '2', '3', '4'))
360 c1:utf8mb4_general_ci c2:utf8mb4_general_ci c3:utf8mb4_general_ci c4:latin1_swedish_ci p1:utf8mb4_general_ci p2:utf8mb4_0900_ai_ci p3:utf8mb4_general_ci p4:latin1_swedish_ci utf8mb4_general_ci
361 DROP FUNCTION f3//
362 #
363 CREATE FUNCTION f4(
364 c1 CHAR(1) CHARSET utf8mb4,
365 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
366 c3 CHAR(1),
367 c4 CHAR(1) CHARSET latin1)
368 RETURNS CHAR(246)
369 BEGIN
370 DECLARE p1 CHAR(1) CHARSET utf8mb4;
371 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
372 DECLARE p3 CHAR(1);
373 DECLARE p4 CHAR(1) CHARSET latin1;
374 RETURN CONCAT('c1:', COLLATION(c1),
375 ' c2:', COLLATION(c2),
376 ' c3:', COLLATION(c3),
377 ' c4:', COLLATION(c4),
378 ' p1:', COLLATION(p1),
379 ' p2:', COLLATION(p2),
380 ' p3:', COLLATION(p3),
381 ' p4:', COLLATION(p4));
382 END//
383 SHOW CREATE FUNCTION f4//
384 Function f4
385 sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
386 Create Function CREATE DEFINER=`root`@`localhost` FUNCTION `f4`(
387 c1 CHAR(1) CHARSET utf8mb4,
388 c2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
389 c3 CHAR(1),
390 c4 CHAR(1) CHARSET latin1) RETURNS char(246) CHARSET utf8mb4 COLLATE utf8mb4_general_ci
391 BEGIN
392 DECLARE p1 CHAR(1) CHARSET utf8mb4;
393 DECLARE p2 CHAR(1) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
394 DECLARE p3 CHAR(1);
395 DECLARE p4 CHAR(1) CHARSET latin1;
396 RETURN CONCAT('c1:', COLLATION(c1),
397 ' c2:', COLLATION(c2),
398 ' c3:', COLLATION(c3),
399 ' c4:', COLLATION(c4),
400 ' p1:', COLLATION(p1),
401 ' p2:', COLLATION(p2),
402 ' p3:', COLLATION(p3),
403 ' p4:', COLLATION(p4));
404 END
405 character_set_client utf8mb4
406 collation_connection utf8mb4_0900_ai_ci
407 Database Collation utf8mb4_0900_ai_ci
408 SELECT f4('1', '2', '3', '4'), COLLATION(f4('1', '2', '3', '4'))//
409 f4('1', '2', '3', '4') COLLATION(f4('1', '2', '3', '4'))
410 c1:utf8mb4_general_ci c2:utf8mb4_general_ci c3:utf8mb4_general_ci c4:latin1_swedish_ci p1:utf8mb4_general_ci p2:utf8mb4_0900_ai_ci p3:utf8mb4_general_ci p4:latin1_swedish_ci utf8mb4_general_ci
411 DROP FUNCTION f4//
412 #
413 # Cleanup
414 #
415 DROP DATABASE db4_latin1;
416 DROP DATABASE db5_utf8mb4_general_ci;
417 #
418 # Bug#27607720: WRONG UPDATION OF COLLATION AFTER ALTER TABLE COMMAND
419 #
420 SET SESSION default_collation_for_utf8mb4 = utf8mb4_general_ci;
421 Warnings:
422 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
423 SHOW GLOBAL VARIABLES LIKE '%default_collation_for_utf8mb4%';
424 Variable_name Value
425 default_collation_for_utf8mb4 utf8mb4_0900_ai_ci
426 SHOW SESSION VARIABLES LIKE '%default_collation_for_utf8mb4%';
427 Variable_name Value
428 default_collation_for_utf8mb4 utf8mb4_general_ci
429 CREATE DATABASE db1;
430 USE db1;
431 CREATE TABLE st1 (c1 INT ,c3 varchar(10) UNIQUE KEY);
432 SHOW CREATE TABLE st1;
433 Table Create Table
434 st1 CREATE TABLE `st1` (
435 `c1` int DEFAULT NULL,
436 `c3` varchar(10) DEFAULT NULL,
437 UNIQUE KEY `c3` (`c3`)
438 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 ALTER TABLE st1 DROP COLUMN c1;
440 SHOW CREATE TABLE st1;
441 Table Create Table
442 st1 CREATE TABLE `st1` (
443 `c3` varchar(10) DEFAULT NULL,
444 UNIQUE KEY `c3` (`c3`)
445 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
446 DROP DATABASE db1;
447 USE test;
448 SET @@default_collation_for_utf8mb4 = DEFAULT;
449 Warnings:
450 Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release.
451 #