Debian Codegraph @

mysql-test/suite/jp/r/jp_locate_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 SET character_set_database = utf8;
12 CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
16 CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
19 CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
21 INSERT INTO `T1` VALUES ('アイウエオ');
22 INSERT INTO `T2` VALUES ('あいうえお');
23 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
24 INSERT INTO `T4` VALUES ('アイウエオ');
25 INSERT INTO `T5` VALUES ('あいうえお');
26 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
27 INSERT INTO `T7` VALUES ('アイウエオ');
28 INSERT INTO `T8` VALUES ('あいうえお');
29 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
30 SELECT LOCATE('ア',`C1`) from `T1`;
31 LOCATE('ア',`C1`)
32 1
33 SELECT LOCATE('イ',`C1`) from `T1`;
34 LOCATE('イ',`C1`)
35 2
36 SELECT LOCATE('ウ',`C1`) from `T1`;
37 LOCATE('ウ',`C1`)
38 3
39 SELECT LOCATE('エ',`C1`) from `T1`;
40 LOCATE('エ',`C1`)
41 4
42 SELECT LOCATE('オ',`C1`) from `T1`;
43 LOCATE('オ',`C1`)
44 5
45 SELECT LOCATE('ン',`C1`) from `T1`;
46 LOCATE('ン',`C1`)
47 0
48 SELECT LOCATE('あ',`C1`) from `T2`;
49 LOCATE('あ',`C1`)
50 1
51 SELECT LOCATE('い',`C1`) from `T2`;
52 LOCATE('い',`C1`)
53 2
54 SELECT LOCATE('う',`C1`) from `T2`;
55 LOCATE('う',`C1`)
56 3
57 SELECT LOCATE('え',`C1`) from `T2`;
58 LOCATE('え',`C1`)
59 4
60 SELECT LOCATE('お',`C1`) from `T2`;
61 LOCATE('お',`C1`)
62 5
63 SELECT LOCATE('ん',`C1`) from `T2`;
64 LOCATE('ん',`C1`)
65 0
66 SELECT LOCATE('龔',`C1`) from `T3`;
67 LOCATE('龔',`C1`)
68 1
69 SELECT LOCATE('龖',`C1`) from `T3`;
70 LOCATE('龖',`C1`)
71 2
72 SELECT LOCATE('龗',`C1`) from `T3`;
73 LOCATE('龗',`C1`)
74 3
75 SELECT LOCATE('龞',`C1`) from `T3`;
76 LOCATE('龞',`C1`)
77 4
78 SELECT LOCATE('龡',`C1`) from `T3`;
79 LOCATE('龡',`C1`)
80 5
81 SELECT LOCATE('丂',`C1`) from `T3`;
82 LOCATE('丂',`C1`)
83 0
84 SELECT LOCATE('ア',`C1`) from `T4`;
85 LOCATE('ア',`C1`)
86 1
87 SELECT LOCATE('イ',`C1`) from `T4`;
88 LOCATE('イ',`C1`)
89 2
90 SELECT LOCATE('ウ',`C1`) from `T4`;
91 LOCATE('ウ',`C1`)
92 3
93 SELECT LOCATE('エ',`C1`) from `T4`;
94 LOCATE('エ',`C1`)
95 4
96 SELECT LOCATE('オ',`C1`) from `T4`;
97 LOCATE('オ',`C1`)
98 5
99 SELECT LOCATE('ン',`C1`) from `T4`;
100 LOCATE('ン',`C1`)
101 0
102 SELECT LOCATE('あ',`C1`) from `T5`;
103 LOCATE('あ',`C1`)
104 1
105 SELECT LOCATE('い',`C1`) from `T5`;
106 LOCATE('い',`C1`)
107 2
108 SELECT LOCATE('う',`C1`) from `T5`;
109 LOCATE('う',`C1`)
110 3
111 SELECT LOCATE('え',`C1`) from `T5`;
112 LOCATE('え',`C1`)
113 4
114 SELECT LOCATE('お',`C1`) from `T5`;
115 LOCATE('お',`C1`)
116 5
117 SELECT LOCATE('ん',`C1`) from `T5`;
118 LOCATE('ん',`C1`)
119 0
120 SELECT LOCATE('龔',`C1`) from `T6`;
121 LOCATE('龔',`C1`)
122 1
123 SELECT LOCATE('龖',`C1`) from `T6`;
124 LOCATE('龖',`C1`)
125 2
126 SELECT LOCATE('龗',`C1`) from `T6`;
127 LOCATE('龗',`C1`)
128 3
129 SELECT LOCATE('龞',`C1`) from `T6`;
130 LOCATE('龞',`C1`)
131 4
132 SELECT LOCATE('龡',`C1`) from `T6`;
133 LOCATE('龡',`C1`)
134 5
135 SELECT LOCATE('丂',`C1`) from `T6`;
136 LOCATE('丂',`C1`)
137 0
138 SELECT LOCATE('ア',`C1`) from `T7`;
139 LOCATE('ア',`C1`)
140 1
141 SELECT LOCATE('イ',`C1`) from `T7`;
142 LOCATE('イ',`C1`)
143 2
144 SELECT LOCATE('ウ',`C1`) from `T7`;
145 LOCATE('ウ',`C1`)
146 3
147 SELECT LOCATE('エ',`C1`) from `T7`;
148 LOCATE('エ',`C1`)
149 4
150 SELECT LOCATE('オ',`C1`) from `T7`;
151 LOCATE('オ',`C1`)
152 5
153 SELECT LOCATE('ン',`C1`) from `T7`;
154 LOCATE('ン',`C1`)
155 0
156 SELECT LOCATE('あ',`C1`) from `T8`;
157 LOCATE('あ',`C1`)
158 1
159 SELECT LOCATE('い',`C1`) from `T8`;
160 LOCATE('い',`C1`)
161 2
162 SELECT LOCATE('う',`C1`) from `T8`;
163 LOCATE('う',`C1`)
164 3
165 SELECT LOCATE('え',`C1`) from `T8`;
166 LOCATE('え',`C1`)
167 4
168 SELECT LOCATE('お',`C1`) from `T8`;
169 LOCATE('お',`C1`)
170 5
171 SELECT LOCATE('ん',`C1`) from `T8`;
172 LOCATE('ん',`C1`)
173 0
174 SELECT LOCATE('龔',`C1`) from `T9`;
175 LOCATE('龔',`C1`)
176 1
177 SELECT LOCATE('龖',`C1`) from `T9`;
178 LOCATE('龖',`C1`)
179 2
180 SELECT LOCATE('龗',`C1`) from `T9`;
181 LOCATE('龗',`C1`)
182 3
183 SELECT LOCATE('龞',`C1`) from `T9`;
184 LOCATE('龞',`C1`)
185 4
186 SELECT LOCATE('龡',`C1`) from `T9`;
187 LOCATE('龡',`C1`)
188 5
189 SELECT LOCATE('丂',`C1`) from `T9`;
190 LOCATE('丂',`C1`)
191 0
192 DROP TABLE `T1`;
193 DROP TABLE `T2`;
194 DROP TABLE `T3`;
195 DROP TABLE `T4`;
196 DROP TABLE `T5`;
197 DROP TABLE `T6`;
198 DROP TABLE `T7`;
199 DROP TABLE `T8`;
200 DROP TABLE `T9`;