Debian Codegraph @

mysql-test/suite/jp/r/jp_instr_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 INSTR(`C1`,'ア') from `T1`;
54 INSTR(`C1`,'ア')
55 1
56 SELECT INSTR(`C1`,'イ') from `T1`;
57 INSTR(`C1`,'イ')
58 2
59 SELECT INSTR(`C1`,'ウ') from `T1`;
60 INSTR(`C1`,'ウ')
61 3
62 SELECT INSTR(`C1`,'エ') from `T1`;
63 INSTR(`C1`,'エ')
64 4
65 SELECT INSTR(`C1`,'オ') from `T1`;
66 INSTR(`C1`,'オ')
67 5
68 SELECT INSTR(`C1`,'ン') from `T1`;
69 INSTR(`C1`,'ン')
70 0
71 SELECT INSTR(`C1`,'あ') from `T2`;
72 INSTR(`C1`,'あ')
73 1
74 SELECT INSTR(`C1`,'い') from `T2`;
75 INSTR(`C1`,'い')
76 2
77 SELECT INSTR(`C1`,'う') from `T2`;
78 INSTR(`C1`,'う')
79 3
80 SELECT INSTR(`C1`,'え') from `T2`;
81 INSTR(`C1`,'え')
82 4
83 SELECT INSTR(`C1`,'お') from `T2`;
84 INSTR(`C1`,'お')
85 5
86 SELECT INSTR(`C1`,'ん') from `T2`;
87 INSTR(`C1`,'ん')
88 0
89 SELECT INSTR(`C1`,'龔') from `T3`;
90 INSTR(`C1`,'龔')
91 1
92 SELECT INSTR(`C1`,'龖') from `T3`;
93 INSTR(`C1`,'龖')
94 2
95 SELECT INSTR(`C1`,'龗') from `T3`;
96 INSTR(`C1`,'龗')
97 3
98 SELECT INSTR(`C1`,'龞') from `T3`;
99 INSTR(`C1`,'龞')
100 4
101 SELECT INSTR(`C1`,'龡') from `T3`;
102 INSTR(`C1`,'龡')
103 5
104 SELECT INSTR(`C1`,'丂') from `T3`;
105 INSTR(`C1`,'丂')
106 0
107 SELECT INSTR(`C1`,'ア') from `T4`;
108 INSTR(`C1`,'ア')
109 1
110 SELECT INSTR(`C1`,'イ') from `T4`;
111 INSTR(`C1`,'イ')
112 2
113 SELECT INSTR(`C1`,'ウ') from `T4`;
114 INSTR(`C1`,'ウ')
115 3
116 SELECT INSTR(`C1`,'エ') from `T4`;
117 INSTR(`C1`,'エ')
118 4
119 SELECT INSTR(`C1`,'オ') from `T4`;
120 INSTR(`C1`,'オ')
121 5
122 SELECT INSTR(`C1`,'ン') from `T4`;
123 INSTR(`C1`,'ン')
124 0
125 SELECT INSTR(`C1`,'あ') from `T5`;
126 INSTR(`C1`,'あ')
127 1
128 SELECT INSTR(`C1`,'い') from `T5`;
129 INSTR(`C1`,'い')
130 2
131 SELECT INSTR(`C1`,'う') from `T5`;
132 INSTR(`C1`,'う')
133 3
134 SELECT INSTR(`C1`,'え') from `T5`;
135 INSTR(`C1`,'え')
136 4
137 SELECT INSTR(`C1`,'お') from `T5`;
138 INSTR(`C1`,'お')
139 5
140 SELECT INSTR(`C1`,'ん') from `T5`;
141 INSTR(`C1`,'ん')
142 0
143 SELECT INSTR(`C1`,'龔') from `T6`;
144 INSTR(`C1`,'龔')
145 1
146 SELECT INSTR(`C1`,'龖') from `T6`;
147 INSTR(`C1`,'龖')
148 2
149 SELECT INSTR(`C1`,'龗') from `T6`;
150 INSTR(`C1`,'龗')
151 3
152 SELECT INSTR(`C1`,'龞') from `T6`;
153 INSTR(`C1`,'龞')
154 4
155 SELECT INSTR(`C1`,'龡') from `T6`;
156 INSTR(`C1`,'龡')
157 5
158 SELECT INSTR(`C1`,'丂') from `T6`;
159 INSTR(`C1`,'丂')
160 0
161 SELECT INSTR(`C1`,'ア') from `T7`;
162 INSTR(`C1`,'ア')
163 1
164 SELECT INSTR(`C1`,'イ') from `T7`;
165 INSTR(`C1`,'イ')
166 2
167 SELECT INSTR(`C1`,'ウ') from `T7`;
168 INSTR(`C1`,'ウ')
169 3
170 SELECT INSTR(`C1`,'エ') from `T7`;
171 INSTR(`C1`,'エ')
172 4
173 SELECT INSTR(`C1`,'オ') from `T7`;
174 INSTR(`C1`,'オ')
175 5
176 SELECT INSTR(`C1`,'ン') from `T7`;
177 INSTR(`C1`,'ン')
178 0
179 SELECT INSTR(`C1`,'あ') from `T8`;
180 INSTR(`C1`,'あ')
181 1
182 SELECT INSTR(`C1`,'い') from `T8`;
183 INSTR(`C1`,'い')
184 2
185 SELECT INSTR(`C1`,'う') from `T8`;
186 INSTR(`C1`,'う')
187 3
188 SELECT INSTR(`C1`,'え') from `T8`;
189 INSTR(`C1`,'え')
190 4
191 SELECT INSTR(`C1`,'お') from `T8`;
192 INSTR(`C1`,'お')
193 5
194 SELECT INSTR(`C1`,'ん') from `T8`;
195 INSTR(`C1`,'ん')
196 0
197 SELECT INSTR(`C1`,'龔') from `T9`;
198 INSTR(`C1`,'龔')
199 1
200 SELECT INSTR(`C1`,'龖') from `T9`;
201 INSTR(`C1`,'龖')
202 2
203 SELECT INSTR(`C1`,'龗') from `T9`;
204 INSTR(`C1`,'龗')
205 3
206 SELECT INSTR(`C1`,'龞') from `T9`;
207 INSTR(`C1`,'龞')
208 4
209 SELECT INSTR(`C1`,'龡') from `T9`;
210 INSTR(`C1`,'龡')
211 5
212 SELECT INSTR(`C1`,'丂') from `T9`;
213 INSTR(`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`;