Debian Codegraph @

mysql-test/suite/jp/t/jp_ltrim_utf8.test

raw
1 --source include/have_utf8.inc
2 --source include/have_innodb.inc
3 --disable_warnings
4 drop table if exists `T1`;
5 drop table if exists `T2`;
6 drop table if exists `T3`;
7 drop table if exists `T4`;
8 drop table if exists `T5`;
9 drop table if exists `T6`;
10 drop table if exists `T7`;
11 drop table if exists `T8`;
12 drop table if exists `T9`;
13 --enable_warnings
14
15 #
16 # Test LTRIM() function with Japanese characters in utf8 encoding
17 #
18
19 SET character_set_collations='utf8mb3=utf8mb3_general_ci';
20 SET NAMES utf8;
21 SET character_set_database = utf8;
22
23 CREATE TABLE `T1` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 CREATE TABLE `T2` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
25 CREATE TABLE `T3` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
26 CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
28 CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
29 CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
30 CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
31 CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
32
33 INSERT INTO `T1` VALUES ('アイウエオ');
34 INSERT INTO `T1` VALUES (' アイウエオ');
35 INSERT INTO `T1` VALUES (' アイウエオ');
36 INSERT INTO `T1` VALUES (' アイウエオ');
37 # Double byte spaces are not supposed to be trimed
38 INSERT INTO `T1` VALUES (' アイウエオ');
39 INSERT INTO `T1` VALUES ('  アイウエオ');
40 INSERT INTO `T1` VALUES ('   アイウエオ');
41 INSERT INTO `T2` VALUES ('あいうえお');
42 INSERT INTO `T2` VALUES (' あいうえお');
43 INSERT INTO `T2` VALUES (' あいうえお');
44 INSERT INTO `T2` VALUES (' あいうえお');
45 # Double byte spaces are not supposed to be trimed
46 INSERT INTO `T2` VALUES (' あいうえお');
47 INSERT INTO `T2` VALUES ('  あいうえお');
48 INSERT INTO `T2` VALUES ('   あいうえお');
49 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
50 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
51 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
52 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
53 # Double byte spaces are not supposed to be trimed
54 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
55 INSERT INTO `T3` VALUES ('  龔龖龗龞龡');
56 INSERT INTO `T3` VALUES ('   龔龖龗龞龡');
57 INSERT INTO `T4` VALUES ('アイウエオ');
58 INSERT INTO `T4` VALUES (' アイウエオ');
59 INSERT INTO `T4` VALUES (' アイウエオ');
60 INSERT INTO `T4` VALUES (' アイウエオ');
61 # Double byte spaces are not supposed to be trimed
62 INSERT INTO `T4` VALUES (' アイウエオ');
63 INSERT INTO `T4` VALUES ('  アイウエオ');
64 INSERT INTO `T4` VALUES ('   アイウエオ');
65 INSERT INTO `T5` VALUES ('あいうえお');
66 INSERT INTO `T5` VALUES (' あいうえお');
67 INSERT INTO `T5` VALUES (' あいうえお');
68 INSERT INTO `T5` VALUES (' あいうえお');
69 # Double byte spaces are not supposed to be trimed
70 INSERT INTO `T5` VALUES (' あいうえお');
71 INSERT INTO `T5` VALUES ('  あいうえお');
72 INSERT INTO `T5` VALUES ('   あいうえお');
73 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
74 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
75 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
76 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
77 # Double byte spaces are not supposed to be trimed
78 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
79 INSERT INTO `T6` VALUES ('  龔龖龗龞龡');
80 INSERT INTO `T6` VALUES ('   龔龖龗龞龡');
81 INSERT INTO `T7` VALUES ('アイウエオ');
82 INSERT INTO `T7` VALUES (' アイウエオ');
83 INSERT INTO `T7` VALUES (' アイウエオ');
84 INSERT INTO `T7` VALUES (' アイウエオ');
85 # Double byte spaces are not supposed to be trimed
86 INSERT INTO `T7` VALUES (' アイウエオ');
87 INSERT INTO `T7` VALUES ('  アイウエオ');
88 INSERT INTO `T7` VALUES ('   アイウエオ');
89 INSERT INTO `T8` VALUES ('あいうえお');
90 INSERT INTO `T8` VALUES (' あいうえお');
91 INSERT INTO `T8` VALUES (' あいうえお');
92 INSERT INTO `T8` VALUES (' あいうえお');
93 # Double byte spaces are not supposed to be trimed
94 INSERT INTO `T8` VALUES (' あいうえお');
95 INSERT INTO `T8` VALUES ('  あいうえお');
96 INSERT INTO `T8` VALUES ('   あいうえお');
97 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
98 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
99 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
100 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
101 # Double byte spaces are not supposed to be trimed
102 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
103 INSERT INTO `T9` VALUES ('  龔龖龗龞龡');
104 INSERT INTO `T9` VALUES ('   龔龖龗龞龡');
105
106 #InnoDB
107 SELECT LTRIM(`C1`) from `T1`;
108 SELECT LTRIM(`C1`) from `T2`;
109 SELECT LTRIM(`C1`) from `T3`;
110
111 #MyISAM
112 SELECT LTRIM(`C1`) from `T4`;
113 SELECT LTRIM(`C1`) from `T5`;
114 SELECT LTRIM(`C1`) from `T6`;
115
116 #MEMORY
117 SELECT LTRIM(`C1`) from `T7`;
118 SELECT LTRIM(`C1`) from `T8`;
119 SELECT LTRIM(`C1`) from `T9`;
120
121 DROP TABLE `T1`;
122 DROP TABLE `T2`;
123 DROP TABLE `T3`;
124 DROP TABLE `T4`;
125 DROP TABLE `T5`;
126 DROP TABLE `T6`;
127 DROP TABLE `T7`;
128 DROP TABLE `T8`;
129 DROP TABLE `T9`;