�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2F'>suite</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Fjp%2F'>jp</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Fjp%2Ft%2F'>t</a>/</p><hr><h3>✏️ Editing: jp_subquery_ucs2.test</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>--source include/have_ucs2.inc
--source include/have_innodb.inc

--disable_warnings
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
DROP TABLE IF EXISTS `�ԣ�a`;
DROP TABLE IF EXISTS `�ԣ�b`;
--enable_warnings

#
# Test subquery using Japanese characters in ucs2 encoding 
#

SET NAMES ujis;
SET character_set_database = ucs2;
SET collation_connection = ucs2_general_ci;

CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;

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

INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;���&#039;),(&#039;���&#039;),(&#039;���&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;���&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;���&#039;),(&#039;���&#039;),(&#039;���&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;���&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;��&#039;),(&#039;��&#039;),(&#039;��&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;��&#039;);
INSERT INTO `�ԣ�a` VALUES (&#039;���&#039;),(&#039;���&#039;),(&#039;���&#039;);
INSERT INTO `�ԣ�b` VALUES (&#039;���&#039;);

#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`.`�ã�`);

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`;
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Fjp%2Ft'>🔙 Back</a></p>