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