Debian Codegraph @

mysql-test/suite/jp/r/jp_ltrim_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 SET character_set_database = utf8;
14 Warnings:
15 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `T2` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `T3` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
35 CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
44 INSERT INTO `T1` VALUES ('アイウエオ');
45 INSERT INTO `T1` VALUES (' アイウエオ');
46 INSERT INTO `T1` VALUES (' アイウエオ');
47 INSERT INTO `T1` VALUES (' アイウエオ');
48 INSERT INTO `T1` VALUES (' アイウエオ');
49 INSERT INTO `T1` VALUES ('  アイウエオ');
50 INSERT INTO `T1` VALUES ('   アイウエオ');
51 INSERT INTO `T2` VALUES ('あいうえお');
52 INSERT INTO `T2` VALUES (' あいうえお');
53 INSERT INTO `T2` VALUES (' あいうえお');
54 INSERT INTO `T2` VALUES (' あいうえお');
55 INSERT INTO `T2` VALUES (' あいうえお');
56 INSERT INTO `T2` VALUES ('  あいうえお');
57 INSERT INTO `T2` VALUES ('   あいうえお');
58 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
59 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
60 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
61 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
62 INSERT INTO `T3` VALUES (' 龔龖龗龞龡');
63 INSERT INTO `T3` VALUES ('  龔龖龗龞龡');
64 INSERT INTO `T3` VALUES ('   龔龖龗龞龡');
65 INSERT INTO `T4` VALUES ('アイウエオ');
66 INSERT INTO `T4` VALUES (' アイウエオ');
67 INSERT INTO `T4` VALUES (' アイウエオ');
68 INSERT INTO `T4` VALUES (' アイウエオ');
69 INSERT INTO `T4` VALUES (' アイウエオ');
70 INSERT INTO `T4` VALUES ('  アイウエオ');
71 INSERT INTO `T4` VALUES ('   アイウエオ');
72 INSERT INTO `T5` VALUES ('あいうえお');
73 INSERT INTO `T5` VALUES (' あいうえお');
74 INSERT INTO `T5` VALUES (' あいうえお');
75 INSERT INTO `T5` VALUES (' あいうえお');
76 INSERT INTO `T5` VALUES (' あいうえお');
77 INSERT INTO `T5` VALUES ('  あいうえお');
78 INSERT INTO `T5` VALUES ('   あいうえお');
79 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
80 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
81 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
82 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
83 INSERT INTO `T6` VALUES (' 龔龖龗龞龡');
84 INSERT INTO `T6` VALUES ('  龔龖龗龞龡');
85 INSERT INTO `T6` VALUES ('   龔龖龗龞龡');
86 INSERT INTO `T7` VALUES ('アイウエオ');
87 INSERT INTO `T7` VALUES (' アイウエオ');
88 INSERT INTO `T7` VALUES (' アイウエオ');
89 INSERT INTO `T7` VALUES (' アイウエオ');
90 INSERT INTO `T7` VALUES (' アイウエオ');
91 INSERT INTO `T7` VALUES ('  アイウエオ');
92 INSERT INTO `T7` VALUES ('   アイウエオ');
93 INSERT INTO `T8` VALUES ('あいうえお');
94 INSERT INTO `T8` VALUES (' あいうえお');
95 INSERT INTO `T8` VALUES (' あいうえお');
96 INSERT INTO `T8` VALUES (' あいうえお');
97 INSERT INTO `T8` VALUES (' あいうえお');
98 INSERT INTO `T8` VALUES ('  あいうえお');
99 INSERT INTO `T8` VALUES ('   あいうえお');
100 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
101 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
102 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
103 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
104 INSERT INTO `T9` VALUES (' 龔龖龗龞龡');
105 INSERT INTO `T9` VALUES ('  龔龖龗龞龡');
106 INSERT INTO `T9` VALUES ('   龔龖龗龞龡');
107 SELECT LTRIM(`C1`) from `T1`;
108 LTRIM(`C1`)
109 アイウエオ
110 アイウエオ
111 アイウエオ
112    アイウエオ
113   アイウエオ
114  アイウエオ
115 アイウエオ
116 SELECT LTRIM(`C1`) from `T2`;
117 LTRIM(`C1`)
118 あいうえお
119 あいうえお
120 あいうえお
121    あいうえお
122   あいうえお
123  あいうえお
124 あいうえお
125 SELECT LTRIM(`C1`) from `T3`;
126 LTRIM(`C1`)
127 龔龖龗龞龡
128 龔龖龗龞龡
129 龔龖龗龞龡
130    龔龖龗龞龡
131   龔龖龗龞龡
132  龔龖龗龞龡
133 龔龖龗龞龡
134 SELECT LTRIM(`C1`) from `T4`;
135 LTRIM(`C1`)
136 アイウエオ
137 アイウエオ
138 アイウエオ
139    アイウエオ
140   アイウエオ
141  アイウエオ
142 アイウエオ
143 SELECT LTRIM(`C1`) from `T5`;
144 LTRIM(`C1`)
145 あいうえお
146 あいうえお
147 あいうえお
148    あいうえお
149   あいうえお
150  あいうえお
151 あいうえお
152 SELECT LTRIM(`C1`) from `T6`;
153 LTRIM(`C1`)
154 龔龖龗龞龡
155 龔龖龗龞龡
156 龔龖龗龞龡
157    龔龖龗龞龡
158   龔龖龗龞龡
159  龔龖龗龞龡
160 龔龖龗龞龡
161 SELECT LTRIM(`C1`) from `T7`;
162 LTRIM(`C1`)
163 アイウエオ
164 アイウエオ
165 アイウエオ
166 アイウエオ
167  アイウエオ
168   アイウエオ
169    アイウエオ
170 SELECT LTRIM(`C1`) from `T8`;
171 LTRIM(`C1`)
172 あいうえお
173 あいうえお
174 あいうえお
175 あいうえお
176  あいうえお
177   あいうえお
178    あいうえお
179 SELECT LTRIM(`C1`) from `T9`;
180 LTRIM(`C1`)
181 龔龖龗龞龡
182 龔龖龗龞龡
183 龔龖龗龞龡
184 龔龖龗龞龡
185  龔龖龗龞龡
186   龔龖龗龞龡
187    龔龖龗龞龡
188 DROP TABLE `T1`;
189 DROP TABLE `T2`;
190 DROP TABLE `T3`;
191 DROP TABLE `T4`;
192 DROP TABLE `T5`;
193 DROP TABLE `T6`;
194 DROP TABLE `T7`;
195 DROP TABLE `T8`;
196 DROP TABLE `T9`;