Debian Codegraph @

mysql-test/suite/jp/r/jp_rtrim_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 RTRIM(`C1`) from `T1`;
108 RTRIM(`C1`)
109 アイウエオ
110 アイウエオ
111 アイウエオ
112 アイウエオ
113 アイウエオ 
114 アイウエオ  
115 アイウエオ   
116 SELECT RTRIM(`C1`) from `T2`;
117 RTRIM(`C1`)
118 あいうえお
119 あいうえお
120 あいうえお
121 あいうえお
122 あいうえお 
123 あいうえお  
124 あいうえお   
125 SELECT RTRIM(`C1`) from `T3`;
126 RTRIM(`C1`)
127 龔龖龗龞龡
128 龔龖龗龞龡
129 龔龖龗龞龡
130 龔龖龗龞龡
131 龔龖龗龞龡 
132 龔龖龗龞龡  
133 龔龖龗龞龡   
134 SELECT RTRIM(`C1`) from `T4`;
135 RTRIM(`C1`)
136 アイウエオ
137 アイウエオ
138 アイウエオ
139 アイウエオ
140 アイウエオ 
141 アイウエオ  
142 アイウエオ   
143 SELECT RTRIM(`C1`) from `T5`;
144 RTRIM(`C1`)
145 あいうえお
146 あいうえお
147 あいうえお
148 あいうえお
149 あいうえお 
150 あいうえお  
151 あいうえお   
152 SELECT RTRIM(`C1`) from `T6`;
153 RTRIM(`C1`)
154 龔龖龗龞龡
155 龔龖龗龞龡
156 龔龖龗龞龡
157 龔龖龗龞龡
158 龔龖龗龞龡 
159 龔龖龗龞龡  
160 龔龖龗龞龡   
161 SELECT RTRIM(`C1`) from `T7`;
162 RTRIM(`C1`)
163 アイウエオ
164 アイウエオ
165 アイウエオ
166 アイウエオ
167 アイウエオ 
168 アイウエオ  
169 アイウエオ   
170 SELECT RTRIM(`C1`) from `T8`;
171 RTRIM(`C1`)
172 あいうえお
173 あいうえお
174 あいうえお
175 あいうえお
176 あいうえお 
177 あいうえお  
178 あいうえお   
179 SELECT RTRIM(`C1`) from `T9`;
180 RTRIM(`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`;