Debian Codegraph @

mysql-test/suite/jp/r/jp_subquery_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 SET character_set_database = utf8;
12 CREATE TABLE `T1a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T1b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T2a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T2b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
16 CREATE TABLE `T3a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
17 CREATE TABLE `T3b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
18 CREATE TABLE `T4a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
19 CREATE TABLE `T4b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
20 CREATE TABLE `T5a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
21 CREATE TABLE `T5b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
22 CREATE TABLE `T6a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
23 CREATE TABLE `T6b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = myisam;
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;
30 INSERT INTO `T1a` VALUES ('ア'),('カ'),('サ');
31 INSERT INTO `T1b` VALUES ('ア');
32 INSERT INTO `T2a` VALUES ('あ'),('か'),('さ');
33 INSERT INTO `T2b` VALUES ('あ');
34 INSERT INTO `T3a` VALUES ('龔'),('龖'),('龗');
35 INSERT INTO `T3b` VALUES ('龔');
36 INSERT INTO `T4a` VALUES ('ア'),('カ'),('サ');
37 INSERT INTO `T4b` VALUES ('ア');
38 INSERT INTO `T5a` VALUES ('あ'),('か'),('さ');
39 INSERT INTO `T5b` VALUES ('あ');
40 INSERT INTO `T6a` VALUES ('龔'),('龖'),('龗');
41 INSERT INTO `T6b` VALUES ('龔');
42 INSERT INTO `T7a` VALUES ('ア'),('カ'),('サ');
43 INSERT INTO `T7b` VALUES ('ア');
44 INSERT INTO `T8a` VALUES ('あ'),('か'),('さ');
45 INSERT INTO `T8b` VALUES ('あ');
46 INSERT INTO `T9a` VALUES ('龔'),('龖'),('龗');
47 INSERT INTO `T9b` VALUES ('龔');
48 SELECT `C1` FROM `T1a` WHERE `C1` IN (SELECT `C1` FROM `T1b`);
49 C1
50 ア
51 SELECT `C1` FROM `T1a` WHERE EXISTS (SELECT `C1` FROM `T1b` WHERE `T1a`.`C1` = `T1b`.`C1`);
52 C1
53 ア
54 SELECT `C1` FROM `T1a` WHERE NOT EXISTS (SELECT `C1` FROM `T1b` WHERE `T1a`.`C1` = `T1b`.`C1`);
55 C1
56 カ
57 サ
58 SELECT `C1` FROM `T2a` WHERE `C1` IN (SELECT `C1` FROM `T2b`);
59 C1
60 あ
61 SELECT `C1` FROM `T2a` WHERE EXISTS (SELECT `C1` FROM `T2b` WHERE `T2a`.`C1` = `T2b`.`C1`);
62 C1
63 あ
64 SELECT `C1` FROM `T2a` WHERE NOT EXISTS (SELECT `C1` FROM `T2b` WHERE `T2a`.`C1` = `T2b`.`C1`);
65 C1
66 か
67 さ
68 SELECT `C1` FROM `T3a` WHERE `C1` IN (SELECT `C1` FROM `T3b`);
69 C1
70 龔
71 SELECT `C1` FROM `T3a` WHERE EXISTS (SELECT `C1` FROM `T3b` WHERE `T3a`.`C1` = `T3b`.`C1`);
72 C1
73 龔
74 SELECT `C1` FROM `T3a` WHERE NOT EXISTS (SELECT `C1` FROM `T3b` WHERE `T3a`.`C1` = `T3b`.`C1`);
75 C1
76 龖
77 龗
78 SELECT `C1` FROM `T4a` WHERE `C1` IN (SELECT `C1` FROM `T4b`);
79 C1
80 ア
81 SELECT `C1` FROM `T4a` WHERE EXISTS (SELECT `C1` FROM `T4b` WHERE `T4a`.`C1` = `T4b`.`C1`);
82 C1
83 ア
84 SELECT `C1` FROM `T4a` WHERE NOT EXISTS (SELECT `C1` FROM `T4b` WHERE `T4a`.`C1` = `T4b`.`C1`);
85 C1
86 カ
87 サ
88 SELECT `C1` FROM `T5a` WHERE `C1` IN (SELECT `C1` FROM `T5b`);
89 C1
90 あ
91 SELECT `C1` FROM `T5a` WHERE EXISTS (SELECT `C1` FROM `T5b` WHERE `T5a`.`C1` = `T5b`.`C1`);
92 C1
93 あ
94 SELECT `C1` FROM `T5a` WHERE NOT EXISTS (SELECT `C1` FROM `T5b` WHERE `T5a`.`C1` = `T5b`.`C1`);
95 C1
96 か
97 さ
98 SELECT `C1` FROM `T6a` WHERE `C1` IN (SELECT `C1` FROM `T6b`);
99 C1
100 龔
101 SELECT `C1` FROM `T6a` WHERE EXISTS (SELECT `C1` FROM `T6b` WHERE `T6a`.`C1` = `T6b`.`C1`);
102 C1
103 龔
104 SELECT `C1` FROM `T6a` WHERE NOT EXISTS (SELECT `C1` FROM `T6b` WHERE `T6a`.`C1` = `T6b`.`C1`);
105 C1
106 龖
107 龗
108 SELECT `C1` FROM `T7a` WHERE `C1` IN (SELECT `C1` FROM `T7b`);
109 C1
110 ア
111 SELECT `C1` FROM `T7a` WHERE EXISTS (SELECT `C1` FROM `T7b` WHERE `T7a`.`C1` = `T7b`.`C1`);
112 C1
113 ア
114 SELECT `C1` FROM `T7a` WHERE NOT EXISTS (SELECT `C1` FROM `T7b` WHERE `T7a`.`C1` = `T7b`.`C1`);
115 C1
116 カ
117 サ
118 SELECT `C1` FROM `T8a` WHERE `C1` IN (SELECT `C1` FROM `T8b`);
119 C1
120 あ
121 SELECT `C1` FROM `T8a` WHERE EXISTS (SELECT `C1` FROM `T8b` WHERE `T8a`.`C1` = `T8b`.`C1`);
122 C1
123 あ
124 SELECT `C1` FROM `T8a` WHERE NOT EXISTS (SELECT `C1` FROM `T8b` WHERE `T8a`.`C1` = `T8b`.`C1`);
125 C1
126 か
127 さ
128 SELECT `C1` FROM `T9a` WHERE `C1` IN (SELECT `C1` FROM `T9b`);
129 C1
130 龔
131 SELECT `C1` FROM `T9a` WHERE EXISTS (SELECT `C1` FROM `T9b` WHERE `T9a`.`C1` = `T9b`.`C1`);
132 C1
133 龔
134 SELECT `C1` FROM `T9a` WHERE NOT EXISTS (SELECT `C1` FROM `T9b` WHERE `T9a`.`C1` = `T9b`.`C1`);
135 C1
136 龖
137 龗
138 DROP TABLE `T1a`;
139 DROP TABLE `T1b`;
140 DROP TABLE `T2a`;
141 DROP TABLE `T2b`;
142 DROP TABLE `T3a`;
143 DROP TABLE `T3b`;
144 DROP TABLE `T4a`;
145 DROP TABLE `T4b`;
146 DROP TABLE `T5a`;
147 DROP TABLE `T5b`;
148 DROP TABLE `T6a`;
149 DROP TABLE `T6b`;
150 DROP TABLE `T7a`;
151 DROP TABLE `T7b`;
152 DROP TABLE `T8a`;
153 DROP TABLE `T8b`;
154 DROP TABLE `T9a`;
155 DROP TABLE `T9b`;