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
CREATE TABLE `T1` (`C1` char(12), INDEX(`C1`)) engine = innodb;
11
CREATE TABLE `T2` (`C1` char(12), INDEX(`C1`)) engine = innodb;
12
CREATE TABLE `T3` (`C1` char(12), INDEX(`C1`)) engine = innodb;
13
CREATE TEMPORARY TABLE `T4` (`C1` char(12), INDEX(`C1`)) engine = myisam;
14
CREATE TEMPORARY TABLE `T5` (`C1` char(12), INDEX(`C1`)) engine = myisam;
15
CREATE TEMPORARY TABLE `T6` (`C1` char(12), INDEX(`C1`)) engine = myisam;
16
CREATE TEMPORARY TABLE `T7` (`C1` char(12), INDEX(`C1`)) engine = MEMORY;
17
CREATE TEMPORARY TABLE `T8` (`C1` char(12), INDEX(`C1`)) engine = MEMORY;
18
CREATE TEMPORARY TABLE `T9` (`C1` char(12), INDEX(`C1`)) engine = MEMORY;
19
INSERT INTO `T1` VALUES ('アイウエオ');
20
INSERT INTO `T1` VALUES ('アイウエオカ');
21
INSERT INTO `T1` VALUES ('アイウエオカカ');
22
INSERT INTO `T1` VALUES ('アイウエオカカカ');
23
INSERT INTO `T1` VALUES ('カアイウエオ');
24
INSERT INTO `T1` VALUES ('カカアイウエオ');
25
INSERT INTO `T1` VALUES ('カカカアイウエオ');
26
INSERT INTO `T1` VALUES ('カカカアイウエオカカカ');
27
INSERT INTO `T1` VALUES (' アイウエオ ');
28
INSERT INTO `T2` VALUES ('あいうえお');
29
INSERT INTO `T2` VALUES ('あいうえおか');
30
INSERT INTO `T2` VALUES ('あいうえおかか');
31
INSERT INTO `T2` VALUES ('あいうえおかかか');
32
INSERT INTO `T2` VALUES ('かあいうえお');
33
INSERT INTO `T2` VALUES ('かかあいうえお');
34
INSERT INTO `T2` VALUES ('かかかあいうえお');
35
INSERT INTO `T2` VALUES ('かかかあいうえおかかか');
36
INSERT INTO `T2` VALUES (' あいうえお ');
37
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
38
INSERT INTO `T3` VALUES ('龔龖龗龞龡丂');
39
INSERT INTO `T3` VALUES ('龔龖龗龞龡丂丂');
40
INSERT INTO `T3` VALUES ('龔龖龗龞龡丂丂丂');
41
INSERT INTO `T3` VALUES ('丂龔龖龗龞龡');
42
INSERT INTO `T3` VALUES ('丂丂龔龖龗龞龡');
43
INSERT INTO `T3` VALUES ('丂丂丂龔龖龗龞龡');
44
INSERT INTO `T3` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
45
INSERT INTO `T3` VALUES (' 龔龖龗龞龡 ');
46
INSERT INTO `T4` VALUES ('アイウエオ');
47
INSERT INTO `T4` VALUES ('アイウエオカ');
48
INSERT INTO `T4` VALUES ('アイウエオカカ');
49
INSERT INTO `T4` VALUES ('アイウエオカカカ');
50
INSERT INTO `T4` VALUES ('カアイウエオ');
51
INSERT INTO `T4` VALUES ('カカアイウエオ');
52
INSERT INTO `T4` VALUES ('カカカアイウエオ');
53
INSERT INTO `T4` VALUES ('カカカアイウエオカカカ');
54
INSERT INTO `T4` VALUES (' アイウエオ ');
55
INSERT INTO `T5` VALUES ('あいうえお');
56
INSERT INTO `T5` VALUES ('あいうえおか');
57
INSERT INTO `T5` VALUES ('あいうえおかか');
58
INSERT INTO `T5` VALUES ('あいうえおかかか');
59
INSERT INTO `T5` VALUES ('かあいうえお');
60
INSERT INTO `T5` VALUES ('かかあいうえお');
61
INSERT INTO `T5` VALUES ('かかかあいうえお');
62
INSERT INTO `T5` VALUES ('かかかあいうえおかかか');
63
INSERT INTO `T5` VALUES (' あいうえお ');
64
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
65
INSERT INTO `T6` VALUES ('龔龖龗龞龡丂');
66
INSERT INTO `T6` VALUES ('龔龖龗龞龡丂丂');
67
INSERT INTO `T6` VALUES ('龔龖龗龞龡丂丂丂');
68
INSERT INTO `T6` VALUES ('丂龔龖龗龞龡');
69
INSERT INTO `T6` VALUES ('丂丂龔龖龗龞龡');
70
INSERT INTO `T6` VALUES ('丂丂丂龔龖龗龞龡');
71
INSERT INTO `T6` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
72
INSERT INTO `T6` VALUES (' 龔龖龗龞龡 ');
73
INSERT INTO `T7` VALUES ('アイウエオ');
74
INSERT INTO `T7` VALUES ('アイウエオカ');
75
INSERT INTO `T7` VALUES ('アイウエオカカ');
76
INSERT INTO `T7` VALUES ('アイウエオカカカ');
77
INSERT INTO `T7` VALUES ('カアイウエオ');
78
INSERT INTO `T7` VALUES ('カカアイウエオ');
79
INSERT INTO `T7` VALUES ('カカカアイウエオ');
80
INSERT INTO `T7` VALUES ('カカカアイウエオカカカ');
81
INSERT INTO `T7` VALUES (' アイウエオ ');
82
INSERT INTO `T8` VALUES ('あいうえお');
83
INSERT INTO `T8` VALUES ('あいうえおか');
84
INSERT INTO `T8` VALUES ('あいうえおかか');
85
INSERT INTO `T8` VALUES ('あいうえおかかか');
86
INSERT INTO `T8` VALUES ('かあいうえお');
87
INSERT INTO `T8` VALUES ('かかあいうえお');
88
INSERT INTO `T8` VALUES ('かかかあいうえお');
89
INSERT INTO `T8` VALUES ('かかかあいうえおかかか');
90
INSERT INTO `T8` VALUES (' あいうえお ');
91
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
92
INSERT INTO `T9` VALUES ('龔龖龗龞龡丂');
93
INSERT INTO `T9` VALUES ('龔龖龗龞龡丂丂');
94
INSERT INTO `T9` VALUES ('龔龖龗龞龡丂丂丂');
95
INSERT INTO `T9` VALUES ('丂龔龖龗龞龡');
96
INSERT INTO `T9` VALUES ('丂丂龔龖龗龞龡');
97
INSERT INTO `T9` VALUES ('丂丂丂龔龖龗龞龡');
98
INSERT INTO `T9` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
99
INSERT INTO `T9` VALUES (' 龔龖龗龞龡 ');
100
SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T1`;
101
C1 TRIM(TRAILING 'カ' FROM `C1`)
111
SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T1`;
112
C1 TRIM(LEADING 'カ' FROM `C1`)
122
SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T1`;
123
C1 TRIM(BOTH 'カ' FROM `C1`)
133
SELECT `C1`,TRIM(`C1`) FROM `T1`;
143
カカカアイウエオカカカ カカカアイウエオカカカ
144
SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T2`;
145
C1 TRIM(TRAILING 'か' FROM `C1`)
155
SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T2`;
156
C1 TRIM(LEADING 'か' FROM `C1`)
166
SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T2`;
167
C1 TRIM(BOTH 'か' FROM `C1`)
177
SELECT `C1`,TRIM(`C1`) FROM `T2`;
187
かかかあいうえおかかか かかかあいうえおかかか
188
SELECT `C1`,TRIM(TRAILING '丂'FROM `C1`) FROM `T3`;
189
C1 TRIM(TRAILING '丂'FROM `C1`)
199
SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T3`;
200
C1 TRIM(LEADING '丂' FROM `C1`)
210
SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T3`;
211
C1 TRIM(BOTH '丂' FROM `C1`)
221
SELECT `C1`,TRIM(`C1`) FROM `T3`;
225
丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
232
SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T4`;
233
C1 TRIM(TRAILING 'カ' FROM `C1`)
243
SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T4`;
244
C1 TRIM(LEADING 'カ' FROM `C1`)
254
SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T4`;
255
C1 TRIM(BOTH 'カ' FROM `C1`)
265
SELECT `C1`,TRIM(`C1`) FROM `T4`;
275
カカカアイウエオカカカ カカカアイウエオカカカ
276
SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T5`;
277
C1 TRIM(TRAILING 'か' FROM `C1`)
287
SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T5`;
288
C1 TRIM(LEADING 'か' FROM `C1`)
298
SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T5`;
299
C1 TRIM(BOTH 'か' FROM `C1`)
309
SELECT `C1`,TRIM(`C1`) FROM `T5`;
319
かかかあいうえおかかか かかかあいうえおかかか
320
SELECT `C1`,TRIM(TRAILING '丂' FROM `C1`) FROM `T6`;
321
C1 TRIM(TRAILING '丂' FROM `C1`)
331
SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T6`;
332
C1 TRIM(LEADING '丂' FROM `C1`)
342
SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T6`;
343
C1 TRIM(BOTH '丂' FROM `C1`)
353
SELECT `C1`,TRIM(`C1`) FROM `T6`;
357
丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
364
SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T7`;
365
C1 TRIM(TRAILING 'カ' FROM `C1`)
375
SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T7`;
376
C1 TRIM(LEADING 'カ' FROM `C1`)
386
SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T7`;
387
C1 TRIM(BOTH 'カ' FROM `C1`)
397
SELECT `C1`,TRIM(`C1`) FROM `T7`;
406
カカカアイウエオカカカ カカカアイウエオカカカ
408
SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T8`;
409
C1 TRIM(TRAILING 'か' FROM `C1`)
419
SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T8`;
420
C1 TRIM(LEADING 'か' FROM `C1`)
430
SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T8`;
431
C1 TRIM(BOTH 'か' FROM `C1`)
441
SELECT `C1`,TRIM(`C1`) FROM `T8`;
450
かかかあいうえおかかか かかかあいうえおかかか
452
SELECT `C1`,TRIM(TRAILING '丂' FROM `C1`) FROM `T9`;
453
C1 TRIM(TRAILING '丂' FROM `C1`)
463
SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T9`;
464
C1 TRIM(LEADING '丂' FROM `C1`)
474
SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T9`;
475
C1 TRIM(BOTH '丂' FROM `C1`)
485
SELECT `C1`,TRIM(`C1`) FROM `T9`;
494
丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂