Debian Codegraph @

mysql-test/suite/maria/ctype_utf8mb3_uca.result

raw
1 #
2 # Start of 10.4 tests
3 #
4 SET default_storage_engine=Aria;
5 #
6 # MDEV-30048 Prefix keys for CHAR work differently for MyISAM vs InnoDB
7 #
8 SET NAMES utf8mb3;
9 CREATE TABLE t1 (a CHAR(10) COLLATE utf8mb3_unicode_nopad_ci, UNIQUE KEY(a));
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `a` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci DEFAULT NULL,
14 UNIQUE KEY `a` (`a`)
15 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
16 INSERT INTO t1 VALUES ('ss'),('ß');
17 DROP TABLE t1;
18 CREATE TABLE t1 (a CHAR(10) COLLATE utf8mb3_unicode_nopad_ci, UNIQUE KEY(a(2)));
19 SHOW CREATE TABLE t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `a` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci DEFAULT NULL,
23 UNIQUE KEY `a` (`a`(2))
24 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
25 INSERT INTO t1 VALUES ('ss'),('ß');
26 DROP TABLE t1;
27 CREATE TABLE t1 (a CHAR(120) COLLATE utf8mb3_unicode_nopad_ci, UNIQUE KEY(a));
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `a` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci DEFAULT NULL,
32 UNIQUE KEY `a` (`a`)
33 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
34 INSERT INTO t1 VALUES ('ss'),('ß');
35 DROP TABLE t1;
36 CREATE TABLE t1 (a CHAR(120) COLLATE utf8mb3_unicode_nopad_ci, UNIQUE KEY(a(100)));
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `a` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci DEFAULT NULL,
41 UNIQUE KEY `a` (`a`(100))
42 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
43 INSERT INTO t1 VALUES ('ss'),('ß');
44 DROP TABLE t1;
45 #
46 # MDEV-30050 Inconsistent results of DISTINCT with NOPAD
47 #
48 CREATE TABLE t1 (c CHAR(100) COLLATE utf8mb3_unicode_nopad_ci);
49 SHOW CREATE TABLE t1;
50 Table Create Table
51 t1 CREATE TABLE `t1` (
52 `c` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_nopad_ci DEFAULT NULL
53 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
54 INSERT INTO t1 VALUES ('ss'),('ß');
55 SET big_tables=0;
56 Warnings:
57 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
58 SELECT DISTINCT c FROM t1;
59 c
60 ss
61 ß
62 SET big_tables=1;
63 Warnings:
64 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
65 SELECT DISTINCT c FROM t1;
66 c
67 ss
68 ß
69 DROP TABLE t1;
70 SET big_tables=DEFAULT;
71 Warnings:
72 Warning 1287 '@@big_tables' is deprecated and will be removed in a future release
73 #
74 # End of 10.4 tests
75 #