Debian Codegraph @

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

raw
1 --disable_warnings
2 drop table if exists `T1`;
3 drop table if exists `T2`;
4 drop table if exists `T3`;
5 drop table if exists `T4`;
6 drop table if exists `T5`;
7 drop table if exists `T6`;
8 drop table if exists `T7`;
9 drop table if exists `T8`;
10 drop table if exists `T9`;
11 --enable_warnings
12
13 #
14 # Test LIKE pattern matching using Japanese characters in utf8 encoding
15 #
16
17 SET NAMES utf8;
18 SET character_set_database = utf8;
19
20 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
22 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
23 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
24 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
25 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
26 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
27 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
28 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
29
30 #Load the following data in each table
31 # jisx0201 hankaku-katakana data
32 # jisx0208 data
33 # jisx0212 supplemental character data
34
35 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
36 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
37 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
38 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
39 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
40 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
41 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
42 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
43 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
44
45 #InnoDB
46 SELECT * FROM `T1` WHERE `C1` LIKE ' %';
47 SELECT * FROM `T1` WHERE `C1` LIKE '% %';
48 SELECT * FROM `T1` WHERE `C1` LIKE '% ';
49 SELECT * FROM `T1` WHERE `C1` LIKE 'タ%';
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 `T2` WHERE `C1` LIKE ' %';
56 SELECT * FROM `T2` WHERE `C1` LIKE '% %';
57 SELECT * FROM `T2` WHERE `C1` LIKE '% ';
58 SELECT * FROM `T2` 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 `T3` WHERE `C1` LIKE '鼫%';
65 SELECT * FROM `T3` WHERE `C1` LIKE '%鼺%';
66 SELECT * FROM `T3` WHERE `C1` LIKE '%齖';
67 SELECT * FROM `T3` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
68 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
69 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
70
71 #MyISAM
72 SELECT * FROM `T4` WHERE `C1` LIKE ' %';
73 SELECT * FROM `T4` WHERE `C1` LIKE '% %';
74 SELECT * FROM `T4` WHERE `C1` LIKE '% ';
75 SELECT * FROM `T4` WHERE `C1` LIKE 'タ%';
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 `T5` WHERE `C1` LIKE ' %';
82 SELECT * FROM `T5` WHERE `C1` LIKE '% %';
83 SELECT * FROM `T5` WHERE `C1` LIKE '% ';
84 SELECT * FROM `T5` 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 `T6` WHERE `C1` LIKE '鼫%';
91 SELECT * FROM `T6` WHERE `C1` LIKE '%鼺%';
92 SELECT * FROM `T6` WHERE `C1` LIKE '%齖';
93 SELECT * FROM `T6` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
94 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
95 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
96
97 #MEMORY
98 SELECT * FROM `T7` WHERE `C1` LIKE ' %';
99 SELECT * FROM `T7` WHERE `C1` LIKE '% %';
100 SELECT * FROM `T7` WHERE `C1` LIKE '% ';
101 SELECT * FROM `T7` WHERE `C1` LIKE 'タ%';
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 `T8` WHERE `C1` LIKE ' %';
108 SELECT * FROM `T8` WHERE `C1` LIKE '% %';
109 SELECT * FROM `T8` WHERE `C1` LIKE '% ';
110 SELECT * FROM `T8` 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 `T9` WHERE `C1` LIKE '鼫%';
117 SELECT * FROM `T9` WHERE `C1` LIKE '%鼺%';
118 SELECT * FROM `T9` WHERE `C1` LIKE '%齖';
119 SELECT * FROM `T9` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
120 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
121 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
122
123 DROP TABLE `T1`;
124 DROP TABLE `T2`;
125 DROP TABLE `T3`;
126 DROP TABLE `T4`;
127 DROP TABLE `T5`;
128 DROP TABLE `T6`;
129 DROP TABLE `T7`;
130 DROP TABLE `T8`;
131 DROP TABLE `T9`;