Debian Codegraph @

mysql-test/suite/jp/t/jp_like_utf8.test

raw
1 --source include/have_utf8.inc
2 --source include/have_innodb.inc
3 --disable_warnings
4 drop table if exists `T1`;
5 drop table if exists `T2`;
6 drop table if exists `T3`;
7 drop table if exists `T4`;
8 drop table if exists `T5`;
9 drop table if exists `T6`;
10 drop table if exists `T7`;
11 drop table if exists `T8`;
12 drop table if exists `T9`;
13 --enable_warnings
14
15 #
16 # Test LIKE pattern matching using Japanese characters in utf8 encoding
17 #
18
19 SET character_set_collations='utf8mb3=utf8mb3_general_ci';
20
21 SET NAMES utf8;
22 SET character_set_database = utf8;
23
24 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
25 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
26 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
27 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
28 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
29 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
31 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
32 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
33
34 #Load the following data in each table
35 # jisx0201 hankaku-katakana data
36 # jisx0208 data
37 # jisx0212 supplemental character data
38
39 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
40 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
41 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
42 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
43 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
44 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
47 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
48
49 #InnoDB
50 SELECT * FROM `T1` WHERE `C1` LIKE ' %';
51 SELECT * FROM `T1` WHERE `C1` LIKE '% %';
52 SELECT * FROM `T1` WHERE `C1` LIKE '% ';
53 SELECT * FROM `T1` WHERE `C1` LIKE 'タ%';
54 SELECT * FROM `T1` WHERE `C1` LIKE '%ラリ%';
55 SELECT * FROM `T1` WHERE `C1` LIKE '%ソ';
56 SELECT * FROM `T1` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
57 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
58 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
59 SELECT * FROM `T2` WHERE `C1` LIKE ' %';
60 SELECT * FROM `T2` WHERE `C1` LIKE '% %';
61 SELECT * FROM `T2` WHERE `C1` LIKE '% ';
62 SELECT * FROM `T2` WHERE `C1` LIKE 'と%';
63 SELECT * FROM `T2` WHERE `C1` LIKE '%あ%';
64 SELECT * FROM `T2` WHERE `C1` LIKE '%わ';
65 SELECT * FROM `T2` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
66 SELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
67 SELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
68 SELECT * FROM `T3` WHERE `C1` LIKE '鼫%';
69 SELECT * FROM `T3` WHERE `C1` LIKE '%鼺%';
70 SELECT * FROM `T3` WHERE `C1` LIKE '%齖';
71 SELECT * FROM `T3` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
72 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
73 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
74
75 #MyISAM
76 SELECT * FROM `T4` WHERE `C1` LIKE ' %';
77 SELECT * FROM `T4` WHERE `C1` LIKE '% %';
78 SELECT * FROM `T4` WHERE `C1` LIKE '% ';
79 SELECT * FROM `T4` WHERE `C1` LIKE 'タ%';
80 SELECT * FROM `T4` WHERE `C1` LIKE '%ラリ%';
81 SELECT * FROM `T4` WHERE `C1` LIKE '%ソ';
82 SELECT * FROM `T4` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
83 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
84 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
85 SELECT * FROM `T5` WHERE `C1` LIKE ' %';
86 SELECT * FROM `T5` WHERE `C1` LIKE '% %';
87 SELECT * FROM `T5` WHERE `C1` LIKE '% ';
88 SELECT * FROM `T5` WHERE `C1` LIKE 'と%';
89 SELECT * FROM `T5` WHERE `C1` LIKE '%あ%';
90 SELECT * FROM `T5` WHERE `C1` LIKE '%わ';
91 SELECT * FROM `T5` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
92 SELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
93 SELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
94 SELECT * FROM `T6` WHERE `C1` LIKE '鼫%';
95 SELECT * FROM `T6` WHERE `C1` LIKE '%鼺%';
96 SELECT * FROM `T6` WHERE `C1` LIKE '%齖';
97 SELECT * FROM `T6` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
98 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
99 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
100
101 #MEMORY
102 SELECT * FROM `T7` WHERE `C1` LIKE ' %';
103 SELECT * FROM `T7` WHERE `C1` LIKE '% %';
104 SELECT * FROM `T7` WHERE `C1` LIKE '% ';
105 SELECT * FROM `T7` WHERE `C1` LIKE 'タ%';
106 SELECT * FROM `T7` WHERE `C1` LIKE '%ラリ%';
107 SELECT * FROM `T7` WHERE `C1` LIKE '%ソ';
108 SELECT * FROM `T7` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
109 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
110 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
111 SELECT * FROM `T8` WHERE `C1` LIKE ' %';
112 SELECT * FROM `T8` WHERE `C1` LIKE '% %';
113 SELECT * FROM `T8` WHERE `C1` LIKE '% ';
114 SELECT * FROM `T8` WHERE `C1` LIKE 'と%';
115 SELECT * FROM `T8` WHERE `C1` LIKE '%あ%';
116 SELECT * FROM `T8` WHERE `C1` LIKE '%わ';
117 SELECT * FROM `T8` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
118 SELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
119 SELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
120 SELECT * FROM `T9` WHERE `C1` LIKE '鼫%';
121 SELECT * FROM `T9` WHERE `C1` LIKE '%鼺%';
122 SELECT * FROM `T9` WHERE `C1` LIKE '%齖';
123 SELECT * FROM `T9` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
124 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
125 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
126
127 DROP TABLE `T1`;
128 DROP TABLE `T2`;
129 DROP TABLE `T3`;
130 DROP TABLE `T4`;
131 DROP TABLE `T5`;
132 DROP TABLE `T6`;
133 DROP TABLE `T7`;
134 DROP TABLE `T8`;
135 DROP TABLE `T9`;