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 RTRIM() 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 = heap;
29
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
30
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
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 RTRIM(`�b�P`) from `�s�P`;
134
SELECT RTRIM(`�b�P`) from `�s�Q`;
135
SELECT RTRIM(`�b�P`) from `�s�R`;
138
SELECT RTRIM(`�b�P`) from `�s�S`;
139
SELECT RTRIM(`�b�P`) from `�s�T`;
140
SELECT RTRIM(`�b�P`) from `�s�U`;
143
SELECT RTRIM(`�b�P`) from `�s�V`;
144
SELECT RTRIM(`�b�P`) from `�s�W`;
145
SELECT RTRIM(`�b�P`) from `�s�X`;
148
SELECT RTRIM(`�b�P`) from `�s�P�O`;
149
SELECT RTRIM(`�b�P`) from `�s�P�P`;
150
SELECT RTRIM(`�b�P`) from `�s�P�Q`;