jp_ltrim_utf8.test 5.57 KB
Newer Older
mleich@five.local.lan's avatar
mleich@five.local.lan committed
1 2
--source include/have_utf8.inc
--source include/have_innodb.inc
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
--disable_warnings
drop table if exists `T1`;
drop table if exists `T2`;
drop table if exists `T3`;
drop table if exists `T4`;
drop table if exists `T5`;
drop table if exists `T6`;
drop table if exists `T7`;
drop table if exists `T8`;
drop table if exists `T9`;
--enable_warnings

#
# Test LTRIM() function with Japanese characters in utf8 encoding
#

SET NAMES utf8;
SET character_set_database = utf8;

CREATE TABLE `T1` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T2` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T3` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
mleich@five.local.lan's avatar
mleich@five.local.lan committed
28 29 30
CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114

INSERT INTO `T1` VALUES ('アイウエオ');
INSERT INTO `T1` VALUES (' アイウエオ');
INSERT INTO `T1` VALUES ('  アイウエオ');
INSERT INTO `T1` VALUES ('   アイウエオ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T1` VALUES (' アイウエオ');
INSERT INTO `T1` VALUES ('  アイウエオ');
INSERT INTO `T1` VALUES ('   アイウエオ');
INSERT INTO `T2` VALUES ('あいうえお');
INSERT INTO `T2` VALUES (' あいうえお');
INSERT INTO `T2` VALUES ('  あいうえお');
INSERT INTO `T2` VALUES ('   あいうえお');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T2` VALUES (' あいうえお');
INSERT INTO `T2` VALUES ('  あいうえお');
INSERT INTO `T2` VALUES ('   あいうえお');
INSERT INTO `T3` VALUES ('龔龖龗龞龡');
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
INSERT INTO `T3` VALUES ('  龔龖龗龞龡');
INSERT INTO `T3` VALUES ('   龔龖龗龞龡');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
INSERT INTO `T3` VALUES ('  龔龖龗龞龡');
INSERT INTO `T3` VALUES ('   龔龖龗龞龡');
INSERT INTO `T4` VALUES ('アイウエオ');
INSERT INTO `T4` VALUES (' アイウエオ');
INSERT INTO `T4` VALUES ('  アイウエオ');
INSERT INTO `T4` VALUES ('   アイウエオ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T4` VALUES (' アイウエオ');
INSERT INTO `T4` VALUES ('  アイウエオ');
INSERT INTO `T4` VALUES ('   アイウエオ');
INSERT INTO `T5` VALUES ('あいうえお');
INSERT INTO `T5` VALUES (' あいうえお');
INSERT INTO `T5` VALUES ('  あいうえお');
INSERT INTO `T5` VALUES ('   あいうえお');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T5` VALUES (' あいうえお');
INSERT INTO `T5` VALUES ('  あいうえお');
INSERT INTO `T5` VALUES ('   あいうえお');
INSERT INTO `T6` VALUES ('龔龖龗龞龡');
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
INSERT INTO `T6` VALUES ('  龔龖龗龞龡');
INSERT INTO `T6` VALUES ('   龔龖龗龞龡');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
INSERT INTO `T6` VALUES ('  龔龖龗龞龡');
INSERT INTO `T6` VALUES ('   龔龖龗龞龡');
INSERT INTO `T7` VALUES ('アイウエオ');
INSERT INTO `T7` VALUES (' アイウエオ');
INSERT INTO `T7` VALUES ('  アイウエオ');
INSERT INTO `T7` VALUES ('   アイウエオ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T7` VALUES (' アイウエオ');
INSERT INTO `T7` VALUES ('  アイウエオ');
INSERT INTO `T7` VALUES ('   アイウエオ');
INSERT INTO `T8` VALUES ('あいうえお');
INSERT INTO `T8` VALUES (' あいうえお');
INSERT INTO `T8` VALUES ('  あいうえお');
INSERT INTO `T8` VALUES ('   あいうえお');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T8` VALUES (' あいうえお');
INSERT INTO `T8` VALUES ('  あいうえお');
INSERT INTO `T8` VALUES ('   あいうえお');
INSERT INTO `T9` VALUES ('龔龖龗龞龡');
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
INSERT INTO `T9` VALUES ('  龔龖龗龞龡');
INSERT INTO `T9` VALUES ('   龔龖龗龞龡');
# Double byte spaces are not supposed to be trimed
INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
INSERT INTO `T9` VALUES ('  龔龖龗龞龡');
INSERT INTO `T9` VALUES ('   龔龖龗龞龡');

#InnoDB
SELECT LTRIM(`C1`) from `T1`;
SELECT LTRIM(`C1`) from `T2`;
SELECT LTRIM(`C1`) from `T3`;

#MyISAM
SELECT LTRIM(`C1`) from `T4`;
SELECT LTRIM(`C1`) from `T5`;
SELECT LTRIM(`C1`) from `T6`;

mleich@five.local.lan's avatar
mleich@five.local.lan committed
115
#MEMORY
116 117 118 119 120 121 122 123 124 125 126 127 128
SELECT LTRIM(`C1`) from `T7`;
SELECT LTRIM(`C1`) from `T8`;
SELECT LTRIM(`C1`) from `T9`;

DROP TABLE `T1`;
DROP TABLE `T2`;
DROP TABLE `T3`;
DROP TABLE `T4`;
DROP TABLE `T5`;
DROP TABLE `T6`;
DROP TABLE `T7`;
DROP TABLE `T8`;
DROP TABLE `T9`;