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 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 INSTR(`C1`,'ア') from `T1`;
31 INSTR(`C1`,'ア')
32 1
33 SELECT INSTR(`C1`,'イ') from `T1`;
34 INSTR(`C1`,'イ')
35 2
36 SELECT INSTR(`C1`,'ウ') from `T1`;
37 INSTR(`C1`,'ウ')
38 3
39 SELECT INSTR(`C1`,'エ') from `T1`;
40 INSTR(`C1`,'エ')
41 4
42 SELECT INSTR(`C1`,'オ') from `T1`;
43 INSTR(`C1`,'オ')
44 5
45 SELECT INSTR(`C1`,'ン') from `T1`;
46 INSTR(`C1`,'ン')
47 0
48 SELECT INSTR(`C1`,'あ') from `T2`;
49 INSTR(`C1`,'あ')
50 1
51 SELECT INSTR(`C1`,'い') from `T2`;
52 INSTR(`C1`,'い')
53 2
54 SELECT INSTR(`C1`,'う') from `T2`;
55 INSTR(`C1`,'う')
56 3
57 SELECT INSTR(`C1`,'え') from `T2`;
58 INSTR(`C1`,'え')
59 4
60 SELECT INSTR(`C1`,'お') from `T2`;
61 INSTR(`C1`,'お')
62 5
63 SELECT INSTR(`C1`,'ん') from `T2`;
64 INSTR(`C1`,'ん')
65 0
66 SELECT INSTR(`C1`,'龔') from `T3`;
67 INSTR(`C1`,'龔')
68 1
69 SELECT INSTR(`C1`,'龖') from `T3`;
70 INSTR(`C1`,'龖')
71 2
72 SELECT INSTR(`C1`,'龗') from `T3`;
73 INSTR(`C1`,'龗')
74 3
75 SELECT INSTR(`C1`,'龞') from `T3`;
76 INSTR(`C1`,'龞')
77 4
78 SELECT INSTR(`C1`,'龡') from `T3`;
79 INSTR(`C1`,'龡')
80 5
81 SELECT INSTR(`C1`,'丂') from `T3`;
82 INSTR(`C1`,'丂')
83 0
84 SELECT INSTR(`C1`,'ア') from `T4`;
85 INSTR(`C1`,'ア')
86 1
87 SELECT INSTR(`C1`,'イ') from `T4`;
88 INSTR(`C1`,'イ')
89 2
90 SELECT INSTR(`C1`,'ウ') from `T4`;
91 INSTR(`C1`,'ウ')
92 3
93 SELECT INSTR(`C1`,'エ') from `T4`;
94 INSTR(`C1`,'エ')
95 4
96 SELECT INSTR(`C1`,'オ') from `T4`;
97 INSTR(`C1`,'オ')
98 5
99 SELECT INSTR(`C1`,'ン') from `T4`;
100 INSTR(`C1`,'ン')
101 0
102 SELECT INSTR(`C1`,'あ') from `T5`;
103 INSTR(`C1`,'あ')
104 1
105 SELECT INSTR(`C1`,'い') from `T5`;
106 INSTR(`C1`,'い')
107 2
108 SELECT INSTR(`C1`,'う') from `T5`;
109 INSTR(`C1`,'う')
110 3
111 SELECT INSTR(`C1`,'え') from `T5`;
112 INSTR(`C1`,'え')
113 4
114 SELECT INSTR(`C1`,'お') from `T5`;
115 INSTR(`C1`,'お')
116 5
117 SELECT INSTR(`C1`,'ん') from `T5`;
118 INSTR(`C1`,'ん')
119 0
120 SELECT INSTR(`C1`,'龔') from `T6`;
121 INSTR(`C1`,'龔')
122 1
123 SELECT INSTR(`C1`,'龖') from `T6`;
124 INSTR(`C1`,'龖')
125 2
126 SELECT INSTR(`C1`,'龗') from `T6`;
127 INSTR(`C1`,'龗')
128 3
129 SELECT INSTR(`C1`,'龞') from `T6`;
130 INSTR(`C1`,'龞')
131 4
132 SELECT INSTR(`C1`,'龡') from `T6`;
133 INSTR(`C1`,'龡')
134 5
135 SELECT INSTR(`C1`,'丂') from `T6`;
136 INSTR(`C1`,'丂')
137 0
138 SELECT INSTR(`C1`,'ア') from `T7`;
139 INSTR(`C1`,'ア')
140 1
141 SELECT INSTR(`C1`,'イ') from `T7`;
142 INSTR(`C1`,'イ')
143 2
144 SELECT INSTR(`C1`,'ウ') from `T7`;
145 INSTR(`C1`,'ウ')
146 3
147 SELECT INSTR(`C1`,'エ') from `T7`;
148 INSTR(`C1`,'エ')
149 4
150 SELECT INSTR(`C1`,'オ') from `T7`;
151 INSTR(`C1`,'オ')
152 5
153 SELECT INSTR(`C1`,'ン') from `T7`;
154 INSTR(`C1`,'ン')
155 0
156 SELECT INSTR(`C1`,'あ') from `T8`;
157 INSTR(`C1`,'あ')
158 1
159 SELECT INSTR(`C1`,'い') from `T8`;
160 INSTR(`C1`,'い')
161 2
162 SELECT INSTR(`C1`,'う') from `T8`;
163 INSTR(`C1`,'う')
164 3
165 SELECT INSTR(`C1`,'え') from `T8`;
166 INSTR(`C1`,'え')
167 4
168 SELECT INSTR(`C1`,'お') from `T8`;
169 INSTR(`C1`,'お')
170 5
171 SELECT INSTR(`C1`,'ん') from `T8`;
172 INSTR(`C1`,'ん')
173 0
174 SELECT INSTR(`C1`,'龔') from `T9`;
175 INSTR(`C1`,'龔')
176 1
177 SELECT INSTR(`C1`,'龖') from `T9`;
178 INSTR(`C1`,'龖')
179 2
180 SELECT INSTR(`C1`,'龗') from `T9`;
181 INSTR(`C1`,'龗')
182 3
183 SELECT INSTR(`C1`,'龞') from `T9`;
184 INSTR(`C1`,'龞')
185 4
186 SELECT INSTR(`C1`,'龡') from `T9`;
187 INSTR(`C1`,'龡')
188 5
189 SELECT INSTR(`C1`,'丂') from `T9`;
190 INSTR(`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`;