3
drop table if exists `�s�P`;
4
drop table if exists `�s�Q`;
5
drop table if exists `�s�R`;
6
drop table if exists `�s�S`;
7
drop table if exists `�s�T`;
8
drop table if exists `�s�U`;
9
drop table if exists `�s�V`;
10
drop table if exists `�s�W`;
11
drop table if exists `�s�X`;
12
drop table if exists `�s�P�O`;
16
# Test LTRIM() function with Japanese characters in sjis encoding
20
SET character_set_database = sjis;
22
CREATE TABLE `�s�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
23
CREATE TABLE `�s�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
24
CREATE TABLE `�s�R` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�S` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
26
CREATE TABLE `�s�T` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27
CREATE TABLE `�s�U` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
29
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
CREATE TABLE `�s�P�O` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
32
CREATE TABLE `�s�P�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
33
CREATE TABLE `�s�P�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
35
INSERT INTO `�s�P` VALUES ('�����');
36
INSERT INTO `�s�P` VALUES (' �����');
37
INSERT INTO `�s�P` VALUES (' �����');
38
INSERT INTO `�s�P` VALUES (' �����');
39
# Double byte spaces are not supposed to be trimed
40
INSERT INTO `�s�P` VALUES ('�@�����');
41
INSERT INTO `�s�P` VALUES ('�@�@�����');
42
INSERT INTO `�s�P` VALUES ('�@�@�@�����');
43
INSERT INTO `�s�Q` VALUES ('����������');
44
INSERT INTO `�s�Q` VALUES (' ����������');
45
INSERT INTO `�s�Q` VALUES (' ����������');
46
INSERT INTO `�s�Q` VALUES (' ����������');
47
# Double byte spaces are not supposed to be trimed
48
INSERT INTO `�s�Q` VALUES ('�@����������');
49
INSERT INTO `�s�Q` VALUES ('�@�@����������');
50
INSERT INTO `�s�Q` VALUES ('�@�@�@����������');
51
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
52
INSERT INTO `�s�R` VALUES (' �\�\�\�\�\');
53
INSERT INTO `�s�R` VALUES (' �\�\�\�\�\');
54
INSERT INTO `�s�R` VALUES (' �\�\�\�\�\');
55
# Double byte spaces are not supposed to be trimed
56
INSERT INTO `�s�R` VALUES ('�@�\�\�\�\�\');
57
INSERT INTO `�s�R` VALUES ('�@�@�\�\�\�\�\');
58
INSERT INTO `�s�R` VALUES ('�@�@�@�\�\�\�\�\');
59
INSERT INTO `�s�S` VALUES ('�����');
60
INSERT INTO `�s�S` VALUES (' �����');
61
INSERT INTO `�s�S` VALUES (' �����');
62
INSERT INTO `�s�S` VALUES (' �����');
63
# Double byte spaces are not supposed to be trimed
64
INSERT INTO `�s�S` VALUES ('�@�����');
65
INSERT INTO `�s�S` VALUES ('�@�@�����');
66
INSERT INTO `�s�S` VALUES ('�@�@�@�����');
67
INSERT INTO `�s�T` VALUES ('����������');
68
INSERT INTO `�s�T` VALUES (' ����������');
69
INSERT INTO `�s�T` VALUES (' ����������');
70
INSERT INTO `�s�T` VALUES (' ����������');
71
# Double byte spaces are not supposed to be trimed
72
INSERT INTO `�s�T` VALUES ('�@����������');
73
INSERT INTO `�s�T` VALUES ('�@�@����������');
74
INSERT INTO `�s�T` VALUES ('�@�@�@����������');
75
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
76
INSERT INTO `�s�U` VALUES (' �\�\�\�\�\');
77
INSERT INTO `�s�U` VALUES (' �\�\�\�\�\');
78
INSERT INTO `�s�U` VALUES (' �\�\�\�\�\');
79
# Double byte spaces are not supposed to be trimed
80
INSERT INTO `�s�U` VALUES ('�@�\�\�\�\�\');
81
INSERT INTO `�s�U` VALUES ('�@�@�\�\�\�\�\');
82
INSERT INTO `�s�U` VALUES ('�@�@�@�\�\�\�\�\');
83
INSERT INTO `�s�V` VALUES ('�����');
84
INSERT INTO `�s�V` VALUES (' �����');
85
INSERT INTO `�s�V` VALUES (' �����');
86
INSERT INTO `�s�V` VALUES (' �����');
87
# Double byte spaces are not supposed to be trimed
88
INSERT INTO `�s�V` VALUES ('�@�����');
89
INSERT INTO `�s�V` VALUES ('�@�@�����');
90
INSERT INTO `�s�V` VALUES ('�@�@�@�����');
91
INSERT INTO `�s�W` VALUES ('����������');
92
INSERT INTO `�s�W` VALUES (' ����������');
93
INSERT INTO `�s�W` VALUES (' ����������');
94
INSERT INTO `�s�W` VALUES (' ����������');
95
# Double byte spaces are not supposed to be trimed
96
INSERT INTO `�s�W` VALUES ('�@����������');
97
INSERT INTO `�s�W` VALUES ('�@�@����������');
98
INSERT INTO `�s�W` VALUES ('�@�@�@����������');
99
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
100
INSERT INTO `�s�X` VALUES (' �\�\�\�\�\');
101
INSERT INTO `�s�X` VALUES (' �\�\�\�\�\');
102
INSERT INTO `�s�X` VALUES (' �\�\�\�\�\');
103
# Double byte spaces are not supposed to be trimed
104
INSERT INTO `�s�X` VALUES ('�@�\�\�\�\�\');
105
INSERT INTO `�s�X` VALUES ('�@�@�\�\�\�\�\');
106
INSERT INTO `�s�X` VALUES ('�@�@�@�\�\�\�\�\');
107
INSERT INTO `�s�P�O` VALUES ('�����');
108
INSERT INTO `�s�P�O` VALUES (' �����');
109
INSERT INTO `�s�P�O` VALUES (' �����');
110
INSERT INTO `�s�P�O` VALUES (' �����');
111
# Double byte spaces are not supposed to be trimed
112
INSERT INTO `�s�P�O` VALUES ('�@�����');
113
INSERT INTO `�s�P�O` VALUES ('�@�@�����');
114
INSERT INTO `�s�P�O` VALUES ('�@�@�@�����');
115
INSERT INTO `�s�P�P` VALUES ('����������');
116
INSERT INTO `�s�P�P` VALUES (' ����������');
117
INSERT INTO `�s�P�P` VALUES (' ����������');
118
INSERT INTO `�s�P�P` VALUES (' ����������');
119
# Double byte spaces are not supposed to be trimed
120
INSERT INTO `�s�P�P` VALUES ('�@����������');
121
INSERT INTO `�s�P�P` VALUES ('�@�@����������');
122
INSERT INTO `�s�P�P` VALUES ('�@�@�@����������');
123
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
124
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
125
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
126
INSERT INTO `�s�P�Q` VALUES (' �\�\�\�\�\');
127
# Double byte spaces are not supposed to be trimed
128
INSERT INTO `�s�P�Q` VALUES ('�@�\�\�\�\�\');
129
INSERT INTO `�s�P�Q` VALUES ('�@�@�\�\�\�\�\');
130
INSERT INTO `�s�P�Q` VALUES ('�@�@�@�\�\�\�\�\');
133
SELECT LTRIM(`�b�P`) from `�s�P`;
134
SELECT LTRIM(`�b�P`) from `�s�Q`;
135
SELECT LTRIM(`�b�P`) from `�s�R`;
138
SELECT LTRIM(`�b�P`) from `�s�S`;
139
SELECT LTRIM(`�b�P`) from `�s�T`;
140
SELECT LTRIM(`�b�P`) from `�s�U`;
143
SELECT LTRIM(`�b�P`) from `�s�V`;
144
SELECT LTRIM(`�b�P`) from `�s�W`;
145
SELECT LTRIM(`�b�P`) from `�s�X`;
148
SELECT LTRIM(`�b�P`) from `�s�P�O`;
149
SELECT LTRIM(`�b�P`) from `�s�P�P`;
150
SELECT LTRIM(`�b�P`) from `�s�P�Q`;