jp_join_sjis.test

来自「这个文件是windows mysql源码」· TEST 代码 · 共 54 行

--character_set sjis
--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 table JOIN using Japanese characters in sjis encoding
#

SET NAMES sjis;
SET character_set_database = sjis;

CREATE TABLE `俿侾a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿侾b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俀a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俀b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俁a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俁b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿係a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿係b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俆a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俆b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俇a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俇b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俈a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俈b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俉a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俉b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俋a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俋b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侽a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侽b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侾a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侾b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾俀a` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾俀b` (`俠侾` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap;

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

INSERT INTO `俿侾a` VALUES ('