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`;
13
drop table if exists `�s�P�P`;
14
drop table if exists `�s�P�Q`;
18
# Test RIGHT() function with Japanese character in sjis encoding
22
SET character_set_database = sjis;
24
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
25
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
26
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
27
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
28
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
29
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
30
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
32
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
33
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
34
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
35
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
37
INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
38
INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
39
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
40
INSERT INTO `�s�S` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
41
INSERT INTO `�s�T` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
42
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
43
INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
44
INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
45
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
46
INSERT INTO `�s�P�O` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
47
INSERT INTO `�s�P�P` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
48
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
51
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P`;
52
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P`;
53
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P`;
54
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P`;
55
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P`;
56
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P`;
57
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�Q`;
58
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�Q`;
59
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�Q`;
60
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�Q`;
61
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�Q`;
62
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�Q`;
63
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�R`;
64
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�R`;
65
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�R`;
66
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�R`;
67
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�R`;
68
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�R`;
71
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�S`;
72
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�S`;
73
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�S`;
74
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�S`;
75
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�S`;
76
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�S`;
77
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�T`;
78
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�T`;
79
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�T`;
80
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�T`;
81
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�T`;
82
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�T`;
83
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�U`;
84
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�U`;
85
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�U`;
86
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�U`;
87
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�U`;
88
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�U`;
91
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�V`;
92
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�V`;
93
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�V`;
94
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�V`;
95
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�V`;
96
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�V`;
97
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�W`;
98
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�W`;
99
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�W`;
100
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�W`;
101
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�W`;
102
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�W`;
103
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�X`;
104
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�X`;
105
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�X`;
106
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�X`;
107
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�X`;
108
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�X`;
111
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�O`;
112
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�O`;
113
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�O`;
114
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�O`;
115
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�O`;
116
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�O`;
117
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�P`;
118
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�P`;
119
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�P`;
120
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�P`;
121
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�P`;
122
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�P`;
123
SELECT `�b�P`, RIGHT(`�b�P`,0) FROM `�s�P�Q`;
124
SELECT `�b�P`, RIGHT(`�b�P`,1) FROM `�s�P�Q`;
125
SELECT `�b�P`, RIGHT(`�b�P`,2) FROM `�s�P�Q`;
126
SELECT `�b�P`, RIGHT(`�b�P`,3) FROM `�s�P�Q`;
127
SELECT `�b�P`, RIGHT(`�b�P`,4) FROM `�s�P�Q`;
128
SELECT `�b�P`, RIGHT(`�b�P`,5) FROM `�s�P�Q`;