mariadb/mysql-test/suite/jp/r/jp_like_sjis.result

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 `俿俋`;
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 = MEMORY;
CREATE TABLE `俿俉` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `俿俋` (`俠侾` char(20), INDEX(`俠侾`)) DEFAULT CHARSET = sjis engine = MEMORY;
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 `俿俋`;
SELECT * FROM `俿侾` WHERE `俠侾` LIKE ' %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '% %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '% ';
俠侾
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '<27>%';
俠侾
懒旅呐魄壬仕掏蜗
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '%棕%';
俠侾
醒矣哉肿刭谯茌捱
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '%<25>';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿侾` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%丂';
俠侾
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '偲%';
俠侾
偲偳側偵偸偹偺偼偽傁傂傃傄傆傇傉傊傋傌傎
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%偁%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%傢';
俠侾
傏傐傑傒傓傔傕傖傗傘備傚傛傜傝傞傟傠傡傢
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俀` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '僜%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '%朶%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '%瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俁` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿係` WHERE `俠侾` LIKE ' %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿係` WHERE `俠侾` LIKE '% %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿係` WHERE `俠侾` LIKE '% ';
俠侾
SELECT * FROM `俿係` WHERE `俠侾` LIKE '<27>%';
俠侾
懒旅呐魄壬仕掏蜗
SELECT * FROM `俿係` WHERE `俠侾` LIKE '%棕%';
俠侾
醒矣哉肿刭谯茌捱
SELECT * FROM `俿係` WHERE `俠侾` LIKE '%<25>';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿係` WHERE `俠侾` LIKE '氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿係` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿係` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%丂';
俠侾
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '偲%';
俠侾
偲偳側偵偸偹偺偼偽傁傂傃傄傆傇傉傊傋傌傎
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%偁%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%傢';
俠侾
傏傐傑傒傓傔傕傖傗傘備傚傛傜傝傞傟傠傡傢
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俆` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '僜%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '%朶%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '%瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俇` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俈` WHERE `俠侾` LIKE ' %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '% %';
俠侾
 !"#$%&'()*+,-./
 、￥ウЖ┆<D096><E29486><EFBFBD>
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '% ';
俠侾
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '<27>%';
俠侾
懒旅呐魄壬仕掏蜗
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '%棕%';
俠侾
醒矣哉肿刭谯茌捱
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '%<25>';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究%';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俈` WHERE `俠侾` LIKE '%氨渤吹斗腹夯冀究';
俠侾
氨渤吹斗腹夯冀究
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%丂%';
俠侾
丂丂丄丅丆丏丒丗丟丠両丣並丩丮丯丱丳丵丷
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%丂';
俠侾
丒丒侌侎侐侒侓侕侖侘丒丒丒丒侟丒丒丒丒丂
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '偲%';
俠侾
偲偳側偵偸偹偺偼偽傁傂傃傄傆傇傉傊傋傌傎
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%偁%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%傢';
俠侾
傏傐傑傒傓傔傕傖傗傘備傚傛傜傝傞傟傠傡傢
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙%';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俉` WHERE `俠侾` LIKE '%丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙';
俠侾
丒偀偁偂偄偅偆偉偊偋偍偐偑偒偓偔偖偗偘偙
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '僜%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '%朶%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '%瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄%';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
SELECT * FROM `俿俋` WHERE `俠侾` LIKE '%僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄';
俠侾
僜廫昞梊峔塡嶾怽揬擻朶榎慭抃橽歕沑淺漒瀄
DROP TABLE `俿侾`;
DROP TABLE `俿俀`;
DROP TABLE `俿俁`;
DROP TABLE `俿係`;
DROP TABLE `俿俆`;
DROP TABLE `俿俇`;
DROP TABLE `俿俈`;
DROP TABLE `俿俉`;
DROP TABLE `俿俋`;