7
7
drop table if exists `Ｔ７`;
8
8
drop table if exists `Ｔ８`;
9
9
drop table if exists `Ｔ９`;
10
drop table if exists `Ｔ１０`;
12
SET character_set_database = utf8;
13
CREATE TABLE `Ｔ１` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
14
CREATE TABLE `Ｔ２` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
15
CREATE TABLE `Ｔ３` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
16
CREATE TABLE `Ｔ４` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
17
CREATE TABLE `Ｔ５` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
18
CREATE TABLE `Ｔ６` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
19
CREATE TABLE `Ｔ７` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20
CREATE TABLE `Ｔ８` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
21
CREATE TABLE `Ｔ９` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
22
CREATE TABLE `Ｔ１０` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
23
CREATE TABLE `Ｔ１１` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
24
CREATE TABLE `Ｔ１２` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;
10
CREATE TABLE `Ｔ１` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = innodb;
11
CREATE TABLE `Ｔ２` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = innodb;
12
CREATE TABLE `Ｔ３` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = innodb;
13
CREATE TEMPORARY TABLE `Ｔ４` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = myisam;
14
CREATE TEMPORARY TABLE `Ｔ５` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = myisam;
15
CREATE TEMPORARY TABLE `Ｔ６` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = myisam;
16
CREATE TEMPORARY TABLE `Ｔ７` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = MEMORY;
17
CREATE TEMPORARY TABLE `Ｔ８` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = MEMORY;
18
CREATE TEMPORARY TABLE `Ｔ９` (`Ｃ１` char(12), INDEX(`Ｃ１`)) engine = MEMORY;
25
19
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ');
26
20
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵｶ');
27
21
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵｶｶ');
103
97
INSERT INTO `Ｔ９` VALUES ('丂丂丂龔龖龗龞龡');
104
98
INSERT INTO `Ｔ９` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
105
99
INSERT INTO `Ｔ９` VALUES (' 龔龖龗龞龡 ');
106
INSERT INTO `Ｔ１０` VALUES ('ｱｲｳｴｵ');
107
INSERT INTO `Ｔ１０` VALUES ('ｱｲｳｴｵｶ');
108
INSERT INTO `Ｔ１０` VALUES ('ｱｲｳｴｵｶｶ');
109
INSERT INTO `Ｔ１０` VALUES ('ｱｲｳｴｵｶｶｶ');
110
INSERT INTO `Ｔ１０` VALUES ('ｶｱｲｳｴｵ');
111
INSERT INTO `Ｔ１０` VALUES ('ｶｶｱｲｳｴｵ');
112
INSERT INTO `Ｔ１０` VALUES ('ｶｶｶｱｲｳｴｵ');
113
INSERT INTO `Ｔ１０` VALUES ('ｶｶｶｱｲｳｴｵｶｶｶ');
114
INSERT INTO `Ｔ１０` VALUES (' ｱｲｳｴｵ ');
115
INSERT INTO `Ｔ１１` VALUES ('あいうえお');
116
INSERT INTO `Ｔ１１` VALUES ('あいうえおか');
117
INSERT INTO `Ｔ１１` VALUES ('あいうえおかか');
118
INSERT INTO `Ｔ１１` VALUES ('あいうえおかかか');
119
INSERT INTO `Ｔ１１` VALUES ('かあいうえお');
120
INSERT INTO `Ｔ１１` VALUES ('かかあいうえお');
121
INSERT INTO `Ｔ１１` VALUES ('かかかあいうえお');
122
INSERT INTO `Ｔ１１` VALUES ('かかかあいうえおかかか');
123
INSERT INTO `Ｔ１１` VALUES (' あいうえお ');
124
INSERT INTO `Ｔ１２` VALUES ('龔龖龗龞龡');
125
INSERT INTO `Ｔ１２` VALUES ('龔龖龗龞龡丂');
126
INSERT INTO `Ｔ１２` VALUES ('龔龖龗龞龡丂丂');
127
INSERT INTO `Ｔ１２` VALUES ('龔龖龗龞龡丂丂丂');
128
INSERT INTO `Ｔ１２` VALUES ('丂龔龖龗龞龡');
129
INSERT INTO `Ｔ１２` VALUES ('丂丂龔龖龗龞龡');
130
INSERT INTO `Ｔ１２` VALUES ('丂丂丂龔龖龗龞龡');
131
INSERT INTO `Ｔ１２` VALUES ('丂丂丂龔龖龗龞龡丂丂丂');
132
INSERT INTO `Ｔ１２` VALUES (' 龔龖龗龞龡 ');
133
100
SELECT `Ｃ１`,TRIM(TRAILING 'ｶ' FROM `Ｃ１`) FROM `Ｔ１`;
134
101
Ｃ１ TRIM(TRAILING 'ｶ' FROM `Ｃ１`)
526
493
丂丂丂龔龖龗龞龡 丂丂丂龔龖龗龞龡
527
494
丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
529
SELECT `Ｃ１`,TRIM(TRAILING 'ｶ' FROM `Ｃ１`) FROM `Ｔ１０`;
530
Ｃ１ TRIM(TRAILING 'ｶ' FROM `Ｃ１`)
540
SELECT `Ｃ１`,TRIM(LEADING 'ｶ' FROM `Ｃ１`) FROM `Ｔ１０`;
541
Ｃ１ TRIM(LEADING 'ｶ' FROM `Ｃ１`)
551
SELECT `Ｃ１`,TRIM(BOTH 'ｶ' FROM `Ｃ１`) FROM `Ｔ１０`;
552
Ｃ１ TRIM(BOTH 'ｶ' FROM `Ｃ１`)
562
SELECT `Ｃ１`,TRIM(`Ｃ１`) FROM `Ｔ１０`;
571
ｶｶｶｱｲｳｴｵｶｶｶ ｶｶｶｱｲｳｴｵｶｶｶ
573
SELECT `Ｃ１`,TRIM(TRAILING 'か' FROM `Ｃ１`) FROM `Ｔ１１`;
574
Ｃ１ TRIM(TRAILING 'か' FROM `Ｃ１`)
584
SELECT `Ｃ１`,TRIM(LEADING 'か' FROM `Ｃ１`) FROM `Ｔ１１`;
585
Ｃ１ TRIM(LEADING 'か' FROM `Ｃ１`)
595
SELECT `Ｃ１`,TRIM(BOTH 'か' FROM `Ｃ１`) FROM `Ｔ１１`;
596
Ｃ１ TRIM(BOTH 'か' FROM `Ｃ１`)
606
SELECT `Ｃ１`,TRIM(`Ｃ１`) FROM `Ｔ１１`;
615
かかかあいうえおかかか かかかあいうえおかかか
617
SELECT `Ｃ１`,TRIM(TRAILING '丂' FROM `Ｃ１`) FROM `Ｔ１２`;
618
Ｃ１ TRIM(TRAILING '丂' FROM `Ｃ１`)
628
SELECT `Ｃ１`,TRIM(LEADING '丂' FROM `Ｃ１`) FROM `Ｔ１２`;
629
Ｃ１ TRIM(LEADING '丂' FROM `Ｃ１`)
639
SELECT `Ｃ１`,TRIM(BOTH '丂' FROM `Ｃ１`) FROM `Ｔ１２`;
640
Ｃ１ TRIM(BOTH '丂' FROM `Ｃ１`)
650
SELECT `Ｃ１`,TRIM(`Ｃ１`) FROM `Ｔ１２`;
659
丂丂丂龔龖龗龞龡丂丂丂 丂丂丂龔龖龗龞龡丂丂丂
added
removed
tests/suite/jp/r/jp_trim_utf8.result
