7
7
drop table if exists `T7`;
8
8
drop table if exists `T8`;
9
9
drop table if exists `T9`;
10
drop table if exists `T10`;
11
drop table if exists `T11`;
12
drop table if exists `T12`;
14
11
SET character_set_database = utf8;
15
12
CREATE TABLE `T1a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
24
21
CREATE TABLE `T5b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
25
22
CREATE TABLE `T6a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
26
23
CREATE TABLE `T6b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
27
CREATE TABLE `T7a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
28
CREATE TABLE `T7b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
29
CREATE TABLE `T8a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
30
CREATE TABLE `T8b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
31
CREATE TABLE `T9a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
32
CREATE TABLE `T9b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
33
CREATE TABLE `T10a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
34
CREATE TABLE `T10b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
35
CREATE TABLE `T11a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
36
CREATE TABLE `T11b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
37
CREATE TABLE `T12a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
38
CREATE TABLE `T12b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = heap;
24
CREATE TABLE `T7a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
25
CREATE TABLE `T7b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
26
CREATE TABLE `T8a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
27
CREATE TABLE `T8b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
28
CREATE TABLE `T9a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
29
CREATE TABLE `T9b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
39
30
INSERT INTO `T1a` VALUES ('ア'),('カ'),('サ');
40
31
INSERT INTO `T1b` VALUES ('ア');
41
32
INSERT INTO `T2a` VALUES ('あ'),('か'),('さ');
54
45
INSERT INTO `T8b` VALUES ('あ');
55
46
INSERT INTO `T9a` VALUES ('龔'),('龖'),('龗');
56
47
INSERT INTO `T9b` VALUES ('龔');
57
INSERT INTO `T10a` VALUES ('ア'),('カ'),('サ');
58
INSERT INTO `T10b` VALUES ('ア');
59
INSERT INTO `T11a` VALUES ('あ'),('か'),('さ');
60
INSERT INTO `T11b` VALUES ('あ');
61
INSERT INTO `T12a` VALUES ('龔'),('龖'),('龗');
62
INSERT INTO `T12b` VALUES ('龔');
63
48
SELECT `C1` FROM `T1a` WHERE `C1` IN (SELECT `C1` FROM `T1b`);
153
SELECT `C1` FROM `T10a` WHERE `C1` IN (SELECT `C1` FROM `T10b`);
156
SELECT `C1` FROM `T10a` WHERE EXISTS (SELECT `C1` FROM `T10b` WHERE `T10a`.`C1` = `T10b`.`C1`);
159
SELECT `C1` FROM `T10a` WHERE NOT EXISTS (SELECT `C1` FROM `T10b` WHERE `T10a`.`C1` = `T10b`.`C1`);
163
SELECT `C1` FROM `T11a` WHERE `C1` IN (SELECT `C1` FROM `T11b`);
166
SELECT `C1` FROM `T11a` WHERE EXISTS (SELECT `C1` FROM `T11b` WHERE `T11a`.`C1` = `T11b`.`C1`);
169
SELECT `C1` FROM `T11a` WHERE NOT EXISTS (SELECT `C1` FROM `T11b` WHERE `T11a`.`C1` = `T11b`.`C1`);
173
SELECT `C1` FROM `T12a` WHERE `C1` IN (SELECT `C1` FROM `T12b`);
176
SELECT `C1` FROM `T12a` WHERE EXISTS (SELECT `C1` FROM `T12b` WHERE `T12a`.`C1` = `T12b`.`C1`);
179
SELECT `C1` FROM `T12a` WHERE NOT EXISTS (SELECT `C1` FROM `T12b` WHERE `T12a`.`C1` = `T12b`.`C1`);
183
138
DROP TABLE `T1a`;
184
139
DROP TABLE `T1b`;
185
140
DROP TABLE `T2a`;