1
--source include/have_ucs2.inc
4
drop table if exists `�ԣ�`;
5
drop table if exists `�ԣ�`;
6
drop table if exists `�ԣ�`;
7
drop table if exists `�ԣ�`;
8
drop table if exists `�ԣ�`;
9
drop table if exists `�ԣ�`;
10
drop table if exists `�ԣ�`;
11
drop table if exists `�ԣ�`;
12
drop table if exists `�ԣ�`;
13
drop table if exists `�ԣ���`;
14
drop table if exists `�ԣ���`;
15
drop table if exists `�ԣ���`;
19
# Test table JOIN using Japanese characters
23
SET character_set_database = ucs2;
24
SET collation_connection = ucs2_general_ci;
26
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
27
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
28
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
29
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
30
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
31
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
32
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
33
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
34
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
35
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
36
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
37
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
38
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
39
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
40
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
41
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
42
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
43
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
44
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
45
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
46
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
47
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
48
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
49
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
51
#insert the following data in each table
52
# jisx0201 hankaku-katakana data
54
# jisx0212 supplemental character data
56
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
57
INSERT INTO `�ԣ�b` VALUES ('��');
58
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
59
INSERT INTO `�ԣ�b` VALUES ('��');
60
INSERT INTO `�ԣ�a` VALUES ('���'),('���'),('���');
61
INSERT INTO `�ԣ�b` VALUES ('���');
62
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
63
INSERT INTO `�ԣ�b` VALUES ('��');
64
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
65
INSERT INTO `�ԣ�b` VALUES ('��');
66
INSERT INTO `�ԣ�a` VALUES ('���'),('���'),('���');
67
INSERT INTO `�ԣ�b` VALUES ('���');
68
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
69
INSERT INTO `�ԣ�b` VALUES ('��');
70
INSERT INTO `�ԣ�a` VALUES ('��'),('��'),('��');
71
INSERT INTO `�ԣ�b` VALUES ('��');
72
INSERT INTO `�ԣ�a` VALUES ('���'),('���'),('���');
73
INSERT INTO `�ԣ�b` VALUES ('���');
74
INSERT INTO `�ԣ���a` VALUES ('��'),('��'),('��');
75
INSERT INTO `�ԣ���b` VALUES ('��');
76
INSERT INTO `�ԣ���a` VALUES ('��'),('��'),('��');
77
INSERT INTO `�ԣ���b` VALUES ('��');
78
INSERT INTO `�ԣ���a` VALUES ('���'),('���'),('���');
79
INSERT INTO `�ԣ���b` VALUES ('���');
82
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
83
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
84
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
85
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
86
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
87
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
88
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
89
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
90
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
91
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
92
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
93
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
94
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
95
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
96
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
97
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
98
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
99
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
100
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
101
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
102
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
103
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
104
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
105
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
106
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
107
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
108
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
111
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
112
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
113
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
114
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
115
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
116
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
117
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
118
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
119
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
120
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
121
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
122
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
123
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
124
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
125
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
126
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
127
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
128
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
129
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
130
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
131
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
132
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
133
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
134
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
135
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
136
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
137
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
140
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
141
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
142
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
143
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
144
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
145
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
146
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
147
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
148
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
149
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
150
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
151
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
152
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
153
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
154
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
155
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
156
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
157
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
158
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
159
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
160
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
161
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
162
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
163
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
164
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
165
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
166
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
169
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
170
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
171
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
172
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
173
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
174
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
175
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
176
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
177
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
178
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
179
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
180
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
181
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
182
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
183
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
184
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
185
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
186
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
187
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
188
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
189
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
190
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
191
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
192
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
193
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
194
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
195
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);