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 subquery using Japanese characters in ucs2 encoding
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 = myisam;
33
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
34
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
35
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
36
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
37
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
38
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
39
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
40
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
41
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
42
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
43
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
44
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
45
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
46
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
47
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
48
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
49
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap;
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` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
83
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
84
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
85
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
86
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
87
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
88
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
89
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
90
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
91
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
92
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
93
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
94
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
95
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
96
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
97
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
98
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
99
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
100
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
101
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
102
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
103
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
104
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
105
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
106
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
107
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
108
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
109
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
110
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
111
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
112
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
113
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
114
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
115
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
116
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
117
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);