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`;
11 SET character_set_database = utf8;
12 CREATE TABLE `T1` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T2` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T3` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T4` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
16 CREATE TABLE `T5` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T6` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T7` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
19 CREATE TABLE `T8` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T9` (`C1` char(12), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
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 `T1` VALUES ('カカカアイウエオカカカ');
29 INSERT INTO `T1` 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 `T2` VALUES ('かかかあいうえおかかか');
38 INSERT INTO `T2` 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 `T3` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
47 INSERT INTO `T3` 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 `T4` VALUES ('カカカアイウエオカカカ');
56 INSERT INTO `T4` 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 `T5` VALUES ('かかかあいうえおかかか');
65 INSERT INTO `T5` 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 `T6` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
74 INSERT INTO `T6` 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 `T7` VALUES ('カカカアイウエオカカカ');
83 INSERT INTO `T7` 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 `T8` VALUES ('かかかあいうえおかかか');
92 INSERT INTO `T8` 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 INSERT INTO `T9` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
101 INSERT INTO `T9` VALUES (' 龔龖龗龞龡 ');
102 SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T1`;
103 C1 TRIM(TRAILING 'カ' FROM `C1`)
113 SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T1`;
114 C1 TRIM(LEADING 'カ' FROM `C1`)
124 SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T1`;
125 C1 TRIM(BOTH 'カ' FROM `C1`)
135 SELECT `C1`,TRIM(`C1`) FROM `T1`;
145 カカカアイウエオカカカ カカカアイウエオカカカ
146 SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T2`;
147 C1 TRIM(TRAILING 'か' FROM `C1`)
157 SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T2`;
158 C1 TRIM(LEADING 'か' FROM `C1`)
168 SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T2`;
169 C1 TRIM(BOTH 'か' FROM `C1`)
179 SELECT `C1`,TRIM(`C1`) FROM `T2`;
189 かかかあいうえおかかか かかかあいうえおかかか
190 SELECT `C1`,TRIM(TRAILING '丂'FROM `C1`) FROM `T3`;
191 C1 TRIM(TRAILING '丂'FROM `C1`)
201 SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T3`;
202 C1 TRIM(LEADING '丂' FROM `C1`)
212 SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T3`;
213 C1 TRIM(BOTH '丂' FROM `C1`)
223 SELECT `C1`,TRIM(`C1`) FROM `T3`;
227 丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
234 SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T4`;
235 C1 TRIM(TRAILING 'カ' FROM `C1`)
245 SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T4`;
246 C1 TRIM(LEADING 'カ' FROM `C1`)
256 SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T4`;
257 C1 TRIM(BOTH 'カ' FROM `C1`)
267 SELECT `C1`,TRIM(`C1`) FROM `T4`;
277 カカカアイウエオカカカ カカカアイウエオカカカ
278 SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T5`;
279 C1 TRIM(TRAILING 'か' FROM `C1`)
289 SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T5`;
290 C1 TRIM(LEADING 'か' FROM `C1`)
300 SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T5`;
301 C1 TRIM(BOTH 'か' FROM `C1`)
311 SELECT `C1`,TRIM(`C1`) FROM `T5`;
321 かかかあいうえおかかか かかかあいうえおかかか
322 SELECT `C1`,TRIM(TRAILING '丂' FROM `C1`) FROM `T6`;
323 C1 TRIM(TRAILING '丂' FROM `C1`)
333 SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T6`;
334 C1 TRIM(LEADING '丂' FROM `C1`)
344 SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T6`;
345 C1 TRIM(BOTH '丂' FROM `C1`)
355 SELECT `C1`,TRIM(`C1`) FROM `T6`;
359 丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
366 SELECT `C1`,TRIM(TRAILING 'カ' FROM `C1`) FROM `T7`;
367 C1 TRIM(TRAILING 'カ' FROM `C1`)
377 SELECT `C1`,TRIM(LEADING 'カ' FROM `C1`) FROM `T7`;
378 C1 TRIM(LEADING 'カ' FROM `C1`)
388 SELECT `C1`,TRIM(BOTH 'カ' FROM `C1`) FROM `T7`;
389 C1 TRIM(BOTH 'カ' FROM `C1`)
399 SELECT `C1`,TRIM(`C1`) FROM `T7`;
408 カカカアイウエオカカカ カカカアイウエオカカカ
410 SELECT `C1`,TRIM(TRAILING 'か' FROM `C1`) FROM `T8`;
411 C1 TRIM(TRAILING 'か' FROM `C1`)
421 SELECT `C1`,TRIM(LEADING 'か' FROM `C1`) FROM `T8`;
422 C1 TRIM(LEADING 'か' FROM `C1`)
432 SELECT `C1`,TRIM(BOTH 'か' FROM `C1`) FROM `T8`;
433 C1 TRIM(BOTH 'か' FROM `C1`)
443 SELECT `C1`,TRIM(`C1`) FROM `T8`;
452 かかかあいうえおかかか かかかあいうえおかかか
454 SELECT `C1`,TRIM(TRAILING '丂' FROM `C1`) FROM `T9`;
455 C1 TRIM(TRAILING '丂' FROM `C1`)
465 SELECT `C1`,TRIM(LEADING '丂' FROM `C1`) FROM `T9`;
466 C1 TRIM(LEADING '丂' FROM `C1`)
476 SELECT `C1`,TRIM(BOTH '丂' FROM `C1`) FROM `T9`;
477 C1 TRIM(BOTH '丂' FROM `C1`)
487 SELECT `C1`,TRIM(`C1`) FROM `T9`;
496 丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂