Debian Codegraph @

mysql-test/suite/innodb/r/innodb-2byte-collation.result

raw
1 show variables like 'character_sets_dir%';
2 Variable_name Value
3 character_sets_dir MYSQL_TEST_DIR/std_data/
4 set names utf8;
5 Warnings:
6 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
7 select collation_name, character_set_name, id from information_schema.collations where id>256 order by id;
8 collation_name character_set_name id
9 utf8mb4_is_0900_ai_ci utf8mb4 257
10 utf8mb4_lv_0900_ai_ci utf8mb4 258
11 utf8mb4_ro_0900_ai_ci utf8mb4 259
12 utf8mb4_sl_0900_ai_ci utf8mb4 260
13 utf8mb4_pl_0900_ai_ci utf8mb4 261
14 utf8mb4_et_0900_ai_ci utf8mb4 262
15 utf8mb4_es_0900_ai_ci utf8mb4 263
16 utf8mb4_sv_0900_ai_ci utf8mb4 264
17 utf8mb4_tr_0900_ai_ci utf8mb4 265
18 utf8mb4_cs_0900_ai_ci utf8mb4 266
19 utf8mb4_da_0900_ai_ci utf8mb4 267
20 utf8mb4_lt_0900_ai_ci utf8mb4 268
21 utf8mb4_sk_0900_ai_ci utf8mb4 269
22 utf8mb4_es_trad_0900_ai_ci utf8mb4 270
23 utf8mb4_la_0900_ai_ci utf8mb4 271
24 utf8mb4_eo_0900_ai_ci utf8mb4 273
25 utf8mb4_hu_0900_ai_ci utf8mb4 274
26 utf8mb4_hr_0900_ai_ci utf8mb4 275
27 utf8mb4_vi_0900_ai_ci utf8mb4 277
28 utf8mb4_0900_as_cs utf8mb4 278
29 utf8mb4_de_pb_0900_as_cs utf8mb4 279
30 utf8mb4_is_0900_as_cs utf8mb4 280
31 utf8mb4_lv_0900_as_cs utf8mb4 281
32 utf8mb4_ro_0900_as_cs utf8mb4 282
33 utf8mb4_sl_0900_as_cs utf8mb4 283
34 utf8mb4_pl_0900_as_cs utf8mb4 284
35 utf8mb4_et_0900_as_cs utf8mb4 285
36 utf8mb4_es_0900_as_cs utf8mb4 286
37 utf8mb4_sv_0900_as_cs utf8mb4 287
38 utf8mb4_tr_0900_as_cs utf8mb4 288
39 utf8mb4_cs_0900_as_cs utf8mb4 289
40 utf8mb4_da_0900_as_cs utf8mb4 290
41 utf8mb4_lt_0900_as_cs utf8mb4 291
42 utf8mb4_sk_0900_as_cs utf8mb4 292
43 utf8mb4_es_trad_0900_as_cs utf8mb4 293
44 utf8mb4_la_0900_as_cs utf8mb4 294
45 utf8mb4_eo_0900_as_cs utf8mb4 296
46 utf8mb4_hu_0900_as_cs utf8mb4 297
47 utf8mb4_hr_0900_as_cs utf8mb4 298
48 utf8mb4_vi_0900_as_cs utf8mb4 300
49 utf8mb4_ja_0900_as_cs utf8mb4 303
50 utf8mb4_ja_0900_as_cs_ks utf8mb4 304
51 utf8mb4_0900_as_ci utf8mb4 305
52 utf8mb4_ru_0900_ai_ci utf8mb4 306
53 utf8mb4_ru_0900_as_cs utf8mb4 307
54 utf8mb4_zh_0900_as_cs utf8mb4 308
55 utf8mb4_0900_bin utf8mb4 309
56 utf8mb4_nb_0900_ai_ci utf8mb4 310
57 utf8mb4_nb_0900_as_cs utf8mb4 311
58 utf8mb4_nn_0900_ai_ci utf8mb4 312
59 utf8mb4_nn_0900_as_cs utf8mb4 313
60 utf8mb4_sr_latn_0900_ai_ci utf8mb4 314
61 utf8mb4_sr_latn_0900_as_cs utf8mb4 315
62 utf8mb4_bs_0900_ai_ci utf8mb4 316
63 utf8mb4_bs_0900_as_cs utf8mb4 317
64 utf8mb4_bg_0900_ai_ci utf8mb4 318
65 utf8mb4_bg_0900_as_cs utf8mb4 319
66 utf8mb4_gl_0900_ai_ci utf8mb4 320
67 utf8mb4_gl_0900_as_cs utf8mb4 321
68 utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322
69 utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323
70 utf8mb4_test_ci utf8mb4 326
71 utf16_test_ci utf16 327
72 utf8mb4_test_400_ci utf8mb4 328
73 utf8_bengali_standard_ci utf8mb3 336
74 utf8_bengali_traditional_ci utf8mb3 337
75 utf8_phone_ci utf8mb3 352
76 utf8_test_ci utf8mb3 353
77 utf8_5624_1 utf8mb3 354
78 utf8_5624_2 utf8mb3 355
79 utf8_5624_3 utf8mb3 356
80 utf8_5624_4 utf8mb3 357
81 ucs2_test_ci ucs2 358
82 ucs2_vn_ci ucs2 359
83 ucs2_5624_1 ucs2 360
84 utf8_5624_5 utf8mb3 368
85 utf32_test_ci utf32 391
86 latin1_test latin1 1025
87 utf8_maxuserid_ci utf8mb3 2047
88 show collation like '%test%';
89 Collation Charset Id Default Compiled Sortlen Pad_attribute
90 latin1_test latin1 1025 0 PAD SPACE
91 ucs2_test_ci ucs2 358 8 PAD SPACE
92 utf16_test_ci utf16 327 8 PAD SPACE
93 utf32_test_ci utf32 391 8 PAD SPACE
94 utf8mb4_test_400_ci utf8mb4 328 8 PAD SPACE
95 utf8mb4_test_ci utf8mb4 326 8 PAD SPACE
96 utf8_test_ci utf8mb3 353 8 PAD SPACE
97 show collation like 'ucs2_vn_ci';
98 Collation Charset Id Default Compiled Sortlen Pad_attribute
99 ucs2_vn_ci ucs2 359 8 PAD SPACE
100 create table 2byte_collation (c1 char(1) character set ucs2 collate ucs2_vn_ci)
101 engine = InnoDB;
102 Warnings:
103 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
104 Warning 4079 'ucs2_vn_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
105 Warning 4162 'ucs2_vn_ci' is a user defined collation. User defined collations are deprecated and will be removed in a future release. Consider using a compiled collation instead.
106 insert into 2byte_collation values (0x0061);
107 set @@character_set_results=NULL;
108 select hex(c1) from 2byte_collation;
109 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
110 def hex(c1) 253 12 4 Y 0 31 33
111 hex(c1)
112 0061
113 drop table 2byte_collation;
114 CREATE TABLE 2byte_collation (s1 char(10) character set utf8 collate utf8_maxuserid_ci) engine = innodb;
115 Warnings:
116 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
117 Warning 3778 'utf8_maxuserid_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
118 Warning 4162 'utf8_maxuserid_ci' is a user defined collation. User defined collations are deprecated and will be removed in a future release. Consider using a compiled collation instead.
119 INSERT INTO 2byte_collation VALUES ('a'),('b');
120 SELECT * FROM 2byte_collation WHERE s1='a' ORDER BY BINARY s1;
121 s1
122 a
123 b
124 Warnings:
125 Warning 1287 'BINARY expr' is deprecated and will be removed in a future release. Please use CAST instead
126 DROP TABLE 2byte_collation;
127 SET @innodb_change_buffering_debug_orig = @@innodb_change_buffering_debug;
128 SET GLOBAL innodb_change_buffering_debug = 1;
129 set names utf8;
130 Warnings:
131 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
132 show collation like 'utf8_maxuserid_ci';
133 Collation Charset Id Default Compiled Sortlen Pad_attribute
134 utf8_maxuserid_ci utf8mb3 2047 8 PAD SPACE
135 CREATE TABLE 2byte_collation(
136 a INT AUTO_INCREMENT PRIMARY KEY,
137 b CHAR(100) character set utf8 collate utf8_maxuserid_ci,
138 c INT,
139 z INT,
140 INDEX(b))
141 ENGINE=InnoDB STATS_PERSISTENT=0;
142 Warnings:
143 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
144 Warning 3778 'utf8_maxuserid_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
145 Warning 4162 'utf8_maxuserid_ci' is a user defined collation. User defined collations are deprecated and will be removed in a future release. Consider using a compiled collation instead.
146 INSERT INTO 2byte_collation VALUES(0,'x',1, 1);
147 CREATE UNIQUE INDEX idx3 ON 2byte_collation(c, b);
148 INSERT INTO 2byte_collation SELECT 0,b,c+1,z+1 FROM 2byte_collation;
149 INSERT INTO 2byte_collation SELECT 0,b,c+10,z+10 FROM 2byte_collation;
150 INSERT INTO 2byte_collation SELECT 0,b,c+20,z+20 FROM 2byte_collation;
151 INSERT INTO 2byte_collation SELECT 0,b,c+50,z+50 FROM 2byte_collation;
152 INSERT INTO 2byte_collation SELECT 0,b,c+100,z+100 FROM 2byte_collation;
153 INSERT INTO 2byte_collation SELECT 0,b,c+200,z+200 FROM 2byte_collation;
154 INSERT INTO 2byte_collation SELECT 0,b,c+400,z+400 FROM 2byte_collation;
155 INSERT INTO 2byte_collation SELECT 0,b,c+800,z+800 FROM 2byte_collation;
156 INSERT INTO 2byte_collation SELECT 0,b,c+1600,z+1600 FROM 2byte_collation;
157 INSERT INTO 2byte_collation SELECT 0,b,c+4000,z+4000 FROM 2byte_collation;
158 CREATE INDEX idx5 ON 2byte_collation(b, c);
159 SELECT b FROM 2byte_collation LIMIT 10;
160 b
161 x
162 x
163 x
164 x
165 x
166 x
167 x
168 x
169 x
170 x
171 INSERT INTO 2byte_collation VALUES (10001, "a", 20001, 20001);
172 UPDATE 2byte_collation set b = "aaa" where c = 20001;
173 DROP TABLE 2byte_collation;
174 SET GLOBAL innodb_change_buffering_debug = 0;