~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/t/jp_subquery

~drizzle-trunk/drizzle/development : (revision 1)

--source include/have_ujis.inc

--disable_warnings
drop table if exists `£Ô£±`;
drop table if exists `£Ô£²`;
drop table if exists `£Ô£³`;
drop table if exists `£Ô£Ž`;
drop table if exists `£Ô£µ`;
drop table if exists `£Ô£¶`;
drop table if exists `£Ô£·`;
drop table if exists `£Ô£ž`;
drop table if exists `£Ô£¹`;
drop table if exists `£Ô£±£°`;
drop table if exists `£Ô£±£±`;
drop table if exists `£Ô£±£²`;
--enable_warnings

#
# Test subquery using Japanese characters in ujis encoding 
#

SET NAMES ujis;
SET character_set_database = ujis;

CREATE TABLE `£Ô£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£³a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£³b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£Ža` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£Žb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£µa` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£µb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£¶a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£¶b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£·a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£·b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£ža` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£žb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£¹a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£¹b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£°a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£°b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `£Ô£±£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;

#insert the following data in each table
# jisx0201 hankaku-katakana data
# jisx0208 data
# jisx0212 supplemental character data

INSERT INTO `£Ô£±a` VALUES ('±'),('¶'),('»');
INSERT INTO `£Ô£±b` VALUES ('±');
INSERT INTO `£Ô£²a` VALUES ('€¢'),('€«'),('€µ');
INSERT INTO `£Ô£²b` VALUES ('€¢');
INSERT INTO `£Ô£³a` VALUES ('íÜ'),('íÝ'),('íÞ');
INSERT INTO `£Ô£³b` VALUES ('íÜ');
INSERT INTO `£Ô£Ža` VALUES ('±'),('¶'),('»');
INSERT INTO `£Ô£Žb` VALUES ('±');
INSERT INTO `£Ô£µa` VALUES ('€¢'),('€«'),('€µ');
INSERT INTO `£Ô£µb` VALUES ('€¢');
INSERT INTO `£Ô£¶a` VALUES ('íÜ'),('íÝ'),('íÞ');
INSERT INTO `£Ô£¶b` VALUES ('íÜ');
INSERT INTO `£Ô£·a` VALUES ('±'),('¶'),('»');
INSERT INTO `£Ô£·b` VALUES ('±');
INSERT INTO `£Ô£ža` VALUES ('€¢'),('€«'),('€µ');
INSERT INTO `£Ô£žb` VALUES ('€¢');
INSERT INTO `£Ô£¹a` VALUES ('íÜ'),('íÝ'),('íÞ');
INSERT INTO `£Ô£¹b` VALUES ('íÜ');
INSERT INTO `£Ô£±£°a` VALUES ('±'),('¶'),('»');
INSERT INTO `£Ô£±£°b` VALUES ('±');
INSERT INTO `£Ô£±£±a` VALUES ('€¢'),('€«'),('€µ');
INSERT INTO `£Ô£±£±b` VALUES ('€¢');
INSERT INTO `£Ô£±£²a` VALUES ('íÜ'),('íÝ'),('íÞ');
INSERT INTO `£Ô£±£²b` VALUES ('íÜ');

#Test for innodb
SELECT `£Ã£±` FROM `£Ô£±a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±b`);
SELECT `£Ã£±` FROM `£Ô£±a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£²a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£²b`);
SELECT `£Ã£±` FROM `£Ô£²a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£²a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£³a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£³b`);
SELECT `£Ã£±` FROM `£Ô£³a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£³a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£Ža` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£Žb`);
SELECT `£Ã£±` FROM `£Ô£Ža` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£Žb` WHERE `£Ô£Ža`.`£Ã£±` = `£Ô£Žb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£Ža` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£Žb` WHERE `£Ô£Ža`.`£Ã£±` = `£Ô£Žb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£µa` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£µb`);
SELECT `£Ã£±` FROM `£Ô£µa` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£µa` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¶b`);
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£·a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£·b`);
SELECT `£Ã£±` FROM `£Ô£·a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£·a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£ža` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£žb`);
SELECT `£Ã£±` FROM `£Ô£ža` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£žb` WHERE `£Ô£ža`.`£Ã£±` = `£Ô£žb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£ža` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£žb` WHERE `£Ô£ža`.`£Ã£±` = `£Ô£žb`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¹b`);
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£°b`);
SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£°b` WHERE `£Ô£±£°a`.`£Ã£±` = `£Ô£±£°b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£°b` WHERE `£Ô£±£°a`.`£Ã£±` = `£Ô£±£°b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£±b`);
SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£±b` WHERE `£Ô£±£±a`.`£Ã£±` = `£Ô£±£±b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£±b` WHERE `£Ô£±£±a`.`£Ã£±` = `£Ô£±£±b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£²b`);
SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£²b` WHERE `£Ô£±£²a`.`£Ã£±` = `£Ô£±£²b`.`£Ã£±`);
SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£²b` WHERE `£Ô£±£²a`.`£Ã£±` = `£Ô£±£²b`.`£Ã£±`);

DROP TABLE `£Ô£±a`;
DROP TABLE `£Ô£±b`;
DROP TABLE `£Ô£²a`;
DROP TABLE `£Ô£²b`;
DROP TABLE `£Ô£³a`;
DROP TABLE `£Ô£³b`;
DROP TABLE `£Ô£Ža`;
DROP TABLE `£Ô£Žb`;
DROP TABLE `£Ô£µa`;
DROP TABLE `£Ô£µb`;
DROP TABLE `£Ô£¶a`;
DROP TABLE `£Ô£¶b`;
DROP TABLE `£Ô£·a`;
DROP TABLE `£Ô£·b`;
DROP TABLE `£Ô£ža`;
DROP TABLE `£Ô£žb`;
DROP TABLE `£Ô£¹a`;
DROP TABLE `£Ô£¹b`;
DROP TABLE `£Ô£±£°a`;
DROP TABLE `£Ô£±£°b`;
DROP TABLE `£Ô£±£±a`;
DROP TABLE `£Ô£±£±b`;
DROP TABLE `£Ô£±£²a`;
DROP TABLE `£Ô£±£²b`;


1 by brian clean slate	1	--source include/have_ujis.inc
	2
	3	--disable_warnings
	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 `£Ô£±£²`;
	16	--enable_warnings
	17
	18	#
	19	# Test subquery using Japanese characters in ujis encoding
	20	#
	21
	22	SET NAMES ujis;
	23	SET character_set_database = ujis;
	24
	25	CREATE TABLE `£Ô£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	26	CREATE TABLE `£Ô£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	27	CREATE TABLE `£Ô£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	28	CREATE TABLE `£Ô£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	29	CREATE TABLE `£Ô£³a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	30	CREATE TABLE `£Ô£³b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
	31	CREATE TABLE `£Ô£Ža` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	32	CREATE TABLE `£Ô£Žb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	33	CREATE TABLE `£Ô£µa` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	34	CREATE TABLE `£Ô£µb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	35	CREATE TABLE `£Ô£¶a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	36	CREATE TABLE `£Ô£¶b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
	37	CREATE TABLE `£Ô£·a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	38	CREATE TABLE `£Ô£·b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	39	CREATE TABLE `£Ô£ža` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	40	CREATE TABLE `£Ô£žb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	41	CREATE TABLE `£Ô£¹a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	42	CREATE TABLE `£Ô£¹b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	43	CREATE TABLE `£Ô£±£°a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	44	CREATE TABLE `£Ô£±£°b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	45	CREATE TABLE `£Ô£±£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	46	CREATE TABLE `£Ô£±£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	47	CREATE TABLE `£Ô£±£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	48	CREATE TABLE `£Ô£±£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = heap;
	49
	50	#insert the following data in each table
	51	# jisx0201 hankaku-katakana data
	52	# jisx0208 data
	53	# jisx0212 supplemental character data
	54
	55	INSERT INTO `£Ô£±a` VALUES ('±'),('¶'),('»');
	56	INSERT INTO `£Ô£±b` VALUES ('±');
	57	INSERT INTO `£Ô£²a` VALUES ('€¢'),('€«'),('€µ');
	58	INSERT INTO `£Ô£²b` VALUES ('€¢');
	59	INSERT INTO `£Ô£³a` VALUES ('íÜ'),('íÝ'),('íÞ');
	60	INSERT INTO `£Ô£³b` VALUES ('íÜ');
	61	INSERT INTO `£Ô£Ža` VALUES ('±'),('¶'),('»');
	62	INSERT INTO `£Ô£Žb` VALUES ('±');
	63	INSERT INTO `£Ô£µa` VALUES ('€¢'),('€«'),('€µ');
	64	INSERT INTO `£Ô£µb` VALUES ('€¢');
65	INSERT INTO `£Ô£¶a` VALUES ('íÜ'),('íÝ'),('íÞ');
66	INSERT INTO `£Ô£¶b` VALUES ('íÜ');
67	INSERT INTO `£Ô£·a` VALUES ('±'),('¶'),('»');
68	INSERT INTO `£Ô£·b` VALUES ('±');
69	INSERT INTO `£Ô£ža` VALUES ('€¢'),('€«'),('€µ');
70	INSERT INTO `£Ô£žb` VALUES ('€¢');
71	INSERT INTO `£Ô£¹a` VALUES ('íÜ'),('íÝ'),('íÞ');
72	INSERT INTO `£Ô£¹b` VALUES ('íÜ');
73	INSERT INTO `£Ô£±£°a` VALUES ('±'),('¶'),('»');
74	INSERT INTO `£Ô£±£°b` VALUES ('±');
75	INSERT INTO `£Ô£±£±a` VALUES ('€¢'),('€«'),('€µ');
76	INSERT INTO `£Ô£±£±b` VALUES ('€¢');
77	INSERT INTO `£Ô£±£²a` VALUES ('íÜ'),('íÝ'),('íÞ');
78	INSERT INTO `£Ô£±£²b` VALUES ('íÜ');
79
80	#Test for innodb
81	SELECT `£Ã£±` FROM `£Ô£±a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±b`);
82	SELECT `£Ã£±` FROM `£Ô£±a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
83	SELECT `£Ã£±` FROM `£Ô£±a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
84	SELECT `£Ã£±` FROM `£Ô£²a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£²b`);
85	SELECT `£Ã£±` FROM `£Ô£²a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
86	SELECT `£Ã£±` FROM `£Ô£²a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
87	SELECT `£Ã£±` FROM `£Ô£³a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£³b`);
88	SELECT `£Ã£±` FROM `£Ô£³a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
89	SELECT `£Ã£±` FROM `£Ô£³a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
90	SELECT `£Ã£±` FROM `£Ô£Ža` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£Žb`);
91	SELECT `£Ã£±` FROM `£Ô£Ža` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£Žb` WHERE `£Ô£Ža`.`£Ã£±` = `£Ô£Žb`.`£Ã£±`);
92	SELECT `£Ã£±` FROM `£Ô£Ža` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£Žb` WHERE `£Ô£Ža`.`£Ã£±` = `£Ô£Žb`.`£Ã£±`);
93	SELECT `£Ã£±` FROM `£Ô£µa` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£µb`);
94	SELECT `£Ã£±` FROM `£Ô£µa` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
95	SELECT `£Ã£±` FROM `£Ô£µa` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
96	SELECT `£Ã£±` FROM `£Ô£¶a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¶b`);
97	SELECT `£Ã£±` FROM `£Ô£¶a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
98	SELECT `£Ã£±` FROM `£Ô£¶a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
99	SELECT `£Ã£±` FROM `£Ô£·a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£·b`);
100	SELECT `£Ã£±` FROM `£Ô£·a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
101	SELECT `£Ã£±` FROM `£Ô£·a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
102	SELECT `£Ã£±` FROM `£Ô£ža` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£žb`);
103	SELECT `£Ã£±` FROM `£Ô£ža` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£žb` WHERE `£Ô£ža`.`£Ã£±` = `£Ô£žb`.`£Ã£±`);
104	SELECT `£Ã£±` FROM `£Ô£ža` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£žb` WHERE `£Ô£ža`.`£Ã£±` = `£Ô£žb`.`£Ã£±`);
105	SELECT `£Ã£±` FROM `£Ô£¹a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¹b`);
106	SELECT `£Ã£±` FROM `£Ô£¹a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
107	SELECT `£Ã£±` FROM `£Ô£¹a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
108	SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£°b`);
109	SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£°b` WHERE `£Ô£±£°a`.`£Ã£±` = `£Ô£±£°b`.`£Ã£±`);
110	SELECT `£Ã£±` FROM `£Ô£±£°a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£°b` WHERE `£Ô£±£°a`.`£Ã£±` = `£Ô£±£°b`.`£Ã£±`);
111	SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£±b`);
112	SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£±b` WHERE `£Ô£±£±a`.`£Ã£±` = `£Ô£±£±b`.`£Ã£±`);
113	SELECT `£Ã£±` FROM `£Ô£±£±a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£±b` WHERE `£Ô£±£±a`.`£Ã£±` = `£Ô£±£±b`.`£Ã£±`);
114	SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±£²b`);
115	SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±£²b` WHERE `£Ô£±£²a`.`£Ã£±` = `£Ô£±£²b`.`£Ã£±`);
116	SELECT `£Ã£±` FROM `£Ô£±£²a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±£²b` WHERE `£Ô£±£²a`.`£Ã£±` = `£Ô£±£²b`.`£Ã£±`);
117
118	DROP TABLE `£Ô£±a`;
119	DROP TABLE `£Ô£±b`;
120	DROP TABLE `£Ô£²a`;
121	DROP TABLE `£Ô£²b`;
122	DROP TABLE `£Ô£³a`;
123	DROP TABLE `£Ô£³b`;
124	DROP TABLE `£Ô£Ža`;
125	DROP TABLE `£Ô£Žb`;
126	DROP TABLE `£Ô£µa`;
127	DROP TABLE `£Ô£µb`;
128	DROP TABLE `£Ô£¶a`;
129	DROP TABLE `£Ô£¶b`;
130	DROP TABLE `£Ô£·a`;
131	DROP TABLE `£Ô£·b`;
132	DROP TABLE `£Ô£ža`;
133	DROP TABLE `£Ô£žb`;
134	DROP TABLE `£Ô£¹a`;
135	DROP TABLE `£Ô£¹b`;
136	DROP TABLE `£Ô£±£°a`;
137	DROP TABLE `£Ô£±£°b`;
138	DROP TABLE `£Ô£±£±a`;
139	DROP TABLE `£Ô£±£±b`;
140	DROP TABLE `£Ô£±£²a`;
141	DROP TABLE `£Ô£±£²b`;
142