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 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 SET character_set_database = utf8;
14 Warnings:
15 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
35 CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
44 INSERT INTO `T1` VALUES ('アイウエオ');
45 INSERT INTO `T2` VALUES ('あいうえお');
46 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
47 INSERT INTO `T4` VALUES ('アイウエオ');
48 INSERT INTO `T5` VALUES ('あいうえお');
49 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
50 INSERT INTO `T7` VALUES ('アイウエオ');
51 INSERT INTO `T8` VALUES ('あいうえお');
52 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
53 SELECT LOCATE('ア',`C1`) from `T1`;
54 LOCATE('ア',`C1`)
55 1
56 SELECT LOCATE('イ',`C1`) from `T1`;
57 LOCATE('イ',`C1`)
58 2
59 SELECT LOCATE('ウ',`C1`) from `T1`;
60 LOCATE('ウ',`C1`)
61 3
62 SELECT LOCATE('エ',`C1`) from `T1`;
63 LOCATE('エ',`C1`)
64 4
65 SELECT LOCATE('オ',`C1`) from `T1`;
66 LOCATE('オ',`C1`)
67 5
68 SELECT LOCATE('ン',`C1`) from `T1`;
69 LOCATE('ン',`C1`)
70 0
71 SELECT LOCATE('あ',`C1`) from `T2`;
72 LOCATE('あ',`C1`)
73 1
74 SELECT LOCATE('い',`C1`) from `T2`;
75 LOCATE('い',`C1`)
76 2
77 SELECT LOCATE('う',`C1`) from `T2`;
78 LOCATE('う',`C1`)
79 3
80 SELECT LOCATE('え',`C1`) from `T2`;
81 LOCATE('え',`C1`)
82 4
83 SELECT LOCATE('お',`C1`) from `T2`;
84 LOCATE('お',`C1`)
85 5
86 SELECT LOCATE('ん',`C1`) from `T2`;
87 LOCATE('ん',`C1`)
88 0
89 SELECT LOCATE('龔',`C1`) from `T3`;
90 LOCATE('龔',`C1`)
91 1
92 SELECT LOCATE('龖',`C1`) from `T3`;
93 LOCATE('龖',`C1`)
94 2
95 SELECT LOCATE('龗',`C1`) from `T3`;
96 LOCATE('龗',`C1`)
97 3
98 SELECT LOCATE('龞',`C1`) from `T3`;
99 LOCATE('龞',`C1`)
100 4
101 SELECT LOCATE('龡',`C1`) from `T3`;
102 LOCATE('龡',`C1`)
103 5
104 SELECT LOCATE('丂',`C1`) from `T3`;
105 LOCATE('丂',`C1`)
106 0
107 SELECT LOCATE('ア',`C1`) from `T4`;
108 LOCATE('ア',`C1`)
109 1
110 SELECT LOCATE('イ',`C1`) from `T4`;
111 LOCATE('イ',`C1`)
112 2
113 SELECT LOCATE('ウ',`C1`) from `T4`;
114 LOCATE('ウ',`C1`)
115 3
116 SELECT LOCATE('エ',`C1`) from `T4`;
117 LOCATE('エ',`C1`)
118 4
119 SELECT LOCATE('オ',`C1`) from `T4`;
120 LOCATE('オ',`C1`)
121 5
122 SELECT LOCATE('ン',`C1`) from `T4`;
123 LOCATE('ン',`C1`)
124 0
125 SELECT LOCATE('あ',`C1`) from `T5`;
126 LOCATE('あ',`C1`)
127 1
128 SELECT LOCATE('い',`C1`) from `T5`;
129 LOCATE('い',`C1`)
130 2
131 SELECT LOCATE('う',`C1`) from `T5`;
132 LOCATE('う',`C1`)
133 3
134 SELECT LOCATE('え',`C1`) from `T5`;
135 LOCATE('え',`C1`)
136 4
137 SELECT LOCATE('お',`C1`) from `T5`;
138 LOCATE('お',`C1`)
139 5
140 SELECT LOCATE('ん',`C1`) from `T5`;
141 LOCATE('ん',`C1`)
142 0
143 SELECT LOCATE('龔',`C1`) from `T6`;
144 LOCATE('龔',`C1`)
145 1
146 SELECT LOCATE('龖',`C1`) from `T6`;
147 LOCATE('龖',`C1`)
148 2
149 SELECT LOCATE('龗',`C1`) from `T6`;
150 LOCATE('龗',`C1`)
151 3
152 SELECT LOCATE('龞',`C1`) from `T6`;
153 LOCATE('龞',`C1`)
154 4
155 SELECT LOCATE('龡',`C1`) from `T6`;
156 LOCATE('龡',`C1`)
157 5
158 SELECT LOCATE('丂',`C1`) from `T6`;
159 LOCATE('丂',`C1`)
160 0
161 SELECT LOCATE('ア',`C1`) from `T7`;
162 LOCATE('ア',`C1`)
163 1
164 SELECT LOCATE('イ',`C1`) from `T7`;
165 LOCATE('イ',`C1`)
166 2
167 SELECT LOCATE('ウ',`C1`) from `T7`;
168 LOCATE('ウ',`C1`)
169 3
170 SELECT LOCATE('エ',`C1`) from `T7`;
171 LOCATE('エ',`C1`)
172 4
173 SELECT LOCATE('オ',`C1`) from `T7`;
174 LOCATE('オ',`C1`)
175 5
176 SELECT LOCATE('ン',`C1`) from `T7`;
177 LOCATE('ン',`C1`)
178 0
179 SELECT LOCATE('あ',`C1`) from `T8`;
180 LOCATE('あ',`C1`)
181 1
182 SELECT LOCATE('い',`C1`) from `T8`;
183 LOCATE('い',`C1`)
184 2
185 SELECT LOCATE('う',`C1`) from `T8`;
186 LOCATE('う',`C1`)
187 3
188 SELECT LOCATE('え',`C1`) from `T8`;
189 LOCATE('え',`C1`)
190 4
191 SELECT LOCATE('お',`C1`) from `T8`;
192 LOCATE('お',`C1`)
193 5
194 SELECT LOCATE('ん',`C1`) from `T8`;
195 LOCATE('ん',`C1`)
196 0
197 SELECT LOCATE('龔',`C1`) from `T9`;
198 LOCATE('龔',`C1`)
199 1
200 SELECT LOCATE('龖',`C1`) from `T9`;
201 LOCATE('龖',`C1`)
202 2
203 SELECT LOCATE('龗',`C1`) from `T9`;
204 LOCATE('龗',`C1`)
205 3
206 SELECT LOCATE('龞',`C1`) from `T9`;
207 LOCATE('龞',`C1`)
208 4
209 SELECT LOCATE('龡',`C1`) from `T9`;
210 LOCATE('龡',`C1`)
211 5
212 SELECT LOCATE('丂',`C1`) from `T9`;
213 LOCATE('丂',`C1`)
214 0
215 DROP TABLE `T1`;
216 DROP TABLE `T2`;
217 DROP TABLE `T3`;
218 DROP TABLE `T4`;
219 DROP TABLE `T5`;
220 DROP TABLE `T6`;
221 DROP TABLE `T7`;
222 DROP TABLE `T8`;
223 DROP TABLE `T9`;