Debian Codegraph @

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