3
drop table if exists `�s�P`;
4
drop table if exists `�s�Q`;
5
drop table if exists `�s�R`;
6
drop table if exists `�s�S`;
7
drop table if exists `�s�T`;
8
drop table if exists `�s�U`;
9
drop table if exists `�s�V`;
10
drop table if exists `�s�W`;
11
drop table if exists `�s�X`;
12
drop table if exists `�s�P�O`;
13
drop table if exists `�s�P�P`;
14
drop table if exists `�s�P�Q`;
18
# Test SUBSTRING() function with Japanese character in sjis encoding
22
SET character_set_database = sjis;
24
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
27
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
30
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
31
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
32
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
33
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
34
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
35
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
37
INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
38
INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
39
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
40
INSERT INTO `�s�S` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
41
INSERT INTO `�s�T` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
42
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
43
INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
44
INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
45
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
46
INSERT INTO `�s�P�O` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
47
INSERT INTO `�s�P�P` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
48
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
51
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�P`;
52
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�P`;
53
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�P`;
54
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�P`;
55
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�P`;
56
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�P`;
57
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�P`;
58
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�P`;
59
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�P`;
60
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�P`;
61
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�P`;
62
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�P`;
63
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�P`;
64
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�P`;
65
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�P`;
66
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�P`;
67
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�P`;
68
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�P`;
69
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�P`;
70
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�P`;
71
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�P`;
72
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�P`;
73
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�P`;
74
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�P`;
75
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�P`;
76
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�P`;
77
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�P`;
78
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�P`;
80
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�Q`;
81
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�Q`;
82
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�Q`;
83
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�Q`;
84
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�Q`;
85
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�Q`;
86
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�Q`;
87
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�Q`;
88
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�Q`;
89
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�Q`;
90
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�Q`;
91
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�Q`;
92
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�Q`;
93
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�Q`;
94
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�Q`;
95
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�Q`;
96
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�Q`;
97
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�Q`;
98
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�Q`;
99
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�Q`;
100
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�Q`;
101
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�Q`;
102
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�Q`;
103
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�Q`;
104
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�Q`;
105
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�Q`;
106
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�Q`;
107
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�Q`;
109
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�R`;
110
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�R`;
111
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�R`;
112
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�R`;
113
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�R`;
114
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�R`;
115
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�R`;
116
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�R`;
117
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�R`;
118
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�R`;
119
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�R`;
120
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�R`;
121
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�R`;
122
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�R`;
123
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�R`;
124
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�R`;
125
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�R`;
126
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�R`;
127
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�R`;
128
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�R`;
129
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�R`;
130
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�R`;
131
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�R`;
132
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�R`;
133
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�R`;
134
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�R`;
135
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�R`;
136
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�R`;
139
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�S`;
140
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�S`;
141
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�S`;
142
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�S`;
143
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�S`;
144
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�S`;
145
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�S`;
146
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�S`;
147
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�S`;
148
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�S`;
149
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�S`;
150
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�S`;
151
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�S`;
152
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�S`;
153
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�S`;
154
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�S`;
155
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�S`;
156
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�S`;
157
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�S`;
158
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�S`;
159
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�S`;
160
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�S`;
161
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�S`;
162
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�S`;
163
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�S`;
164
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�S`;
165
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�S`;
166
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�S`;
168
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�T`;
169
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�T`;
170
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�T`;
171
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�T`;
172
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�T`;
173
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�T`;
174
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�T`;
175
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�T`;
176
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�T`;
177
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�T`;
178
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�T`;
179
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�T`;
180
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�T`;
181
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�T`;
182
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�T`;
183
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�T`;
184
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�T`;
185
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�T`;
186
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�T`;
187
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�T`;
188
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�T`;
189
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�T`;
190
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�T`;
191
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�T`;
192
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�T`;
193
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�T`;
194
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�T`;
195
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�T`;
197
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�U`;
198
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�U`;
199
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�U`;
200
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�U`;
201
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�U`;
202
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�U`;
203
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�U`;
204
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�U`;
205
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�U`;
206
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�U`;
207
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�U`;
208
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�U`;
209
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�U`;
210
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�U`;
211
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�U`;
212
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�U`;
213
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�U`;
214
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�U`;
215
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�U`;
216
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�U`;
217
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�U`;
218
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�U`;
219
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�U`;
220
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�U`;
221
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�U`;
222
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�U`;
223
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�U`;
224
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�U`;
227
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�V`;
228
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�V`;
229
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�V`;
230
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�V`;
231
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�V`;
232
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�V`;
233
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�V`;
234
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�V`;
235
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�V`;
236
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�V`;
237
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�V`;
238
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�V`;
239
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�V`;
240
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�V`;
241
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�V`;
242
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�V`;
243
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�V`;
244
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�V`;
245
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�V`;
246
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�V`;
247
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�V`;
248
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�V`;
249
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�V`;
250
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�V`;
251
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�V`;
252
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�V`;
253
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�V`;
254
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�V`;
256
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�W`;
257
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�W`;
258
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�W`;
259
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�W`;
260
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�W`;
261
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�W`;
262
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�W`;
263
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�W`;
264
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�W`;
265
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�W`;
266
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�W`;
267
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�W`;
268
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�W`;
269
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�W`;
270
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�W`;
271
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�W`;
272
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�W`;
273
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�W`;
274
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�W`;
275
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�W`;
276
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�W`;
277
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�W`;
278
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�W`;
279
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�W`;
280
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�W`;
281
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�W`;
282
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�W`;
283
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�W`;
285
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�X`;
286
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�X`;
287
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�X`;
288
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�X`;
289
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�X`;
290
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�X`;
291
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�X`;
292
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�X`;
293
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�X`;
294
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�X`;
295
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�X`;
296
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�X`;
297
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�X`;
298
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�X`;
299
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�X`;
300
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�X`;
301
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�X`;
302
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�X`;
303
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�X`;
304
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�X`;
305
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�X`;
306
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�X`;
307
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�X`;
308
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�X`;
309
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�X`;
310
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�X`;
311
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�X`;
312
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�X`;
315
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�P�O`;
316
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�P�O`;
317
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�P�O`;
318
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�P�O`;
319
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�P�O`;
320
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�P�O`;
321
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�P�O`;
322
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�P�O`;
323
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�P�O`;
324
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�P�O`;
325
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�P�O`;
326
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�P�O`;
327
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�P�O`;
328
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�P�O`;
329
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�P�O`;
330
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�P�O`;
331
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�P�O`;
332
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�P�O`;
333
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�P�O`;
334
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�P�O`;
335
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�P�O`;
336
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�P�O`;
337
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�P�O`;
338
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�P�O`;
339
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�P�O`;
340
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�P�O`;
341
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�P�O`;
342
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�P�O`;
344
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�P�P`;
345
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�P�P`;
346
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�P�P`;
347
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�P�P`;
348
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�P�P`;
349
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�P�P`;
350
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�P�P`;
351
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�P�P`;
352
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�P�P`;
353
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�P�P`;
354
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�P�P`;
355
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�P�P`;
356
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�P�P`;
357
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�P�P`;
358
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�P�P`;
359
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�P�P`;
360
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�P�P`;
361
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�P�P`;
362
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�P�P`;
363
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�P�P`;
364
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�P�P`;
365
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�P�P`;
366
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�P�P`;
367
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�P�P`;
368
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�P�P`;
369
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�P�P`;
370
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�P�P`;
371
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�P�P`;
373
SELECT `�b�P`, SUBSTRING(`�b�P`,0) FROM `�s�P�Q`;
374
SELECT `�b�P`, SUBSTRING(`�b�P`,1) FROM `�s�P�Q`;
375
SELECT `�b�P`, SUBSTRING(`�b�P`,2) FROM `�s�P�Q`;
376
SELECT `�b�P`, SUBSTRING(`�b�P`,3) FROM `�s�P�Q`;
377
SELECT `�b�P`, SUBSTRING(`�b�P`,4) FROM `�s�P�Q`;
378
SELECT `�b�P`, SUBSTRING(`�b�P`,5) FROM `�s�P�Q`;
379
SELECT `�b�P`, SUBSTRING(`�b�P`,6) FROM `�s�P�Q`;
380
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 0) FROM `�s�P�Q`;
381
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1) FROM `�s�P�Q`;
382
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 2) FROM `�s�P�Q`;
383
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 3) FROM `�s�P�Q`;
384
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 4) FROM `�s�P�Q`;
385
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 5) FROM `�s�P�Q`;
386
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 6) FROM `�s�P�Q`;
387
SELECT `�b�P`, SUBSTRING(`�b�P`,1,0) FROM `�s�P�Q`;
388
SELECT `�b�P`, SUBSTRING(`�b�P`,1,1) FROM `�s�P�Q`;
389
SELECT `�b�P`, SUBSTRING(`�b�P`,1,2) FROM `�s�P�Q`;
390
SELECT `�b�P`, SUBSTRING(`�b�P`,1,3) FROM `�s�P�Q`;
391
SELECT `�b�P`, SUBSTRING(`�b�P`,1,4) FROM `�s�P�Q`;
392
SELECT `�b�P`, SUBSTRING(`�b�P`,1,5) FROM `�s�P�Q`;
393
SELECT `�b�P`, SUBSTRING(`�b�P`,1,6) FROM `�s�P�Q`;
394
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 0) FROM `�s�P�Q`;
395
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 1) FROM `�s�P�Q`;
396
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 2) FROM `�s�P�Q`;
397
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 3) FROM `�s�P�Q`;
398
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 4) FROM `�s�P�Q`;
399
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 5) FROM `�s�P�Q`;
400
SELECT `�b�P`, SUBSTRING(`�b�P` FROM 1 FOR 6) FROM `�s�P�Q`;