1
--source include/have_sjis.inc
2
--source include/have_innodb.inc
5
drop table if exists `�s�P`;
6
drop table if exists `�s�Q`;
7
drop table if exists `�s�R`;
8
drop table if exists `�s�S`;
9
drop table if exists `�s�T`;
10
drop table if exists `�s�U`;
11
drop table if exists `�s�V`;
12
drop table if exists `�s�W`;
13
drop table if exists `�s�X`;
17
# Test RTRIM() function with Japanese characters in sjis encoding
21
SET character_set_database = sjis;
23
CREATE TABLE `�s�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
24
CREATE TABLE `�s�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�R` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `�s�S` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
27
CREATE TABLE `�s�T` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�U` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
30
CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
33
INSERT INTO `�s�P` VALUES ('�����');
34
INSERT INTO `�s�P` VALUES ('����� ');
35
INSERT INTO `�s�P` VALUES ('����� ');
36
INSERT INTO `�s�P` VALUES ('����� ');
37
# Double byte spaces are not supposed to be trimed
38
INSERT INTO `�s�P` VALUES ('������@');
39
INSERT INTO `�s�P` VALUES ('������@�@');
40
INSERT INTO `�s�P` VALUES ('������@�@�@');
41
INSERT INTO `�s�Q` VALUES ('����������');
42
INSERT INTO `�s�Q` VALUES ('���������� ');
43
INSERT INTO `�s�Q` VALUES ('���������� ');
44
INSERT INTO `�s�Q` VALUES ('���������� ');
45
# Double byte spaces are not supposed to be trimed
46
INSERT INTO `�s�Q` VALUES ('�����������@');
47
INSERT INTO `�s�Q` VALUES ('�����������@�@');
48
INSERT INTO `�s�Q` VALUES ('�����������@�@�@');
49
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
50
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\ ');
51
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\ ');
52
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\ ');
53
# Double byte spaces are not supposed to be trimed
54
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�@');
55
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�@�@');
56
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�@�@�@');
57
INSERT INTO `�s�S` VALUES ('�����');
58
INSERT INTO `�s�S` VALUES ('����� ');
59
INSERT INTO `�s�S` VALUES ('����� ');
60
INSERT INTO `�s�S` VALUES ('����� ');
61
# Double byte spaces are not supposed to be trimed
62
INSERT INTO `�s�S` VALUES ('������@');
63
INSERT INTO `�s�S` VALUES ('������@�@');
64
INSERT INTO `�s�S` VALUES ('������@�@�@');
65
INSERT INTO `�s�T` VALUES ('����������');
66
INSERT INTO `�s�T` VALUES ('���������� ');
67
INSERT INTO `�s�T` VALUES ('���������� ');
68
INSERT INTO `�s�T` VALUES ('���������� ');
69
# Double byte spaces are not supposed to be trimed
70
INSERT INTO `�s�T` VALUES ('�����������@');
71
INSERT INTO `�s�T` VALUES ('�����������@�@');
72
INSERT INTO `�s�T` VALUES ('�����������@�@�@');
73
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
74
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\ ');
75
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\ ');
76
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\ ');
77
# Double byte spaces are not supposed to be trimed
78
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�@');
79
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�@�@');
80
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�@�@�@');
81
INSERT INTO `�s�V` VALUES ('�����');
82
INSERT INTO `�s�V` VALUES ('����� ');
83
INSERT INTO `�s�V` VALUES ('����� ');
84
INSERT INTO `�s�V` VALUES ('����� ');
85
# Double byte spaces are not supposed to be trimed
86
INSERT INTO `�s�V` VALUES ('������@');
87
INSERT INTO `�s�V` VALUES ('������@�@');
88
INSERT INTO `�s�V` VALUES ('������@�@�@');
89
INSERT INTO `�s�W` VALUES ('����������');
90
INSERT INTO `�s�W` VALUES ('���������� ');
91
INSERT INTO `�s�W` VALUES ('���������� ');
92
INSERT INTO `�s�W` VALUES ('���������� ');
93
# Double byte spaces are not supposed to be trimed
94
INSERT INTO `�s�W` VALUES ('�����������@');
95
INSERT INTO `�s�W` VALUES ('�����������@�@');
96
INSERT INTO `�s�W` VALUES ('�����������@�@�@');
97
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
98
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\ ');
99
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\ ');
100
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\ ');
101
# Double byte spaces are not supposed to be trimed
102
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@');
103
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@�@');
104
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�@�@�@');
107
SELECT RTRIM(`�b�P`) from `�s�P`;
108
SELECT RTRIM(`�b�P`) from `�s�Q`;
109
SELECT RTRIM(`�b�P`) from `�s�R`;
112
SELECT RTRIM(`�b�P`) from `�s�S`;
113
SELECT RTRIM(`�b�P`) from `�s�T`;
114
SELECT RTRIM(`�b�P`) from `�s�U`;
117
SELECT RTRIM(`�b�P`) from `�s�V`;
118
SELECT RTRIM(`�b�P`) from `�s�W`;
119
SELECT RTRIM(`�b�P`) from `�s�X`;