1
--source include/have_utf8.inc
2
--source include/have_innodb.inc
4
drop table if exists `T1`;
5
drop table if exists `T2`;
6
drop table if exists `T3`;
7
drop table if exists `T4`;
8
drop table if exists `T5`;
9
drop table if exists `T6`;
10
drop table if exists `T7`;
11
drop table if exists `T8`;
12
drop table if exists `T9`;
16
# Test INSERT() function with Japanese characters in utf8 encoding
20
SET character_set_database = utf8;
22
CREATE TABLE `T1` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
23
CREATE TABLE `T2` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
24
CREATE TABLE `T3` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
25
CREATE TABLE `T4` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
26
CREATE TABLE `T5` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
27
CREATE TABLE `T6` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
28
CREATE TABLE `T7` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
29
CREATE TABLE `T8` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
30
CREATE TABLE `T9` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
32
INSERT INTO `T1` VALUES ('アイウエオ');
33
INSERT INTO `T2` VALUES ('あいうえお');
34
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
35
INSERT INTO `T4` VALUES ('アイウエオ');
36
INSERT INTO `T5` VALUES ('あいうえお');
37
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
38
INSERT INTO `T7` VALUES ('アイウエオ');
39
INSERT INTO `T8` VALUES ('あいうえお');
40
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
43
SELECT INSERT(`C1`,1,1,'カ') FROM `T1`;
44
SELECT INSERT(`C1`,1,2,'カカ') FROM `T1`;
45
SELECT INSERT(`C1`,1,3,'カカカ') FROM `T1`;
46
SELECT INSERT(`C1`,1,4,'カカカカ') FROM `T1`;
47
SELECT INSERT(`C1`,1,5,'カカカカカ') FROM `T1`;
48
SELECT INSERT(`C1`,2,1,'カ') FROM `T1`;
49
SELECT INSERT(`C1`,2,2,'カカ') FROM `T1`;
50
SELECT INSERT(`C1`,2,3,'カカカ') FROM `T1`;
51
SELECT INSERT(`C1`,2,4,'カカカカ') FROM `T1`;
52
SELECT INSERT(`C1`,3,1,'カ') FROM `T1`;
53
SELECT INSERT(`C1`,3,2,'カカ') FROM `T1`;
54
SELECT INSERT(`C1`,3,3,'カカカ') FROM `T1`;
55
SELECT INSERT(`C1`,4,1,'カ') FROM `T1`;
56
SELECT INSERT(`C1`,4,2,'カカ') FROM `T1`;
57
SELECT INSERT(`C1`,5,1,'カ') FROM `T1`;
58
SELECT INSERT(`C1`,1,1,' ') FROM `T1`;
59
SELECT INSERT(`C1`,1,2,' ') FROM `T1`;
60
SELECT INSERT(`C1`,1,3,' ') FROM `T1`;
61
SELECT INSERT(`C1`,1,4,' ') FROM `T1`;
62
SELECT INSERT(`C1`,1,5,' ') FROM `T1`;
63
SELECT INSERT(`C1`,2,1,' ') FROM `T1`;
64
SELECT INSERT(`C1`,2,2,' ') FROM `T1`;
65
SELECT INSERT(`C1`,2,3,' ') FROM `T1`;
66
SELECT INSERT(`C1`,2,4,' ') FROM `T1`;
67
SELECT INSERT(`C1`,3,1,' ') FROM `T1`;
68
SELECT INSERT(`C1`,3,2,' ') FROM `T1`;
69
SELECT INSERT(`C1`,3,3,' ') FROM `T1`;
70
SELECT INSERT(`C1`,4,1,' ') FROM `T1`;
71
SELECT INSERT(`C1`,4,2,' ') FROM `T1`;
72
SELECT INSERT(`C1`,5,1,' ') FROM `T1`;
73
SELECT INSERT(`C1`,1,1,'か') FROM `T2`;
74
SELECT INSERT(`C1`,1,2,'かか') FROM `T2`;
75
SELECT INSERT(`C1`,1,3,'かかか') FROM `T2`;
76
SELECT INSERT(`C1`,1,4,'かかかか') FROM `T2`;
77
SELECT INSERT(`C1`,1,5,'かかかかか') FROM `T2`;
78
SELECT INSERT(`C1`,2,1,'か') FROM `T2`;
79
SELECT INSERT(`C1`,2,2,'かか') FROM `T2`;
80
SELECT INSERT(`C1`,2,3,'かかか') FROM `T2`;
81
SELECT INSERT(`C1`,2,4,'かかかか') FROM `T2`;
82
SELECT INSERT(`C1`,3,1,'か') FROM `T2`;
83
SELECT INSERT(`C1`,3,2,'かか') FROM `T2`;
84
SELECT INSERT(`C1`,3,3,'かかか') FROM `T2`;
85
SELECT INSERT(`C1`,4,1,'か') FROM `T2`;
86
SELECT INSERT(`C1`,4,2,'かか') FROM `T2`;
87
SELECT INSERT(`C1`,5,1,'か') FROM `T2`;
88
SELECT INSERT(`C1`,1,1,' ') FROM `T2`;
89
SELECT INSERT(`C1`,1,2,' ') FROM `T2`;
90
SELECT INSERT(`C1`,1,3,' ') FROM `T2`;
91
SELECT INSERT(`C1`,1,4,' ') FROM `T2`;
92
SELECT INSERT(`C1`,1,5,' ') FROM `T2`;
93
SELECT INSERT(`C1`,2,1,' ') FROM `T2`;
94
SELECT INSERT(`C1`,2,2,' ') FROM `T2`;
95
SELECT INSERT(`C1`,2,3,' ') FROM `T2`;
96
SELECT INSERT(`C1`,2,4,' ') FROM `T2`;
97
SELECT INSERT(`C1`,3,1,' ') FROM `T2`;
98
SELECT INSERT(`C1`,3,2,' ') FROM `T2`;
99
SELECT INSERT(`C1`,3,3,' ') FROM `T2`;
100
SELECT INSERT(`C1`,4,1,' ') FROM `T2`;
101
SELECT INSERT(`C1`,4,2,' ') FROM `T2`;
102
SELECT INSERT(`C1`,5,1,' ') FROM `T2`;
103
SELECT INSERT(`C1`,1,1,'丂') FROM `T3`;
104
SELECT INSERT(`C1`,1,2,'丂丂' ) FROM `T3`;
105
SELECT INSERT(`C1`,1,3,'丂丂丂' ) FROM `T3`;
106
SELECT INSERT(`C1`,1,4,'丂丂丂丂' ) FROM `T3`;
107
SELECT INSERT(`C1`,1,5,'丂丂丂丂丂' ) FROM `T3`;
108
SELECT INSERT(`C1`,2,1,'丂') FROM `T3`;
109
SELECT INSERT(`C1`,2,2,'丂丂' ) FROM `T3`;
110
SELECT INSERT(`C1`,2,3,'丂丂丂' ) FROM `T3`;
111
SELECT INSERT(`C1`,2,4,'丂丂丂丂' ) FROM `T3`;
112
SELECT INSERT(`C1`,3,1,'丂') FROM `T3`;
113
SELECT INSERT(`C1`,3,2,'丂丂' ) FROM `T3`;
114
SELECT INSERT(`C1`,3,3,'丂丂丂' ) FROM `T3`;
115
SELECT INSERT(`C1`,4,1,'丂') FROM `T3`;
116
SELECT INSERT(`C1`,4,2,'丂丂' ) FROM `T3`;
117
SELECT INSERT(`C1`,5,1,'丂') FROM `T3`;
120
SELECT INSERT(`C1`,1,1,'カ') FROM `T4`;
121
SELECT INSERT(`C1`,1,2,'カカ') FROM `T4`;
122
SELECT INSERT(`C1`,1,3,'カカカ') FROM `T4`;
123
SELECT INSERT(`C1`,1,4,'カカカカ') FROM `T4`;
124
SELECT INSERT(`C1`,1,5,'カカカカカ') FROM `T4`;
125
SELECT INSERT(`C1`,2,1,'カ') FROM `T4`;
126
SELECT INSERT(`C1`,2,2,'カカ') FROM `T4`;
127
SELECT INSERT(`C1`,2,3,'カカカ') FROM `T4`;
128
SELECT INSERT(`C1`,2,4,'カカカカ') FROM `T4`;
129
SELECT INSERT(`C1`,3,1,'カ') FROM `T4`;
130
SELECT INSERT(`C1`,3,2,'カカ') FROM `T4`;
131
SELECT INSERT(`C1`,3,3,'カカカ') FROM `T4`;
132
SELECT INSERT(`C1`,4,1,'カ') FROM `T4`;
133
SELECT INSERT(`C1`,4,2,'カカ') FROM `T4`;
134
SELECT INSERT(`C1`,5,1,'カ') FROM `T4`;
135
SELECT INSERT(`C1`,1,1,' ') FROM `T4`;
136
SELECT INSERT(`C1`,1,2,' ') FROM `T4`;
137
SELECT INSERT(`C1`,1,3,' ') FROM `T4`;
138
SELECT INSERT(`C1`,1,4,' ') FROM `T4`;
139
SELECT INSERT(`C1`,1,5,' ') FROM `T4`;
140
SELECT INSERT(`C1`,2,1,' ') FROM `T4`;
141
SELECT INSERT(`C1`,2,2,' ') FROM `T4`;
142
SELECT INSERT(`C1`,2,3,' ') FROM `T4`;
143
SELECT INSERT(`C1`,2,4,' ') FROM `T4`;
144
SELECT INSERT(`C1`,3,1,' ') FROM `T4`;
145
SELECT INSERT(`C1`,3,2,' ') FROM `T4`;
146
SELECT INSERT(`C1`,3,3,' ') FROM `T4`;
147
SELECT INSERT(`C1`,4,1,' ') FROM `T4`;
148
SELECT INSERT(`C1`,4,2,' ') FROM `T4`;
149
SELECT INSERT(`C1`,5,1,' ') FROM `T4`;
150
SELECT INSERT(`C1`,1,1,'か') FROM `T5`;
151
SELECT INSERT(`C1`,1,2,'かか') FROM `T5`;
152
SELECT INSERT(`C1`,1,3,'かかか') FROM `T5`;
153
SELECT INSERT(`C1`,1,4,'かかかか') FROM `T5`;
154
SELECT INSERT(`C1`,1,5,'かかかかか') FROM `T5`;
155
SELECT INSERT(`C1`,2,1,'か') FROM `T5`;
156
SELECT INSERT(`C1`,2,2,'かか') FROM `T5`;
157
SELECT INSERT(`C1`,2,3,'かかか') FROM `T5`;
158
SELECT INSERT(`C1`,2,4,'かかかか') FROM `T5`;
159
SELECT INSERT(`C1`,3,1,'か') FROM `T5`;
160
SELECT INSERT(`C1`,3,2,'かか') FROM `T5`;
161
SELECT INSERT(`C1`,3,3,'かかか') FROM `T5`;
162
SELECT INSERT(`C1`,4,1,'か') FROM `T5`;
163
SELECT INSERT(`C1`,4,2,'かか') FROM `T5`;
164
SELECT INSERT(`C1`,5,1,'か') FROM `T5`;
165
SELECT INSERT(`C1`,1,1,' ') FROM `T5`;
166
SELECT INSERT(`C1`,1,2,' ') FROM `T5`;
167
SELECT INSERT(`C1`,1,3,' ') FROM `T5`;
168
SELECT INSERT(`C1`,1,4,' ') FROM `T5`;
169
SELECT INSERT(`C1`,1,5,' ') FROM `T5`;
170
SELECT INSERT(`C1`,2,1,' ') FROM `T5`;
171
SELECT INSERT(`C1`,2,2,' ') FROM `T5`;
172
SELECT INSERT(`C1`,2,3,' ') FROM `T5`;
173
SELECT INSERT(`C1`,2,4,' ') FROM `T5`;
174
SELECT INSERT(`C1`,3,1,' ') FROM `T5`;
175
SELECT INSERT(`C1`,3,2,' ') FROM `T5`;
176
SELECT INSERT(`C1`,3,3,' ') FROM `T5`;
177
SELECT INSERT(`C1`,4,1,' ') FROM `T5`;
178
SELECT INSERT(`C1`,4,2,' ') FROM `T5`;
179
SELECT INSERT(`C1`,5,1,' ') FROM `T5`;
180
SELECT INSERT(`C1`,1,1,'丂') FROM `T6`;
181
SELECT INSERT(`C1`,1,2,'丂丂' ) FROM `T6`;
182
SELECT INSERT(`C1`,1,3,'丂丂丂' ) FROM `T6`;
183
SELECT INSERT(`C1`,1,4,'丂丂丂丂' ) FROM `T6`;
184
SELECT INSERT(`C1`,1,5,'丂丂丂丂丂' ) FROM `T6`;
185
SELECT INSERT(`C1`,2,1,'丂') FROM `T6`;
186
SELECT INSERT(`C1`,2,2,'丂丂') FROM `T6`;
187
SELECT INSERT(`C1`,2,3,'丂丂丂' ) FROM `T6`;
188
SELECT INSERT(`C1`,2,4,'丂丂丂丂' ) FROM `T6`;
189
SELECT INSERT(`C1`,3,1,'丂') FROM `T6`;
190
SELECT INSERT(`C1`,3,2,'丂丂' ) FROM `T6`;
191
SELECT INSERT(`C1`,3,3,'丂丂丂' ) FROM `T6`;
192
SELECT INSERT(`C1`,4,1,'丂') FROM `T6`;
193
SELECT INSERT(`C1`,4,2,'丂丂' ) FROM `T6`;
194
SELECT INSERT(`C1`,5,1,'丂') FROM `T6`;
197
SELECT INSERT(`C1`,1,1,'カ') FROM `T7`;
198
SELECT INSERT(`C1`,1,2,'カカ') FROM `T7`;
199
SELECT INSERT(`C1`,1,3,'カカカ') FROM `T7`;
200
SELECT INSERT(`C1`,1,4,'カカカカ') FROM `T7`;
201
SELECT INSERT(`C1`,1,5,'カカカカカ') FROM `T7`;
202
SELECT INSERT(`C1`,2,1,'カ') FROM `T7`;
203
SELECT INSERT(`C1`,2,2,'カカ') FROM `T7`;
204
SELECT INSERT(`C1`,2,3,'カカカ') FROM `T7`;
205
SELECT INSERT(`C1`,2,4,'カカカカ') FROM `T7`;
206
SELECT INSERT(`C1`,3,1,'カ') FROM `T7`;
207
SELECT INSERT(`C1`,3,2,'カカ') FROM `T7`;
208
SELECT INSERT(`C1`,3,3,'カカカ') FROM `T7`;
209
SELECT INSERT(`C1`,4,1,'カ') FROM `T7`;
210
SELECT INSERT(`C1`,4,2,'カカ') FROM `T7`;
211
SELECT INSERT(`C1`,5,1,'カ') FROM `T7`;
212
SELECT INSERT(`C1`,1,1,' ') FROM `T7`;
213
SELECT INSERT(`C1`,1,2,' ') FROM `T7`;
214
SELECT INSERT(`C1`,1,3,' ') FROM `T7`;
215
SELECT INSERT(`C1`,1,4,' ') FROM `T7`;
216
SELECT INSERT(`C1`,1,5,' ') FROM `T7`;
217
SELECT INSERT(`C1`,2,1,' ') FROM `T7`;
218
SELECT INSERT(`C1`,2,2,' ') FROM `T7`;
219
SELECT INSERT(`C1`,2,3,' ') FROM `T7`;
220
SELECT INSERT(`C1`,2,4,' ') FROM `T7`;
221
SELECT INSERT(`C1`,3,1,' ') FROM `T7`;
222
SELECT INSERT(`C1`,3,2,' ') FROM `T7`;
223
SELECT INSERT(`C1`,3,3,' ') FROM `T7`;
224
SELECT INSERT(`C1`,4,1,' ') FROM `T7`;
225
SELECT INSERT(`C1`,4,2,' ') FROM `T7`;
226
SELECT INSERT(`C1`,5,1,' ') FROM `T7`;
227
SELECT INSERT(`C1`,1,1,'か') FROM `T8`;
228
SELECT INSERT(`C1`,1,2,'かか') FROM `T8`;
229
SELECT INSERT(`C1`,1,3,'かかか') FROM `T8`;
230
SELECT INSERT(`C1`,1,4,'かかかか') FROM `T8`;
231
SELECT INSERT(`C1`,1,5,'かかかかか') FROM `T8`;
232
SELECT INSERT(`C1`,2,1,'か') FROM `T8`;
233
SELECT INSERT(`C1`,2,2,'かか') FROM `T8`;
234
SELECT INSERT(`C1`,2,3,'かかか') FROM `T8`;
235
SELECT INSERT(`C1`,2,4,'かかかか') FROM `T8`;
236
SELECT INSERT(`C1`,3,1,'か') FROM `T8`;
237
SELECT INSERT(`C1`,3,2,'かか') FROM `T8`;
238
SELECT INSERT(`C1`,3,3,'かかか') FROM `T8`;
239
SELECT INSERT(`C1`,4,1,'か') FROM `T8`;
240
SELECT INSERT(`C1`,4,2,'かか') FROM `T8`;
241
SELECT INSERT(`C1`,5,1,'か') FROM `T8`;
242
SELECT INSERT(`C1`,1,1,' ') FROM `T8`;
243
SELECT INSERT(`C1`,1,2,' ') FROM `T8`;
244
SELECT INSERT(`C1`,1,3,' ') FROM `T8`;
245
SELECT INSERT(`C1`,1,4,' ') FROM `T8`;
246
SELECT INSERT(`C1`,1,5,' ') FROM `T8`;
247
SELECT INSERT(`C1`,2,1,' ') FROM `T8`;
248
SELECT INSERT(`C1`,2,2,' ') FROM `T8`;
249
SELECT INSERT(`C1`,2,3,' ') FROM `T8`;
250
SELECT INSERT(`C1`,2,4,' ') FROM `T8`;
251
SELECT INSERT(`C1`,3,1,' ') FROM `T8`;
252
SELECT INSERT(`C1`,3,2,' ') FROM `T8`;
253
SELECT INSERT(`C1`,3,3,' ') FROM `T8`;
254
SELECT INSERT(`C1`,4,1,' ') FROM `T8`;
255
SELECT INSERT(`C1`,4,2,' ') FROM `T8`;
256
SELECT INSERT(`C1`,5,1,' ') FROM `T8`;
257
SELECT INSERT(`C1`,1,1,'丂') FROM `T9`;
258
SELECT INSERT(`C1`,1,2,'丂丂' ) FROM `T9`;
259
SELECT INSERT(`C1`,1,3,'丂丂丂' ) FROM `T9`;
260
SELECT INSERT(`C1`,1,4,'丂丂丂丂' ) FROM `T9`;
261
SELECT INSERT(`C1`,1,5,'丂丂丂丂丂' ) FROM `T9`;
262
SELECT INSERT(`C1`,2,1,'丂') FROM `T9`;
263
SELECT INSERT(`C1`,2,2,'丂丂' ) FROM `T9`;
264
SELECT INSERT(`C1`,2,3,'丂丂丂' ) FROM `T9`;
265
SELECT INSERT(`C1`,2,4,'丂丂丂丂' ) FROM `T9`;
266
SELECT INSERT(`C1`,3,1,'丂') FROM `T9`;
267
SELECT INSERT(`C1`,3,2,'丂丂' ) FROM `T9`;
268
SELECT INSERT(`C1`,3,3,'丂丂丂' ) FROM `T9`;
269
SELECT INSERT(`C1`,4,1,'丂') FROM `T9`;
270
SELECT INSERT(`C1`,4,2,'丂丂' ) FROM `T9`;
271
SELECT INSERT(`C1`,5,1,'丂') FROM `T9`;