jp_trim_ucs2.test

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

--source include/have_ucs2.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 `Ｔ１０`;
--enable_warnings

#
# Test TRIM() function with Japanese characters ucs2 encoding
#

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

CREATE TABLE `Ｔ１` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `Ｔ２` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `Ｔ３` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `Ｔ４` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `Ｔ５` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `Ｔ６` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `Ｔ７` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `Ｔ８` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `Ｔ９` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `Ｔ１０` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = bdb;
CREATE TABLE `Ｔ１１` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = bdb;
CREATE TABLE `Ｔ１２` (`Ｃ１` char(12), INDEX(`Ｃ１`)) DEFAULT CHARSET = ucs2 engine = bdb;

# Nothing to trim
INSERT INTO `Ｔ１` VALUES ('幈幉幊幋幍');
# Test data for TRIM(TRAILING [remstr] FROM str)
INSERT INTO `Ｔ１` VALUES ('幈幉幊幋幍幎');
INSERT INTO `Ｔ１` VALUES ('幈幉幊幋幍幎幎');
INSERT INTO `Ｔ１` VALUES ('幈幉幊幋幍幎幎幎');
# Test data for TRIM(LEADING [remstr] FROM str)
INSERT INTO `Ｔ１` VALUES ('幎幈幉幊幋幍');
INSERT INTO `Ｔ１` VALUES ('幎幎幈幉幊幋幍');
INSERT INTO `Ｔ１` VALUES ('幎幎幎幈幉幊幋幍');
# Test data for TRIM(BOTH [remstr] FROM str)
INSERT INTO `Ｔ１` VALUES ('幎幎幎幈幉幊幋幍幎幎幎');
# Test data for TRIM without [remstr] (remove spaces) 
INSERT INTO `Ｔ１` VALUES ('   幈幉幊幋幍   ');
INSERT INTO `Ｔ２` VALUES ('あいうえお');
INSERT INTO `Ｔ２` VALUES ('あいうえおか');
INSERT INTO `Ｔ２` VALUES ('あいうえおかか');
INSERT INTO `Ｔ２` VALUES ('あいうえおかかか');
INSERT INTO `Ｔ２` VALUES ('かあいうえお');
INSERT INTO `Ｔ２` VALUES ('かかあいうえお');
INSERT INTO `Ｔ２` VALUES ('かかかあいうえお');
INSERT INTO `Ｔ２` VALUES ('かかかあいうえおかかか');
INSERT INTO `Ｔ２` VALUES ('   あいうえお   ');
INSERT INTO `Ｔ３` VALUES ('忢軓磔忢迯磉忢