1
--source include/have_utf8.inc
2
--source include/have_innodb.inc
4
drop table if exists `T1`;
5
drop table if exists `T2`;
6
drop table if exists `T3`;
7
drop table if exists `T4`;
8
drop table if exists `T5`;
9
drop table if exists `T6`;
10
drop table if exists `T7`;
11
drop table if exists `T8`;
12
drop table if exists `T9`;
16
# Test LTRIM() function with Japanese characters in utf8 encoding
20
SET character_set_database = utf8;
22
CREATE TABLE `T1` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
23
CREATE TABLE `T2` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24
CREATE TABLE `T3` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
25
CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
26
CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27
CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
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;
32
INSERT INTO `T1` VALUES ('アイウエオ');
33
INSERT INTO `T1` VALUES (' アイウエオ');
34
INSERT INTO `T1` VALUES (' アイウエオ');
35
INSERT INTO `T1` VALUES (' アイウエオ');
36
# Double byte spaces are not supposed to be trimed
37
INSERT INTO `T1` VALUES (' アイウエオ');
38
INSERT INTO `T1` VALUES (' アイウエオ');
39
INSERT INTO `T1` VALUES (' アイウエオ');
40
INSERT INTO `T2` VALUES ('あいうえお');
41
INSERT INTO `T2` VALUES (' あいうえお');
42
INSERT INTO `T2` VALUES (' あいうえお');
43
INSERT INTO `T2` VALUES (' あいうえお');
44
# Double byte spaces are not supposed to be trimed
45
INSERT INTO `T2` VALUES (' あいうえお');
46
INSERT INTO `T2` VALUES (' あいうえお');
47
INSERT INTO `T2` VALUES (' あいうえお');
48
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
49
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
50
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
51
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
52
# Double byte spaces are not supposed to be trimed
53
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
54
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
55
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
56
INSERT INTO `T4` VALUES ('アイウエオ');
57
INSERT INTO `T4` VALUES (' アイウエオ');
58
INSERT INTO `T4` VALUES (' アイウエオ');
59
INSERT INTO `T4` VALUES (' アイウエオ');
60
# Double byte spaces are not supposed to be trimed
61
INSERT INTO `T4` VALUES (' アイウエオ');
62
INSERT INTO `T4` VALUES (' アイウエオ');
63
INSERT INTO `T4` VALUES (' アイウエオ');
64
INSERT INTO `T5` VALUES ('あいうえお');
65
INSERT INTO `T5` VALUES (' あいうえお');
66
INSERT INTO `T5` VALUES (' あいうえお');
67
INSERT INTO `T5` VALUES (' あいうえお');
68
# Double byte spaces are not supposed to be trimed
69
INSERT INTO `T5` VALUES (' あいうえお');
70
INSERT INTO `T5` VALUES (' あいうえお');
71
INSERT INTO `T5` VALUES (' あいうえお');
72
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
73
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
74
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
75
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
76
# Double byte spaces are not supposed to be trimed
77
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
78
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
79
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
80
INSERT INTO `T7` VALUES ('アイウエオ');
81
INSERT INTO `T7` VALUES (' アイウエオ');
82
INSERT INTO `T7` VALUES (' アイウエオ');
83
INSERT INTO `T7` VALUES (' アイウエオ');
84
# Double byte spaces are not supposed to be trimed
85
INSERT INTO `T7` VALUES (' アイウエオ');
86
INSERT INTO `T7` VALUES (' アイウエオ');
87
INSERT INTO `T7` VALUES (' アイウエオ');
88
INSERT INTO `T8` VALUES ('あいうえお');
89
INSERT INTO `T8` VALUES (' あいうえお');
90
INSERT INTO `T8` VALUES (' あいうえお');
91
INSERT INTO `T8` VALUES (' あいうえお');
92
# Double byte spaces are not supposed to be trimed
93
INSERT INTO `T8` VALUES (' あいうえお');
94
INSERT INTO `T8` VALUES (' あいうえお');
95
INSERT INTO `T8` VALUES (' あいうえお');
96
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
97
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
98
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
99
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
100
# Double byte spaces are not supposed to be trimed
101
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
102
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
103
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
106
SELECT LTRIM(`C1`) from `T1`;
107
SELECT LTRIM(`C1`) from `T2`;
108
SELECT LTRIM(`C1`) from `T3`;
111
SELECT LTRIM(`C1`) from `T4`;
112
SELECT LTRIM(`C1`) from `T5`;
113
SELECT LTRIM(`C1`) from `T6`;
116
SELECT LTRIM(`C1`) from `T7`;
117
SELECT LTRIM(`C1`) from `T8`;
118
SELECT LTRIM(`C1`) from `T9`;