Debian Codegraph @

mysql-test/suite/innodb/r/innodb-ucs2.result

raw
1 drop table if exists t1, t2;
2 create table t1 (
3 a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
4 ) character set utf8 engine = innodb;
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 create table t2 (
8 a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2))
9 ) character set ucs2 engine = innodb;
10 Warnings:
11 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
12 insert into t1 values (1,'abcdefg','abcdefg','one');
13 insert into t1 values (2,'ijkilmn','ijkilmn','two');
14 insert into t1 values (3,'qrstuvw','qrstuvw','three');
15 insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
16 Warnings:
17 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.
18 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.
19 insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
20 Warnings:
21 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.
22 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.
23 insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
24 Warnings:
25 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.
26 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.
27 insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
28 Warnings:
29 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.
30 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.
31 insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
32 Warnings:
33 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.
34 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.
35 insert into t2 values (1,'abcdefg','abcdefg','one');
36 insert into t2 values (2,'ijkilmn','ijkilmn','two');
37 insert into t2 values (3,'qrstuvw','qrstuvw','three');
38 insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
39 Warnings:
40 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
41 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
42 insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
43 Warnings:
44 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
45 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
46 insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
47 Warnings:
48 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
49 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
50 insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
51 Warnings:
52 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
53 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
54 insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
55 Warnings:
56 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
57 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
58 insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
59 Warnings:
60 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
61 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
62 insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
63 Warnings:
64 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
65 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
66 insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
67 Warnings:
68 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
69 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
70 insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
71 Warnings:
72 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
73 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
74 update t1 set filler = 'boo' where a = 1;
75 update t2 set filler ='email' where a = 4;
76 select filler,a,hex(b),hex(c) from t1 order by filler;
77 filler a hex(b) hex(c)
78 boo 1 61626364656667 61626364656667
79 eight 4 D0B1 D0B1
80 five 4 5B 5B
81 four 4 E880BD E880BD
82 seven 4 E880BDD0B1E880BD E880BDD0B1E880BD
83 six 4 E880BDE880BD E880BDE880BD
84 three 3 71727374757677 71727374757677
85 two 2 696A6B696C6D6E 696A6B696C6D6E
86 select filler,hex(b),a,hex(c) from t2 order by filler, hex(b) desc;
87 filler hex(b) a hex(c)
88 email 05630563 4 05630563
89 email 05612020 4 05612020
90 email 0563 4 0563
91 email 01FC 4 01FC
92 email 0120 4 0120
93 email 00E400E50068 4 00E400E50068
94 email 00640065 4 00640065
95 email 0000E400 4 0000E400
96 email 0000563001FC0563 4 0000563001FC0563
97 one 0061006200630064006500660067 1 0061006200630064006500660067
98 three 0071007200730074007500760077 3 0071007200730074007500760077
99 two 0069006A006B0069006C006D006E 2 0069006A006B0069006C006D006E
100 drop table t1;
101 drop table t2;
102 create table t1 (
103 a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
104 ) character set utf8 engine = innodb;
105 Warnings:
106 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.
107 create table t2 (
108 a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2))
109 ) character set ucs2 engine = innodb;
110 Warnings:
111 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
112 insert into t1 values (1,'abcdefg','abcdefg','one');
113 insert into t1 values (2,'ijkilmn','ijkilmn','two');
114 insert into t1 values (3,'qrstuvw','qrstuvw','three');
115 insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
116 Warnings:
117 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.
118 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.
119 insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
120 Warnings:
121 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.
122 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.
123 insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
124 Warnings:
125 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.
126 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.
127 insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
128 Warnings:
129 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.
130 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.
131 insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
132 Warnings:
133 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.
134 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.
135 insert into t2 values (1,'abcdefg','abcdefg','one');
136 insert into t2 values (2,'ijkilmn','ijkilmn','two');
137 insert into t2 values (3,'qrstuvw','qrstuvw','three');
138 insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
139 Warnings:
140 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
141 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
142 insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
143 Warnings:
144 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
145 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
146 insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
147 Warnings:
148 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
149 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
150 insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
151 Warnings:
152 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
153 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
154 insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
155 Warnings:
156 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
157 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
158 insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
159 Warnings:
160 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
161 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
162 insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
163 Warnings:
164 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
165 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
166 insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
167 Warnings:
168 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
169 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
170 insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
171 Warnings:
172 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
173 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
174 update t1 set filler = 'boo' where a = 1;
175 update t2 set filler ='email' where a = 4;
176 select filler,a,hex(b),hex(c) from t1 order by filler;
177 filler a hex(b) hex(c)
178 boo 1 61626364656667 61626364656667
179 eight 4 D0B1 D0B1
180 five 4 5B 5B
181 four 4 E880BD E880BD
182 seven 4 E880BDD0B1E880BD E880BDD0B1E880BD
183 six 4 E880BDE880BD E880BDE880BD
184 three 3 71727374757677 71727374757677
185 two 2 696A6B696C6D6E 696A6B696C6D6E
186 select filler,hex(b),a,hex(c) from t2 order by filler, hex(b) desc;
187 filler hex(b) a hex(c)
188 email 05630563 4 05630563
189 email 05612020 4 05612020
190 email 0563 4 0563
191 email 01FC 4 01FC
192 email 0120 4 0120
193 email 00E400E50068 4 00E400E50068
194 email 00640065 4 00640065
195 email 0000E400 4 0000E400
196 email 0000563001FC0563 4 0000563001FC0563
197 one 0061006200630064006500660067 1 0061006200630064006500660067
198 three 0071007200730074007500760077 3 0071007200730074007500760077
199 two 0069006A006B0069006C006D006E 2 0069006A006B0069006C006D006E
200 drop table t1;
201 drop table t2;
202 create table t1 (
203 a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
204 ) character set utf8 engine = innodb;
205 Warnings:
206 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.
207 create table t2 (
208 a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2))
209 ) character set ucs2 engine = innodb;
210 Warnings:
211 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
212 insert into t1 values (1,'abcdefg','abcdefg','one');
213 insert into t1 values (2,'ijkilmn','ijkilmn','two');
214 insert into t1 values (3,'qrstuvw','qrstuvw','three');
215 insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
216 Warnings:
217 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.
218 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.
219 insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
220 Warnings:
221 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.
222 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.
223 insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six');
224 Warnings:
225 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.
226 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.
227 insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven');
228 Warnings:
229 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.
230 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.
231 insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
232 Warnings:
233 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.
234 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.
235 insert into t2 values (1,'abcdefg','abcdefg','one');
236 insert into t2 values (2,'ijkilmn','ijkilmn','two');
237 insert into t2 values (3,'qrstuvw','qrstuvw','three');
238 insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
239 Warnings:
240 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
241 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
242 insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
243 Warnings:
244 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
245 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
246 insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
247 Warnings:
248 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
249 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
250 insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
251 Warnings:
252 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
253 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
254 insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
255 Warnings:
256 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
257 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
258 insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
259 Warnings:
260 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
261 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
262 insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven');
263 Warnings:
264 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
265 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
266 insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point');
267 Warnings:
268 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
269 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
270 insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
271 Warnings:
272 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
273 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
274 update t1 set filler = 'boo' where a = 1;
275 update t2 set filler ='email' where a = 4;
276 select filler,a,hex(b),hex(c) from t1 order by filler;
277 filler a hex(b) hex(c)
278 boo 1 61626364656667 61626364656667
279 eight 4 D0B1 D0B1
280 five 4 5B 5B
281 four 4 E880BD E880BD
282 seven 4 E880BDD0B1E880BD E880BDD0B1E880BD
283 six 4 E880BDE880BD E880BDE880BD
284 three 3 71727374757677 71727374757677
285 two 2 696A6B696C6D6E 696A6B696C6D6E
286 select filler,a,hex(b),hex(c) from t2 order by filler;
287 filler a hex(b) hex(c)
288 email 4 0000563001FC0563 0000563001FC0563
289 email 4 0000E400 0000E400
290 email 4 00640065 00640065
291 email 4 00E400E50068 00E400E50068
292 email 4 0120 0120
293 email 4 01FC 01FC
294 email 4 05612020 05612020
295 email 4 0563 0563
296 email 4 05630563 05630563
297 one 1 0061006200630064006500660067 0061006200630064006500660067
298 three 3 0071007200730074007500760077 0071007200730074007500760077
299 two 2 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E
300 drop table t1;
301 drop table t2;
302 create table t1 (
303 a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
304 ) character set utf8 engine = innodb;
305 Warnings:
306 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.
307 create table t2 (
308 a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2))
309 ) character set ucs2 engine = innodb;
310 Warnings:
311 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
312 insert into t1 values (1,'abcdefg','abcdefg','one');
313 insert into t1 values (2,'ijkilmn','ijkilmn','two');
314 insert into t1 values (3,'qrstuvw','qrstuvw','three');
315 insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four');
316 Warnings:
317 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.
318 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.
319 insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five');
320 Warnings:
321 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.
322 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.
323 insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight');
324 Warnings:
325 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.
326 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.
327 insert into t2 values (1,'abcdefg','abcdefg','one');
328 insert into t2 values (2,'ijkilmn','ijkilmn','two');
329 insert into t2 values (3,'qrstuvw','qrstuvw','three');
330 insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four');
331 Warnings:
332 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
333 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
334 insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five');
335 Warnings:
336 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
337 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
338 insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six');
339 Warnings:
340 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
341 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
342 insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven');
343 Warnings:
344 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
345 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
346 insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight');
347 Warnings:
348 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
349 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
350 insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten');
351 Warnings:
352 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
353 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
354 insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken');
355 Warnings:
356 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
357 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
358 update t1 set filler = 'boo' where a = 1;
359 update t2 set filler ='email' where a = 4;
360 select filler,a,hex(b),hex(c) from t1 order by filler;
361 filler a hex(b) hex(c)
362 boo 1 61626364656667 61626364656667
363 eight 4 D0B1 D0B1
364 five 4 5B 5B
365 four 4 E880BD E880BD
366 three 3 71727374757677 71727374757677
367 two 2 696A6B696C6D6E 696A6B696C6D6E
368 select filler,a,hex(b),hex(c) from t2 order by filler;
369 filler a hex(b) hex(c)
370 email 4 0000E400 0000E400
371 email 4 00640065 00640065
372 email 4 00E400E50068 00E400E50068
373 email 4 0120 0120
374 email 4 01FC 01FC
375 email 4 05612020 05612020
376 email 4 0563 0563
377 one 1 61626364656667 61626364656667
378 three 3 71727374757677 71727374757677
379 two 2 696A6B696C6D6E 696A6B696C6D6E
380 drop table t1;
381 drop table t2;
382 commit;
383 CREATE TABLE t1 (
384 ind enum('0','1','2') NOT NULL default '0',
385 string1 varchar(250) NOT NULL,
386 PRIMARY KEY (ind)
387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
388 Warnings:
389 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.
390 CREATE TABLE t2 (
391 ind enum('0','1','2') NOT NULL default '0',
392 string1 varchar(250) NOT NULL,
393 PRIMARY KEY (ind)
394 ) ENGINE=InnoDB DEFAULT CHARSET=ucs2;
395 Warnings:
396 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
397 INSERT INTO t1 VALUES ('1', ''),('2', '');
398 INSERT INTO t2 VALUES ('1', ''),('2', '');
399 SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
400 hex(ind) hex(string1)
401 31
402 32
403 SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
404 hex(ind) hex(string1)
405 0031
406 0032
407 drop table t1,t2;
408 CREATE TABLE t1 (
409 ind set('0','1','2') NOT NULL default '0',
410 string1 varchar(250) NOT NULL,
411 PRIMARY KEY (ind)
412 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
413 Warnings:
414 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.
415 CREATE TABLE t2 (
416 ind set('0','1','2') NOT NULL default '0',
417 string1 varchar(250) NOT NULL,
418 PRIMARY KEY (ind)
419 ) ENGINE=InnoDB DEFAULT CHARSET=ucs2;
420 Warnings:
421 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
422 INSERT INTO t1 VALUES ('1', ''),('2', '');
423 INSERT INTO t2 VALUES ('1', ''),('2', '');
424 SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1;
425 hex(ind) hex(string1)
426 31
427 32
428 SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1;
429 hex(ind) hex(string1)
430 0031
431 0032
432 drop table t1,t2;
433 CREATE TABLE t1 (
434 ind bit not null,
435 string1 varchar(250) NOT NULL,
436 PRIMARY KEY (ind)
437 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
438 Warnings:
439 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.
440 CREATE TABLE t2 (
441 ind bit not null,
442 string1 varchar(250) NOT NULL,
443 PRIMARY KEY (ind)
444 ) ENGINE=InnoDB DEFAULT CHARSET=ucs2;
445 Warnings:
446 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
447 insert into t1 values(0,''),(1,'');
448 insert into t2 values(0,''),(1,'');
449 select hex(ind),hex(string1) from t1 order by string1;
450 hex(ind) hex(string1)
451 0
452 1
453 select hex(ind),hex(string1) from t2 order by string1;
454 hex(ind) hex(string1)
455 0
456 1
457 drop table t1,t2;
458 create table t2 (
459 a int, b char(10), filler char(10), primary key(a, b(2))
460 ) character set utf8 engine = innodb;
461 Warnings:
462 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.
463 insert into t2 values (1,'abcdefg','one');
464 insert into t2 values (2,'ijkilmn','two');
465 insert into t2 values (3, 'qrstuvw','three');
466 update t2 set a=5, filler='booo' where a=1;
467 drop table t2;
468 create table t2 (
469 a int, b char(10), filler char(10), primary key(a, b(2))
470 ) character set ucs2 engine = innodb;
471 Warnings:
472 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
473 insert into t2 values (1,'abcdefg','one');
474 insert into t2 values (2,'ijkilmn','two');
475 insert into t2 values (3, 'qrstuvw','three');
476 update t2 set a=5, filler='booo' where a=1;
477 drop table t2;
478 create table t1(a int not null, b char(110),primary key(a,b(100))) engine=innodb default charset=utf8;
479 Warnings:
480 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.
481 insert into t1 values(1,'abcdefg'),(2,'defghijk');
482 insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
483 Warnings:
484 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.
485 insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
486 Warnings:
487 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.
488 select a,hex(b) from t1 order by b;
489 a hex(b)
490 1 61626364656667
491 2 6465666768696A6B
492 6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
493 7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
494 update t1 set b = 'three' where a = 6;
495 drop table t1;
496 create table t1(a int not null, b text(110),primary key(a,b(100))) engine=innodb default charset=utf8;
497 Warnings:
498 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.
499 insert into t1 values(1,'abcdefg'),(2,'defghijk');
500 insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1);
501 Warnings:
502 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.
503 insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2);
504 Warnings:
505 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.
506 select a,hex(b) from t1 order by b;
507 a hex(b)
508 1 61626364656667
509 2 6465666768696A6B
510 6 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1
511 7 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2
512 update t1 set b = 'three' where a = 6;
513 drop table t1;
514 End of 5.0 tests