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
drop table if exists `T10`;
11
drop table if exists `T11`;
12
drop table if exists `T12`;
14
SET character_set_database = utf8;
15
CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
16
CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
17
CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18
CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
19
CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
20
CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
21
CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
22
CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
23
CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
24
CREATE TABLE `T10` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
25
CREATE TABLE `T11` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
26
CREATE TABLE `T12` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
27
INSERT INTO `T1` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
28
INSERT INTO `T2` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
29
INSERT INTO `T3` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
30
INSERT INTO `T4` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
31
INSERT INTO `T5` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
32
INSERT INTO `T6` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
33
INSERT INTO `T7` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
34
INSERT INTO `T8` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
35
INSERT INTO `T9` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
36
INSERT INTO `T10` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
37
INSERT INTO `T11` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
38
INSERT INTO `T12` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
39
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T1`;
47
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T1`;
55
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T1`;
63
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T1`;
71
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T1`;
79
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T1`;
87
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T1`;
95
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T1`;
96
C1 SUBSTRING(`C1` FROM 0)
103
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T1`;
104
C1 SUBSTRING(`C1` FROM 1)
111
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T1`;
112
C1 SUBSTRING(`C1` FROM 2)
119
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T1`;
120
C1 SUBSTRING(`C1` FROM 3)
127
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T1`;
128
C1 SUBSTRING(`C1` FROM 4)
135
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T1`;
136
C1 SUBSTRING(`C1` FROM 5)
143
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T1`;
144
C1 SUBSTRING(`C1` FROM 6)
151
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T1`;
152
C1 SUBSTRING(`C1`,1,0)
159
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T1`;
160
C1 SUBSTRING(`C1`,1,1)
167
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T1`;
168
C1 SUBSTRING(`C1`,1,2)
175
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T1`;
176
C1 SUBSTRING(`C1`,1,3)
183
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T1`;
184
C1 SUBSTRING(`C1`,1,4)
191
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T1`;
192
C1 SUBSTRING(`C1`,1,5)
199
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T1`;
200
C1 SUBSTRING(`C1`,1,6)
207
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T1`;
208
C1 SUBSTRING(`C1` FROM 1 FOR 0)
215
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T1`;
216
C1 SUBSTRING(`C1` FROM 1 FOR 1)
223
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T1`;
224
C1 SUBSTRING(`C1` FROM 1 FOR 2)
231
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T1`;
232
C1 SUBSTRING(`C1` FROM 1 FOR 3)
239
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T1`;
240
C1 SUBSTRING(`C1` FROM 1 FOR 4)
247
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T1`;
248
C1 SUBSTRING(`C1` FROM 1 FOR 5)
255
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T1`;
256
C1 SUBSTRING(`C1` FROM 1 FOR 6)
263
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T2`;
271
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T2`;
279
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T2`;
287
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T2`;
295
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T2`;
303
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T2`;
311
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T2`;
319
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T2`;
320
C1 SUBSTRING(`C1` FROM 0)
327
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T2`;
328
C1 SUBSTRING(`C1` FROM 1)
335
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T2`;
336
C1 SUBSTRING(`C1` FROM 2)
343
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T2`;
344
C1 SUBSTRING(`C1` FROM 3)
351
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T2`;
352
C1 SUBSTRING(`C1` FROM 4)
359
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T2`;
360
C1 SUBSTRING(`C1` FROM 5)
367
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T2`;
368
C1 SUBSTRING(`C1` FROM 6)
375
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T2`;
376
C1 SUBSTRING(`C1`,1,0)
383
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T2`;
384
C1 SUBSTRING(`C1`,1,1)
391
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T2`;
392
C1 SUBSTRING(`C1`,1,2)
399
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T2`;
400
C1 SUBSTRING(`C1`,1,3)
407
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T2`;
408
C1 SUBSTRING(`C1`,1,4)
415
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T2`;
416
C1 SUBSTRING(`C1`,1,5)
423
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T2`;
424
C1 SUBSTRING(`C1`,1,6)
431
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T2`;
432
C1 SUBSTRING(`C1` FROM 1 FOR 0)
439
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T2`;
440
C1 SUBSTRING(`C1` FROM 1 FOR 1)
447
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T2`;
448
C1 SUBSTRING(`C1` FROM 1 FOR 2)
455
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T2`;
456
C1 SUBSTRING(`C1` FROM 1 FOR 3)
463
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T2`;
464
C1 SUBSTRING(`C1` FROM 1 FOR 4)
471
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T2`;
472
C1 SUBSTRING(`C1` FROM 1 FOR 5)
479
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T2`;
480
C1 SUBSTRING(`C1` FROM 1 FOR 6)
487
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T3`;
495
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T3`;
503
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T3`;
511
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T3`;
519
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T3`;
527
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T3`;
535
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T3`;
543
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T3`;
544
C1 SUBSTRING(`C1` FROM 0)
551
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T3`;
552
C1 SUBSTRING(`C1` FROM 1)
559
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T3`;
560
C1 SUBSTRING(`C1` FROM 2)
567
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T3`;
568
C1 SUBSTRING(`C1` FROM 3)
575
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T3`;
576
C1 SUBSTRING(`C1` FROM 4)
583
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T3`;
584
C1 SUBSTRING(`C1` FROM 5)
591
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T3`;
592
C1 SUBSTRING(`C1` FROM 6)
599
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T3`;
600
C1 SUBSTRING(`C1`,1,0)
607
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T3`;
608
C1 SUBSTRING(`C1`,1,1)
615
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T3`;
616
C1 SUBSTRING(`C1`,1,2)
623
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T3`;
624
C1 SUBSTRING(`C1`,1,3)
631
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T3`;
632
C1 SUBSTRING(`C1`,1,4)
639
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T3`;
640
C1 SUBSTRING(`C1`,1,5)
647
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T3`;
648
C1 SUBSTRING(`C1`,1,6)
655
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T3`;
656
C1 SUBSTRING(`C1` FROM 1 FOR 0)
663
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T3`;
664
C1 SUBSTRING(`C1` FROM 1 FOR 1)
671
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T3`;
672
C1 SUBSTRING(`C1` FROM 1 FOR 2)
679
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T3`;
680
C1 SUBSTRING(`C1` FROM 1 FOR 3)
687
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T3`;
688
C1 SUBSTRING(`C1` FROM 1 FOR 4)
695
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T3`;
696
C1 SUBSTRING(`C1` FROM 1 FOR 5)
703
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T3`;
704
C1 SUBSTRING(`C1` FROM 1 FOR 6)
711
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T4`;
719
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T4`;
727
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T4`;
735
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T4`;
743
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T4`;
751
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T4`;
759
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T4`;
767
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T4`;
768
C1 SUBSTRING(`C1` FROM 0)
775
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T4`;
776
C1 SUBSTRING(`C1` FROM 1)
783
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T4`;
784
C1 SUBSTRING(`C1` FROM 2)
791
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T4`;
792
C1 SUBSTRING(`C1` FROM 3)
799
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T4`;
800
C1 SUBSTRING(`C1` FROM 4)
807
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T4`;
808
C1 SUBSTRING(`C1` FROM 5)
815
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T4`;
816
C1 SUBSTRING(`C1` FROM 6)
823
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T4`;
824
C1 SUBSTRING(`C1`,1,0)
831
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T4`;
832
C1 SUBSTRING(`C1`,1,1)
839
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T4`;
840
C1 SUBSTRING(`C1`,1,2)
847
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T4`;
848
C1 SUBSTRING(`C1`,1,3)
855
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T4`;
856
C1 SUBSTRING(`C1`,1,4)
863
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T4`;
864
C1 SUBSTRING(`C1`,1,5)
871
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T4`;
872
C1 SUBSTRING(`C1`,1,6)
879
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T4`;
880
C1 SUBSTRING(`C1` FROM 1 FOR 0)
887
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T4`;
888
C1 SUBSTRING(`C1` FROM 1 FOR 1)
895
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T4`;
896
C1 SUBSTRING(`C1` FROM 1 FOR 2)
903
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T4`;
904
C1 SUBSTRING(`C1` FROM 1 FOR 3)
911
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T4`;
912
C1 SUBSTRING(`C1` FROM 1 FOR 4)
919
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T4`;
920
C1 SUBSTRING(`C1` FROM 1 FOR 5)
927
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T4`;
928
C1 SUBSTRING(`C1` FROM 1 FOR 6)
935
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T5`;
943
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T5`;
951
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T5`;
959
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T5`;
967
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T5`;
975
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T5`;
983
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T5`;
991
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T5`;
992
C1 SUBSTRING(`C1` FROM 0)
999
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T5`;
1000
C1 SUBSTRING(`C1` FROM 1)
1007
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T5`;
1008
C1 SUBSTRING(`C1` FROM 2)
1015
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T5`;
1016
C1 SUBSTRING(`C1` FROM 3)
1023
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T5`;
1024
C1 SUBSTRING(`C1` FROM 4)
1031
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T5`;
1032
C1 SUBSTRING(`C1` FROM 5)
1039
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T5`;
1040
C1 SUBSTRING(`C1` FROM 6)
1047
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T5`;
1048
C1 SUBSTRING(`C1`,1,0)
1055
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T5`;
1056
C1 SUBSTRING(`C1`,1,1)
1063
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T5`;
1064
C1 SUBSTRING(`C1`,1,2)
1071
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T5`;
1072
C1 SUBSTRING(`C1`,1,3)
1079
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T5`;
1080
C1 SUBSTRING(`C1`,1,4)
1087
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T5`;
1088
C1 SUBSTRING(`C1`,1,5)
1095
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T5`;
1096
C1 SUBSTRING(`C1`,1,6)
1103
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T5`;
1104
C1 SUBSTRING(`C1` FROM 1 FOR 0)
1111
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T5`;
1112
C1 SUBSTRING(`C1` FROM 1 FOR 1)
1119
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T5`;
1120
C1 SUBSTRING(`C1` FROM 1 FOR 2)
1127
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T5`;
1128
C1 SUBSTRING(`C1` FROM 1 FOR 3)
1135
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T5`;
1136
C1 SUBSTRING(`C1` FROM 1 FOR 4)
1143
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T5`;
1144
C1 SUBSTRING(`C1` FROM 1 FOR 5)
1151
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T5`;
1152
C1 SUBSTRING(`C1` FROM 1 FOR 6)
1159
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T6`;
1160
C1 SUBSTRING(`C1`,0)
1167
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T6`;
1168
C1 SUBSTRING(`C1`,1)
1175
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T6`;
1176
C1 SUBSTRING(`C1`,2)
1183
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T6`;
1184
C1 SUBSTRING(`C1`,3)
1191
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T6`;
1192
C1 SUBSTRING(`C1`,4)
1199
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T6`;
1200
C1 SUBSTRING(`C1`,5)
1207
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T6`;
1208
C1 SUBSTRING(`C1`,6)
1215
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T6`;
1216
C1 SUBSTRING(`C1` FROM 0)
1223
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T6`;
1224
C1 SUBSTRING(`C1` FROM 1)
1231
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T6`;
1232
C1 SUBSTRING(`C1` FROM 2)
1239
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T6`;
1240
C1 SUBSTRING(`C1` FROM 3)
1247
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T6`;
1248
C1 SUBSTRING(`C1` FROM 4)
1255
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T6`;
1256
C1 SUBSTRING(`C1` FROM 5)
1263
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T6`;
1264
C1 SUBSTRING(`C1` FROM 6)
1271
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T6`;
1272
C1 SUBSTRING(`C1`,1,0)
1279
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T6`;
1280
C1 SUBSTRING(`C1`,1,1)
1287
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T6`;
1288
C1 SUBSTRING(`C1`,1,2)
1295
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T6`;
1296
C1 SUBSTRING(`C1`,1,3)
1303
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T6`;
1304
C1 SUBSTRING(`C1`,1,4)
1311
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T6`;
1312
C1 SUBSTRING(`C1`,1,5)
1319
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T6`;
1320
C1 SUBSTRING(`C1`,1,6)
1327
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T6`;
1328
C1 SUBSTRING(`C1` FROM 1 FOR 0)
1335
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T6`;
1336
C1 SUBSTRING(`C1` FROM 1 FOR 1)
1343
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T6`;
1344
C1 SUBSTRING(`C1` FROM 1 FOR 2)
1351
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T6`;
1352
C1 SUBSTRING(`C1` FROM 1 FOR 3)
1359
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T6`;
1360
C1 SUBSTRING(`C1` FROM 1 FOR 4)
1367
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T6`;
1368
C1 SUBSTRING(`C1` FROM 1 FOR 5)
1375
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T6`;
1376
C1 SUBSTRING(`C1` FROM 1 FOR 6)
1383
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T7`;
1384
C1 SUBSTRING(`C1`,0)
1391
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T7`;
1392
C1 SUBSTRING(`C1`,1)
1399
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T7`;
1400
C1 SUBSTRING(`C1`,2)
1407
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T7`;
1408
C1 SUBSTRING(`C1`,3)
1415
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T7`;
1416
C1 SUBSTRING(`C1`,4)
1423
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T7`;
1424
C1 SUBSTRING(`C1`,5)
1431
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T7`;
1432
C1 SUBSTRING(`C1`,6)
1439
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T7`;
1440
C1 SUBSTRING(`C1` FROM 0)
1447
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T7`;
1448
C1 SUBSTRING(`C1` FROM 1)
1455
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T7`;
1456
C1 SUBSTRING(`C1` FROM 2)
1463
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T7`;
1464
C1 SUBSTRING(`C1` FROM 3)
1471
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T7`;
1472
C1 SUBSTRING(`C1` FROM 4)
1479
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T7`;
1480
C1 SUBSTRING(`C1` FROM 5)
1487
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T7`;
1488
C1 SUBSTRING(`C1` FROM 6)
1495
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T7`;
1496
C1 SUBSTRING(`C1`,1,0)
1503
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T7`;
1504
C1 SUBSTRING(`C1`,1,1)
1511
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T7`;
1512
C1 SUBSTRING(`C1`,1,2)
1519
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T7`;
1520
C1 SUBSTRING(`C1`,1,3)
1527
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T7`;
1528
C1 SUBSTRING(`C1`,1,4)
1535
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T7`;
1536
C1 SUBSTRING(`C1`,1,5)
1543
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T7`;
1544
C1 SUBSTRING(`C1`,1,6)
1551
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T7`;
1552
C1 SUBSTRING(`C1` FROM 1 FOR 0)
1559
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T7`;
1560
C1 SUBSTRING(`C1` FROM 1 FOR 1)
1567
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T7`;
1568
C1 SUBSTRING(`C1` FROM 1 FOR 2)
1575
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T7`;
1576
C1 SUBSTRING(`C1` FROM 1 FOR 3)
1583
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T7`;
1584
C1 SUBSTRING(`C1` FROM 1 FOR 4)
1591
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T7`;
1592
C1 SUBSTRING(`C1` FROM 1 FOR 5)
1599
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T7`;
1600
C1 SUBSTRING(`C1` FROM 1 FOR 6)
1607
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T8`;
1608
C1 SUBSTRING(`C1`,0)
1615
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T8`;
1616
C1 SUBSTRING(`C1`,1)
1623
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T8`;
1624
C1 SUBSTRING(`C1`,2)
1631
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T8`;
1632
C1 SUBSTRING(`C1`,3)
1639
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T8`;
1640
C1 SUBSTRING(`C1`,4)
1647
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T8`;
1648
C1 SUBSTRING(`C1`,5)
1655
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T8`;
1656
C1 SUBSTRING(`C1`,6)
1663
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T8`;
1664
C1 SUBSTRING(`C1` FROM 0)
1671
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T8`;
1672
C1 SUBSTRING(`C1` FROM 1)
1679
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T8`;
1680
C1 SUBSTRING(`C1` FROM 2)
1687
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T8`;
1688
C1 SUBSTRING(`C1` FROM 3)
1695
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T8`;
1696
C1 SUBSTRING(`C1` FROM 4)
1703
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T8`;
1704
C1 SUBSTRING(`C1` FROM 5)
1711
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T8`;
1712
C1 SUBSTRING(`C1` FROM 6)
1719
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T8`;
1720
C1 SUBSTRING(`C1`,1,0)
1727
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T8`;
1728
C1 SUBSTRING(`C1`,1,1)
1735
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T8`;
1736
C1 SUBSTRING(`C1`,1,2)
1743
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T8`;
1744
C1 SUBSTRING(`C1`,1,3)
1751
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T8`;
1752
C1 SUBSTRING(`C1`,1,4)
1759
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T8`;
1760
C1 SUBSTRING(`C1`,1,5)
1767
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T8`;
1768
C1 SUBSTRING(`C1`,1,6)
1775
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T8`;
1776
C1 SUBSTRING(`C1` FROM 1 FOR 0)
1783
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T8`;
1784
C1 SUBSTRING(`C1` FROM 1 FOR 1)
1791
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T8`;
1792
C1 SUBSTRING(`C1` FROM 1 FOR 2)
1799
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T8`;
1800
C1 SUBSTRING(`C1` FROM 1 FOR 3)
1807
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T8`;
1808
C1 SUBSTRING(`C1` FROM 1 FOR 4)
1815
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T8`;
1816
C1 SUBSTRING(`C1` FROM 1 FOR 5)
1823
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T8`;
1824
C1 SUBSTRING(`C1` FROM 1 FOR 6)
1831
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T9`;
1832
C1 SUBSTRING(`C1`,0)
1839
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T9`;
1840
C1 SUBSTRING(`C1`,1)
1847
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T9`;
1848
C1 SUBSTRING(`C1`,2)
1855
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T9`;
1856
C1 SUBSTRING(`C1`,3)
1863
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T9`;
1864
C1 SUBSTRING(`C1`,4)
1871
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T9`;
1872
C1 SUBSTRING(`C1`,5)
1879
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T9`;
1880
C1 SUBSTRING(`C1`,6)
1887
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T9`;
1888
C1 SUBSTRING(`C1` FROM 0)
1895
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T9`;
1896
C1 SUBSTRING(`C1` FROM 1)
1903
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T9`;
1904
C1 SUBSTRING(`C1` FROM 2)
1911
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T9`;
1912
C1 SUBSTRING(`C1` FROM 3)
1919
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T9`;
1920
C1 SUBSTRING(`C1` FROM 4)
1927
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T9`;
1928
C1 SUBSTRING(`C1` FROM 5)
1935
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T9`;
1936
C1 SUBSTRING(`C1` FROM 6)
1943
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T9`;
1944
C1 SUBSTRING(`C1`,1,0)
1951
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T9`;
1952
C1 SUBSTRING(`C1`,1,1)
1959
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T9`;
1960
C1 SUBSTRING(`C1`,1,2)
1967
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T9`;
1968
C1 SUBSTRING(`C1`,1,3)
1975
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T9`;
1976
C1 SUBSTRING(`C1`,1,4)
1983
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T9`;
1984
C1 SUBSTRING(`C1`,1,5)
1991
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T9`;
1992
C1 SUBSTRING(`C1`,1,6)
1999
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T9`;
2000
C1 SUBSTRING(`C1` FROM 1 FOR 0)
2007
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T9`;
2008
C1 SUBSTRING(`C1` FROM 1 FOR 1)
2015
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T9`;
2016
C1 SUBSTRING(`C1` FROM 1 FOR 2)
2023
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T9`;
2024
C1 SUBSTRING(`C1` FROM 1 FOR 3)
2031
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T9`;
2032
C1 SUBSTRING(`C1` FROM 1 FOR 4)
2039
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T9`;
2040
C1 SUBSTRING(`C1` FROM 1 FOR 5)
2047
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T9`;
2048
C1 SUBSTRING(`C1` FROM 1 FOR 6)
2055
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T10`;
2056
C1 SUBSTRING(`C1`,0)
2063
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T10`;
2064
C1 SUBSTRING(`C1`,1)
2071
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T10`;
2072
C1 SUBSTRING(`C1`,2)
2079
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T10`;
2080
C1 SUBSTRING(`C1`,3)
2087
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T10`;
2088
C1 SUBSTRING(`C1`,4)
2095
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T10`;
2096
C1 SUBSTRING(`C1`,5)
2103
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T10`;
2104
C1 SUBSTRING(`C1`,6)
2111
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T10`;
2112
C1 SUBSTRING(`C1` FROM 0)
2119
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T10`;
2120
C1 SUBSTRING(`C1` FROM 1)
2127
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T10`;
2128
C1 SUBSTRING(`C1` FROM 2)
2135
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T10`;
2136
C1 SUBSTRING(`C1` FROM 3)
2143
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T10`;
2144
C1 SUBSTRING(`C1` FROM 4)
2151
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T10`;
2152
C1 SUBSTRING(`C1` FROM 5)
2159
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T10`;
2160
C1 SUBSTRING(`C1` FROM 6)
2167
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T10`;
2168
C1 SUBSTRING(`C1`,1,0)
2175
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T10`;
2176
C1 SUBSTRING(`C1`,1,1)
2183
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T10`;
2184
C1 SUBSTRING(`C1`,1,2)
2191
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T10`;
2192
C1 SUBSTRING(`C1`,1,3)
2199
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T10`;
2200
C1 SUBSTRING(`C1`,1,4)
2207
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T10`;
2208
C1 SUBSTRING(`C1`,1,5)
2215
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T10`;
2216
C1 SUBSTRING(`C1`,1,6)
2223
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T10`;
2224
C1 SUBSTRING(`C1` FROM 1 FOR 0)
2231
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T10`;
2232
C1 SUBSTRING(`C1` FROM 1 FOR 1)
2239
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T10`;
2240
C1 SUBSTRING(`C1` FROM 1 FOR 2)
2247
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T10`;
2248
C1 SUBSTRING(`C1` FROM 1 FOR 3)
2255
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T10`;
2256
C1 SUBSTRING(`C1` FROM 1 FOR 4)
2263
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T10`;
2264
C1 SUBSTRING(`C1` FROM 1 FOR 5)
2271
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T10`;
2272
C1 SUBSTRING(`C1` FROM 1 FOR 6)
2279
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T11`;
2280
C1 SUBSTRING(`C1`,0)
2287
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T11`;
2288
C1 SUBSTRING(`C1`,1)
2295
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T11`;
2296
C1 SUBSTRING(`C1`,2)
2303
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T11`;
2304
C1 SUBSTRING(`C1`,3)
2311
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T11`;
2312
C1 SUBSTRING(`C1`,4)
2319
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T11`;
2320
C1 SUBSTRING(`C1`,5)
2327
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T11`;
2328
C1 SUBSTRING(`C1`,6)
2335
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T11`;
2336
C1 SUBSTRING(`C1` FROM 0)
2343
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T11`;
2344
C1 SUBSTRING(`C1` FROM 1)
2351
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T11`;
2352
C1 SUBSTRING(`C1` FROM 2)
2359
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T11`;
2360
C1 SUBSTRING(`C1` FROM 3)
2367
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T11`;
2368
C1 SUBSTRING(`C1` FROM 4)
2375
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T11`;
2376
C1 SUBSTRING(`C1` FROM 5)
2383
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T11`;
2384
C1 SUBSTRING(`C1` FROM 6)
2391
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T11`;
2392
C1 SUBSTRING(`C1`,1,0)
2399
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T11`;
2400
C1 SUBSTRING(`C1`,1,1)
2407
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T11`;
2408
C1 SUBSTRING(`C1`,1,2)
2415
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T11`;
2416
C1 SUBSTRING(`C1`,1,3)
2423
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T11`;
2424
C1 SUBSTRING(`C1`,1,4)
2431
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T11`;
2432
C1 SUBSTRING(`C1`,1,5)
2439
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T11`;
2440
C1 SUBSTRING(`C1`,1,6)
2447
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T11`;
2448
C1 SUBSTRING(`C1` FROM 1 FOR 0)
2455
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T11`;
2456
C1 SUBSTRING(`C1` FROM 1 FOR 1)
2463
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T11`;
2464
C1 SUBSTRING(`C1` FROM 1 FOR 2)
2471
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T11`;
2472
C1 SUBSTRING(`C1` FROM 1 FOR 3)
2479
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T11`;
2480
C1 SUBSTRING(`C1` FROM 1 FOR 4)
2487
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T11`;
2488
C1 SUBSTRING(`C1` FROM 1 FOR 5)
2495
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T11`;
2496
C1 SUBSTRING(`C1` FROM 1 FOR 6)
2503
SELECT `C1`, SUBSTRING(`C1`,0) FROM `T12`;
2504
C1 SUBSTRING(`C1`,0)
2511
SELECT `C1`, SUBSTRING(`C1`,1) FROM `T12`;
2512
C1 SUBSTRING(`C1`,1)
2519
SELECT `C1`, SUBSTRING(`C1`,2) FROM `T12`;
2520
C1 SUBSTRING(`C1`,2)
2527
SELECT `C1`, SUBSTRING(`C1`,3) FROM `T12`;
2528
C1 SUBSTRING(`C1`,3)
2535
SELECT `C1`, SUBSTRING(`C1`,4) FROM `T12`;
2536
C1 SUBSTRING(`C1`,4)
2543
SELECT `C1`, SUBSTRING(`C1`,5) FROM `T12`;
2544
C1 SUBSTRING(`C1`,5)
2551
SELECT `C1`, SUBSTRING(`C1`,6) FROM `T12`;
2552
C1 SUBSTRING(`C1`,6)
2559
SELECT `C1`, SUBSTRING(`C1` FROM 0) FROM `T12`;
2560
C1 SUBSTRING(`C1` FROM 0)
2567
SELECT `C1`, SUBSTRING(`C1` FROM 1) FROM `T12`;
2568
C1 SUBSTRING(`C1` FROM 1)
2575
SELECT `C1`, SUBSTRING(`C1` FROM 2) FROM `T12`;
2576
C1 SUBSTRING(`C1` FROM 2)
2583
SELECT `C1`, SUBSTRING(`C1` FROM 3) FROM `T12`;
2584
C1 SUBSTRING(`C1` FROM 3)
2591
SELECT `C1`, SUBSTRING(`C1` FROM 4) FROM `T12`;
2592
C1 SUBSTRING(`C1` FROM 4)
2599
SELECT `C1`, SUBSTRING(`C1` FROM 5) FROM `T12`;
2600
C1 SUBSTRING(`C1` FROM 5)
2607
SELECT `C1`, SUBSTRING(`C1` FROM 6) FROM `T12`;
2608
C1 SUBSTRING(`C1` FROM 6)
2615
SELECT `C1`, SUBSTRING(`C1`,1,0) FROM `T12`;
2616
C1 SUBSTRING(`C1`,1,0)
2623
SELECT `C1`, SUBSTRING(`C1`,1,1) FROM `T12`;
2624
C1 SUBSTRING(`C1`,1,1)
2631
SELECT `C1`, SUBSTRING(`C1`,1,2) FROM `T12`;
2632
C1 SUBSTRING(`C1`,1,2)
2639
SELECT `C1`, SUBSTRING(`C1`,1,3) FROM `T12`;
2640
C1 SUBSTRING(`C1`,1,3)
2647
SELECT `C1`, SUBSTRING(`C1`,1,4) FROM `T12`;
2648
C1 SUBSTRING(`C1`,1,4)
2655
SELECT `C1`, SUBSTRING(`C1`,1,5) FROM `T12`;
2656
C1 SUBSTRING(`C1`,1,5)
2663
SELECT `C1`, SUBSTRING(`C1`,1,6) FROM `T12`;
2664
C1 SUBSTRING(`C1`,1,6)
2671
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 0) FROM `T12`;
2672
C1 SUBSTRING(`C1` FROM 1 FOR 0)
2679
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 1) FROM `T12`;
2680
C1 SUBSTRING(`C1` FROM 1 FOR 1)
2687
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 2) FROM `T12`;
2688
C1 SUBSTRING(`C1` FROM 1 FOR 2)
2695
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 3) FROM `T12`;
2696
C1 SUBSTRING(`C1` FROM 1 FOR 3)
2703
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 4) FROM `T12`;
2704
C1 SUBSTRING(`C1` FROM 1 FOR 4)
2711
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 5) FROM `T12`;
2712
C1 SUBSTRING(`C1` FROM 1 FOR 5)
2719
SELECT `C1`, SUBSTRING(`C1` FROM 1 FOR 6) FROM `T12`;
2720
C1 SUBSTRING(`C1` FROM 1 FOR 6)