Debian Codegraph @

mysql-test/suite/ndbcluster/charset.result

raw
1 create table t1 (
2 a char(3) character set latin1 collate latin1_bin primary key
3 ) engine=ndb;
4 insert into t1 values('aAa');
5 insert into t1 values('aaa');
6 insert into t1 values('AAA');
7 select * from t1 order by a;
8 a
9 AAA
10 aAa
11 aaa
12 select * from t1 where a = 'aAa';
13 a
14 aAa
15 select * from t1 where a = 'aaa';
16 a
17 aaa
18 select * from t1 where a = 'AaA';
19 a
20 select * from t1 where a = 'AAA';
21 a
22 AAA
23 drop table t1;
24 create table t1 (
25 a char(3) character set latin1 collate latin1_swedish_ci primary key
26 ) engine=ndb;
27 insert into t1 values('aAa');
28 insert into t1 values('aaa');
29 ERROR 23000: Duplicate entry 'aaa' for key 't1.PRIMARY'
30 insert into t1 values('AAA');
31 ERROR 23000: Duplicate entry 'AAA' for key 't1.PRIMARY'
32 select * from t1 order by a;
33 a
34 aAa
35 select * from t1 where a = 'aAa';
36 a
37 aAa
38 select * from t1 where a = 'aaa';
39 a
40 aAa
41 select * from t1 where a = 'AaA';
42 a
43 aAa
44 select * from t1 where a = 'AAA';
45 a
46 aAa
47 drop table t1;
48 create table t1 (
49 a varchar(20) character set latin1 collate latin1_swedish_ci primary key
50 ) engine=ndb;
51 insert into t1 values ('A'),('b '),('C '),('d '),('E'),('f');
52 insert into t1 values('b');
53 ERROR 23000: Duplicate entry 'b' for key 't1.PRIMARY'
54 insert into t1 values('a ');
55 ERROR 23000: Duplicate entry 'a ' for key 't1.PRIMARY'
56 select a,length(a) from t1 order by a;
57 a length(a)
58 A 1
59 b 2
60 C 3
61 d 7
62 E 1
63 f 1
64 select a,length(a) from t1 order by a desc;
65 a length(a)
66 f 1
67 E 1
68 d 7
69 C 3
70 b 2
71 A 1
72 select * from t1 where a = 'a';
73 a
74 A
75 select * from t1 where a = 'a ';
76 a
77 A
78 select * from t1 where a = 'd';
79 a
80 d
81 drop table t1;
82 create table t1 (
83 p int primary key,
84 a char(3) character set latin1 collate latin1_bin not null,
85 unique key(a)
86 ) engine=ndb;
87 insert into t1 values(1, 'aAa');
88 insert into t1 values(2, 'aaa');
89 insert into t1 values(3, 'AAA');
90 select * from t1 order by p;
91 p a
92 1 aAa
93 2 aaa
94 3 AAA
95 select * from t1 where a = 'aAa';
96 p a
97 1 aAa
98 select * from t1 where a = 'aaa';
99 p a
100 2 aaa
101 select * from t1 where a = 'AaA';
102 p a
103 select * from t1 where a = 'AAA';
104 p a
105 3 AAA
106 drop table t1;
107 create table t1 (
108 p int primary key,
109 a char(3) character set latin1 collate latin1_swedish_ci not null,
110 unique key(a)
111 ) engine=ndb;
112 insert into t1 values(1, 'aAa');
113 insert into t1 values(2, 'aaa');
114 ERROR 23000: Duplicate entry 'aaa' for key 't1.a'
115 insert into t1 values(3, 'AAA');
116 ERROR 23000: Duplicate entry 'AAA' for key 't1.a'
117 select * from t1 order by p;
118 p a
119 1 aAa
120 select * from t1 where a = 'aAa';
121 p a
122 1 aAa
123 select * from t1 where a = 'aaa';
124 p a
125 1 aAa
126 select * from t1 where a = 'AaA';
127 p a
128 1 aAa
129 select * from t1 where a = 'AAA';
130 p a
131 1 aAa
132 drop table t1;
133 create table t1 (
134 p int primary key,
135 a varchar(20) character set latin1 collate latin1_swedish_ci not null,
136 unique key(a)
137 ) engine=ndb;
138 insert into t1 values (1,'A'),(2,'b '),(3,'C '),(4,'d '),(5,'E'),(6,'f');
139 insert into t1 values(99,'b');
140 ERROR 23000: Duplicate entry 'b' for key 't1.a'
141 insert into t1 values(99,'a ');
142 ERROR 23000: Duplicate entry 'a ' for key 't1.a'
143 select a,length(a) from t1 order by a;
144 a length(a)
145 A 1
146 b 2
147 C 3
148 d 7
149 E 1
150 f 1
151 select a,length(a) from t1 order by a desc;
152 a length(a)
153 f 1
154 E 1
155 d 7
156 C 3
157 b 2
158 A 1
159 select * from t1 where a = 'a';
160 p a
161 1 A
162 select * from t1 where a = 'a ';
163 p a
164 1 A
165 select * from t1 where a = 'd';
166 p a
167 4 d
168 drop table t1;
169 create table t1 (
170 p int primary key,
171 a char(3) character set latin1 collate latin1_bin not null,
172 index(a)
173 ) engine=ndb;
174 insert into t1 values(1, 'aAa');
175 insert into t1 values(2, 'aaa');
176 insert into t1 values(3, 'AAA');
177 insert into t1 values(4, 'aAa');
178 insert into t1 values(5, 'aaa');
179 insert into t1 values(6, 'AAA');
180 select * from t1 order by p;
181 p a
182 1 aAa
183 2 aaa
184 3 AAA
185 4 aAa
186 5 aaa
187 6 AAA
188 select * from t1 where a = 'aAa' order by p;
189 p a
190 1 aAa
191 4 aAa
192 select * from t1 where a = 'aaa' order by p;
193 p a
194 2 aaa
195 5 aaa
196 select * from t1 where a = 'AaA' order by p;
197 p a
198 select * from t1 where a = 'AAA' order by p;
199 p a
200 3 AAA
201 6 AAA
202 drop table t1;
203 create table t1 (
204 p int primary key,
205 a char(3) character set latin1 collate latin1_swedish_ci not null,
206 index(a)
207 ) engine=ndb;
208 insert into t1 values(1, 'aAa');
209 insert into t1 values(2, 'aaa');
210 insert into t1 values(3, 'AAA');
211 insert into t1 values(4, 'aAa');
212 insert into t1 values(5, 'aaa');
213 insert into t1 values(6, 'AAA');
214 select * from t1 order by p;
215 p a
216 1 aAa
217 2 aaa
218 3 AAA
219 4 aAa
220 5 aaa
221 6 AAA
222 select * from t1 where a = 'aAa' order by p;
223 p a
224 1 aAa
225 2 aaa
226 3 AAA
227 4 aAa
228 5 aaa
229 6 AAA
230 select * from t1 where a = 'aaa' order by p;
231 p a
232 1 aAa
233 2 aaa
234 3 AAA
235 4 aAa
236 5 aaa
237 6 AAA
238 select * from t1 where a = 'AaA' order by p;
239 p a
240 1 aAa
241 2 aaa
242 3 AAA
243 4 aAa
244 5 aaa
245 6 AAA
246 select * from t1 where a = 'AAA' order by p;
247 p a
248 1 aAa
249 2 aaa
250 3 AAA
251 4 aAa
252 5 aaa
253 6 AAA
254 drop table t1;
255 create table t1 (
256 p int primary key,
257 a varchar(20) character set latin1 collate latin1_swedish_ci not null,
258 index(a, p)
259 ) engine=ndb;
260 insert into t1 values (1,'A'),(2,'b '),(3,'C '),(4,'d '),(5,'E'),(6,'f');
261 insert into t1 values (7,'a'),(8,'B '),(9,'c '),(10,'D'),(11,'e'),(12,'F ');
262 select p,a,length(a) from t1 order by a, p;
263 p a length(a)
264 1 A 1
265 7 a 1
266 2 b 2
267 8 B 2
268 3 C 3
269 9 c 3
270 4 d 7
271 10 D 1
272 5 E 1
273 11 e 1
274 6 f 1
275 12 F 3
276 select * from t1 where a = 'a ' order by a desc, p desc;
277 p a
278 7 a
279 1 A
280 select * from t1 where a >= 'D' order by a, p;
281 p a
282 4 d
283 10 D
284 5 E
285 11 e
286 6 f
287 12 F
288 select * from t1 where a < 'D' order by a, p;
289 p a
290 1 A
291 7 a
292 2 b
293 8 B
294 3 C
295 9 c
296 select count(*) from t1 x, t1 y, t1 z where x.a = y.a and y.a = z.a;
297 count(*)
298 48
299 drop table t1;
300 create table t1 (
301 a char(10) primary key
302 ) engine=ndbcluster default charset=latin1;
303 insert into t1 values ('aaabb');
304 select * from t1;
305 a
306 aaabb
307 replace into t1 set a = 'AAABB';
308 select * from t1;
309 a
310 AAABB
311 replace into t1 set a = 'aAaBb';
312 select * from t1;
313 a
314 aAaBb
315 replace into t1 set a = 'aaabb';
316 select * from t1;
317 a
318 aaabb
319 drop table t1;
320 create table t1(a int) engine = ndbcluster;
321 create table T1(a int) engine = ndbcluster;
322 drop table T1;
323 drop table t1;
324 create table t1 (
325 c1 varchar(10) collate utf8mb4_0900_as_cs,
326 primary key(c1)
327 ) engine = ndbcluster;
328 insert into t1 values('ABC_x'), ('ABC_X');
329 insert into t1 values('ABCDEF_x'), ('ABCDEF_X');
330 insert into t1 values('ABCDEFGH_x'), ('ABCDEFGH_X');
331 select * from t1;
332 c1
333 ABCDEFGH_X
334 ABCDEFGH_x
335 ABCDEF_X
336 ABCDEF_x
337 ABC_X
338 ABC_x
339 drop table t1;
340 create table t1 (
341 c1 varchar(10) collate utf8mb4_ja_0900_as_cs_ks,
342 primary key(c1)
343 ) engine = ndbcluster;
344 drop table t1;
345 create table t1 (
346 c1 varchar(10) collate utf8mb4_ja_0900_as_cs_ks,
347 primary key using hash(c1)
348 ) engine = ndbcluster;
349 drop table t1;
350 create table t1 (
351 c1 varchar(10) collate utf8mb4_ja_0900_as_cs_ks,
352 unique key(c1)
353 ) engine = ndbcluster;
354 drop table t1;
355 create table t1 (
356 c1 varchar(10) not null collate utf8mb4_ja_0900_as_cs_ks,
357 unique key using hash(c1)
358 ) engine = ndbcluster;
359 drop table t1;
360 create table t1 (
361 c1 varchar(10) collate utf8mb4_ja_0900_as_cs_ks,
362 key(c1)
363 ) engine = ndbcluster;
364 drop table t1;
365 create table t (
366 ck char(1) collate utf8mb4_0900_ai_ci primary key
367 ) engine=ndb;
368 insert into t values (_utf16 X'212B');
369 insert into t values (_utf16 X'00C5');
370 ERROR 23000: Duplicate entry 'Å' for key 't.PRIMARY'
371 select count(*) from t;
372 count(*)
373 1
374 drop table t;
375 create table t (
376 ck char(10) collate utf8mb4_0900_ai_ci primary key
377 ) engine=ndb;
378 insert into t values (_utf16 X'212B');
379 insert into t values (_utf16 X'00C5');
380 ERROR 23000: Duplicate entry 'Å' for key 't.PRIMARY'
381 select count(*) from t;
382 count(*)
383 1
384 drop table t;
385 create table t (
386 ck varchar(1) collate utf8mb4_0900_ai_ci primary key
387 ) engine=ndb;
388 insert into t values (_utf16 X'212B');
389 insert into t values (_utf16 X'00C5');
390 ERROR 23000: Duplicate entry 'Å' for key 't.PRIMARY'
391 select count(*) from t;
392 count(*)
393 1
394 drop table t;
395 create table t (
396 ck varchar(10) collate utf8mb4_0900_ai_ci primary key
397 ) engine=ndb;
398 insert into t values (_utf16 X'212B');
399 insert into t values (_utf16 X'00C5');
400 ERROR 23000: Duplicate entry 'Å' for key 't.PRIMARY'
401 select count(*) from t;
402 count(*)
403 1
404 drop table t;