jp_where_sjis.test

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

--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 Displaying Japanese charact using WHERE condtion in sjis encoding
#

SET NAMES sjis;
SET character_set_database = sjis;

CREATE TABLE `俿侾` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俀` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿俁` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `俿係` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俆` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俇` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `俿俈` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俉` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿俋` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `俿侾侽` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `俿侾侾` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `俿侾俀` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = bdb;

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

LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `俿侾`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `俿俀`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `俿俁`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `俿係`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `俿俆`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `俿俇`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `俿俈`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `俿俉`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `俿俋`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `俿侾侽`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `俿侾侾`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `俿侾俀`;

#InnoDB
SELECT * FROM `俿侾` WHERE `俠侾` = '氨渤吹斗腹夯冀究';
SELECT * FROM `俿俀` WHERE `俠侾` = '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
SELECT * FROM `俿俁` WHERE `俠侾` = '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';

#MyISAM
SELECT * FROM `俿係` WHERE `俠侾` = '氨渤吹斗腹夯冀究';
SELECT * FROM `俿俆` WHERE `俠侾` = '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
SELECT * FROM `俿俇` WHERE `俠侾` = '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';

#Heap
SELECT * FROM `俿俈` WHERE `俠侾` = '氨渤吹斗腹夯冀究';
SELECT * FROM `俿俉` WHERE `俠侾` = '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
SELECT * FROM `俿俋` WHERE `俠侾` = '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';

#BDB
SELECT * FROM `俿侾侽` WHERE `俠侾` = '氨渤吹斗腹夯冀究';
SELECT * FROM `俿侾侾` WHERE `俠侾` = '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
SELECT * FROM `俿侾俀` WHERE `俠侾` = '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';

#Test to distinguish 0x9353 and 0x9373
CREATE TABLE t1(c1 char(1)) default charset = sjis engine=innodb;
CREATE TABLE t2(c1 char(1)) default charset = sjis engine=myisam;
CREATE TABLE t3(c1 char(1)) default charset = sjis engine=heap;
CREATE TABLE t4(c1 char(1)) default charset = sjis engine=bdb;
INSERT INTO t1 VALUES('揝'),('搒');
INSERT INTO t2 VALUES('揝'),('搒');
INSERT INTO t3 VALUES('揝'),('搒');
INSERT INTO t4 VALUES('揝'),('搒');
SELECT * FROM t1 WHERE c1 = '揝';
SELECT * FROM t2 WHERE c1 = '揝';
SELECT * FROM t3 WHERE c1 = '揝';
SELECT * FROM t4 WHERE c1 = '揝';
SELECT * FROM t1 WHERE c1 = '搒';
SELECT * FROM t2 WHERE c1 = '搒';
SELECT * FROM t3 WHERE c1 = '搒';
SELECT * FROM t4 WHERE c1 = '搒';

DROP TABLE `俿侾`;
DROP TABLE `俿俀`;
DROP TABLE `俿俁`;
DROP TABLE `俿係`;
DROP TABLE `俿俆`;
DROP TABLE `俿俇`;
DROP TABLE `俿俈`;
DROP TABLE `俿俉`;
DROP TABLE `俿俋`;
DROP TABLE `俿侾侽`;
DROP TABLE `俿侾侾`;
DROP TABLE `俿侾俀`;