24
25
CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
25
26
CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
26
27
CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27
CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
28
CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
29
CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
30
CREATE TABLE `T10` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
31
CREATE TABLE `T11` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
32
CREATE TABLE `T12` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
28
CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
29
CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
30
CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
34
32
INSERT INTO `T1` VALUES ('アイウエオ');
35
33
INSERT INTO `T1` VALUES (' アイウエオ');
103
101
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
104
102
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
105
103
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
106
INSERT INTO `T10` VALUES ('アイウエオ');
107
INSERT INTO `T10` VALUES (' アイウエオ');
108
INSERT INTO `T10` VALUES (' アイウエオ');
109
INSERT INTO `T10` VALUES (' アイウエオ');
110
# Double byte spaces are not supposed to be trimed
111
INSERT INTO `T10` VALUES (' アイウエオ');
112
INSERT INTO `T10` VALUES (' アイウエオ');
113
INSERT INTO `T10` VALUES (' アイウエオ');
114
INSERT INTO `T11` VALUES ('あいうえお');
115
INSERT INTO `T11` VALUES (' あいうえお');
116
INSERT INTO `T11` VALUES (' あいうえお');
117
INSERT INTO `T11` VALUES (' あいうえお');
118
# Double byte spaces are not supposed to be trimed
119
INSERT INTO `T11` VALUES (' あいうえお');
120
INSERT INTO `T11` VALUES (' あいうえお');
121
INSERT INTO `T11` VALUES (' あいうえお');
122
INSERT INTO `T12` VALUES ('龔龖龗龞龡');
123
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
124
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
125
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
126
# Double byte spaces are not supposed to be trimed
127
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
128
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
129
INSERT INTO `T12` VALUES (' 龔龖龗龞龡');
132
106
SELECT LTRIM(`C1`) from `T1`;
138
112
SELECT LTRIM(`C1`) from `T5`;
139
113
SELECT LTRIM(`C1`) from `T6`;
142
116
SELECT LTRIM(`C1`) from `T7`;
143
117
SELECT LTRIM(`C1`) from `T8`;
144
118
SELECT LTRIM(`C1`) from `T9`;
147
SELECT LTRIM(`C1`) from `T10`;
148
SELECT LTRIM(`C1`) from `T11`;
149
SELECT LTRIM(`C1`) from `T12`;